From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com>, Michael Convey <smconvey(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Three Variations of postgresql.conf |
Date: | 2015-11-12 16:21:14 |
Message-ID: | 5644BC7A.8010000@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/12/2015 08:07 AM, Melvin Davidson wrote:
> 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
No, it is the actual conf file for the cluster.
> /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.
No, as you can see if look in the file:
# Do not edit this file manually!
# It will be overwritten by the ALTER SYSTEM command.
There is no pg_hba.conf file in /var/lib/postgresql/9.4/main/ it is in
/etc/postgresql/9.4/main/
/etc/postgresql/* is where configuration is done, with the exception of
those done through ALTER SYSTEM, which are persisted in
postgresql.auto.conf.
>
> On Thu, Nov 12, 2015 at 10:46 AM, Michael Convey <smconvey(at)gmail(dot)com
> <mailto:smconvey(at)gmail(dot)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.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-11-12 16:29:26 | Re: Three Variations of postgresql.conf |
Previous Message | Melvin Davidson | 2015-11-12 16:07:03 | Re: Three Variations of postgresql.conf |