Re: A change in the Debian install

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "rob stone" <floriparob(at)gmail(dot)com>
Cc: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>,"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: A change in the Debian install
Date: 2017-04-08 11:55:52
Message-ID: a9b73a3e-c13b-4ae7-8211-ed8dc67a3054@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rob stone wrote:

> You create a new cluster by running initdb:-
>
> initdb -D /path/to/my/new/cluster

No, if you want to use the infrastructure brought by the
debian packages for your cluster, it should be created with:
pg_createcluster 9.5 nameofcluster

See https://wiki.debian.org/PostgreSql
or the manpages of pg_createcluster and pg_wrapper.

> So, if you want to have multiple clusters with each one using its own
> postgresql.conf, then you have to eliminate those files from the /etc
> path, or alter your start-up scripts to use the config_file parameter.
> Note that this also applies to the other two conf files.

When using the abovementioned commands you don't need or want
to do that, because /etc/postgresql/<version>/<cluster> is the
only place they're going to be in.

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Iliffe 2017-04-08 13:12:43 Re: Unable to connect to Postgresql
Previous Message Tom DalPozzo 2017-04-08 08:15:52 Re: keeping WAL after dropping replication slots