Re: Three Variations of postgresql.conf

[Melvin Davidson <melvin6925@xxxxxxxxx>]

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 following on one server:

Ver Cluster Port Status Owner    Data directory                    Log file
9.1  prod    5432 online  postgres /var/lib/postgresql/9.1/prod /var/log/postgresql/postgresql-9.1-prod.log
9.1  dev      5433 online postgres /var/lib/postgresql/9.1/dev   /var/log/postgresql/postgresql-9.1-dev.log
9.4  prod    5435 online  postgres /var/lib/postgresql/9.4/prod /var/log/postgresql/postgresql-9.4-prod.log
9.4  dev      5436 online postgres /var/lib/postgresql/9.4/dev   /var/log/postgresql/postgresql-9.4-dev.log
9.4  qa       5437 online postgres /var/lib/postgresql/9.4/qa    /var/log/postgresql/postgresql-9.4-qa.log

On Thu, Nov 12, 2015 at 11:56 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

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 Owner    Data directory               Log file

9.3 main    5432 down   postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log

9.4 main    5434 online postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log

You get the $DATA directories and the log files. The config directories are in /etc/postgresql/*

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 the 9.4 version of PostgreSQL is active and
will also show you the command line arguments used to start it.


On Thu, Nov 12, 2015 at 11:29 AM, Tom Lane <tgl@xxxxxxxxxxxxx
<mailto:tgl@xxxxxxxxxxxxx>> wrote:

    Adrian Klaver <adrian.klaver@xxxxxxxxxxx
    <mailto:adrian.klaver@xxxxxxxxxxx>> 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
    >> /usr/lib/tmpfiles.d/postgresql.conf
    >> /etc/postgresql/9.4/main/postgresql.conf

    FWIW, I would imagine that /usr/lib/tmpfiles.d/postgresql.conf is
    a configuration file for the system's tmp-file-cleaner daemon
    (probably telling it not to flush some postgres-related files),
    not a PG config file at all.  If you look into it you'll likely
    find that it doesn't look anything like PG configuration data.

    As already noted, postgresql.auto.conf is not for hand-editing.

                             regards, tom lane




--
*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.klaver@xxxxxxxxxxx

--

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