On 11/12/2015 07:46 AM, Michael Convey wrote:
> In Ubuntu 14.10, there are three variations of the postgresql.conf
> configuration file, as follows:
>
> /var/lib/postgresql/9.4/main/postgresql.auto.conf
The above is for when you do ALTER SYSTEM:
http://www.postgresql.org/docs/9.4/interactive/sql-altersystem.html
> /usr/lib/tmpfiles.d/postgresql.conf
This is system file that the OS seems to be using to determine where to
run Postgres sockets, create temp files, etc:
"# Directory for PostgreSQL sockets, lockfiles and stats tempfiles
d /var/run/postgresql 2775 postgres postgres - -
# Log directory
d /var/log/postgresql 1775 root postgres - -
"
I would leave this one alone.
In my 14.04 install there are also files for sshd and xconsole.
> /etc/postgresql/9.4/main/postgresql.conf
The above is the primary conf file for the cluster. This is where you
want to change variables, if you are not using ALTER SYSTEM.
>
> What is the difference between these files and which is the correct one
> to change for modifying the configurations contained therein?
--
Adrian Klaver
adrian.klaver@aklaver.com