[GENERAL] Three Variations of postgresql.conf

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

Re: [GENERAL] Three Variations of postgresql.conf

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:

Re: [GENERAL] Three Variations of postgresql.conf

Oops, I forgot to mention pg_initicluster, which is used to initiate the various version/cluster combinations in Ubuntu. It makes it easier to have several versions and clusters on the same server, albeit that is not what most people/companies usually do. eg: In Ubuntu, you could possibly have the

Re: [GENERAL] Three Variations of postgresql.conf

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,

Re: [GENERAL] Three Variations of postgresql.conf

On 11/12/2015 08:37 AM, Melvin Davidson wrote: To clarify. To see the ACTUAL clusters installed, and the LIVE config directories, you use pg_lsclusters. Actually: aklaver@arkansas:~$ pg_lsclusters Ver Cluster Port Status OwnerData directory Log file 9.3 main5432 down

Re: [GENERAL] Three Variations of postgresql.conf

To clarify. To see the ACTUAL clusters installed, and the LIVE config directories, you use pg_lsclusters. pg_ctlclusters then can control each individual cluster So, for example, since apparently you have the 9.4 version of PostgreSQL, pg_ctlcluster 9.4 main status would probably show you that

Re: [GENERAL] Three Variations of postgresql.conf

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 &

Re: [GENERAL] Three Variations of postgresql.conf

Adrian Klaver writes: > On 11/12/2015 08:07 AM, Melvin Davidson 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 >>