Postgres Pro
Downloads
Home   >   mailing lists

Re: Three Variations of postgresql.conf - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Three Variations of postgresql.conf
Date
Msg-id CANu8FiygR5CdeqRTiE0YM+BQk6aK+qZyw2frH_FWV27J1exong@mail.gmail.com
Whole thread Raw
In response to Three Variations of postgresql.conf  (Michael Convey <smconvey@gmail.com>)
Responses Re: Three Variations of postgresql.conf
List pgsql-general
Tree view
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@gmail.com> 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Three Variations of postgresql.conf
Next
From: Adrian Klaver
Date:
Subject: Re: Three Variations of postgresql.conf