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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
