1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • Linux Recommended Installation Directory

    From gargoyle60@21:1/5 to All on Tue Oct 11 11:51:37 2016
    I have Lubuntu 14.04 (32-bit) on an i386 machine and have downloaded the interactive installer by
    EnterpriseDB for version 9.4.9 (postgresql-9.4.9-2-linux.run).

    As my usual approach for installing on Linux I have always chosen to install with PGDATA set as
    "/var/lib/postgresql/9.4" but I notice that the interactive installer prompts to use /opt rather
    than /var.

    What are the general thoughts regarding the recommended directory?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Robert Klemme@21:1/5 to All on Wed Oct 19 00:32:08 2016
    I think it's more interesting on what device you put your db files (IO bandwidth, fault tolerance etc.).

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Benoit Izac@21:1/5 to gargoyle60@example.invalid on Wed Oct 19 18:24:45 2016
    gargoyle60 <gargoyle60@example.invalid> writes:

    I have Lubuntu 14.04 (32-bit) on an i386 machine and have downloaded
    the interactive installer by
    EnterpriseDB for version 9.4.9 (postgresql-9.4.9-2-linux.run).

    As my usual approach for installing on Linux I have always chosen to
    install with PGDATA set as
    "/var/lib/postgresql/9.4" but I notice that the interactive installer
    prompts to use /opt rather
    than /var.

    What are the general thoughts regarding the recommended directory?

    For Linux, this is documented in hier(7), /opt is for static data,
    /var/opt/ is for variable data.

    --
    Benoit Izac

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)