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.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to