Re: Three Variations of postgresql.conf

[Melvin Davidson <melvin6925@xxxxxxxxx>]

Ubuntu does not use the standard pg_ctl for postgreSQL. Instead, it uses pg_ctlcluster.

That in turn controls the different PostgreSQL clusters. When you do an install of a new cluster, pg_ctlcluster is smart enough to put postgresql.conf & pg_hba.conf into separate dirs.

So to be specific, /usr/lib/tmpfiles.d/postgresql.conf is just a tmp file that you can ingnore, /etc/postgresql/9.4/main/postgresql.conf is the original version for the 9.4 cluster and /var/lib/postgresql/9.4/main/postgresql.auto.conf is the actual, live version of the 9.4 cluster that you need to change to affect the 9.4 cluster. Likewise for the pg_hba.conf.

On Thu, Nov 12, 2015 at 10:46 AM, Michael Convey <smconvey@xxxxxxxxx> 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

/usr/lib/tmpfiles.d/postgresql.conf

/etc/postgresql/9.4/main/postgresql.conf

What is the difference between these files and which is the correct one to change for modifying the configurations contained therein?

--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.