Re: Three Variations of postgresql.conf

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