From: Stéphane KANSCHINE <stephane@hexack.fr>
To: Erika Knihti-Van Driessche <erika.knihti@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
Date: Tue, 8 Jan 2019 09:50:32 +0100
Message-ID: <20190108085032.okxliytuo3pfyyu7@office.hexack.fr> (raw)
In-Reply-To: <CALgXhV-Hi0rL8cakzBp3cL33EobCwuCyC9UWY2MY2m8BGFbOnA@mail.gmail.com>
References: <CALgXhV_8SKtraLOYWtJcqL4_9X9i9WT94Wx2-1sp99ZyvJy6WQ@mail.gmail.com>
<CAGDYbUOy1kreTzTDx1uFfOCuNFeGdduW+iRhBjcdJk7vewqSzw@mail.gmail.com>
<FE3AE60D-1B69-45A8-823C-75A7761EAF53@gmail.com>
<20190107143621.5byvsoedlriok3ft@office.hexack.fr>
<CALgXhV-Hi0rL8cakzBp3cL33EobCwuCyC9UWY2MY2m8BGFbOnA@mail.gmail.com>
Le mar. 8 janv., vers 08:13, Erika Knihti-Van Driessche exprimait :
> Hi,
Hey !
> I'm sure I'd regret creationg all the extra work for myself, but.. the
> customer insists that not all (at least production) applications may go
> down at the same time.
That's precisely the purpose of services or init script if you prefer.
For a customer, i manage 10 clusters x 5 environments, entirely with 1
service per cluster and 1 binary per environment. I also use ansible
to deploy and maintain streaming replication, logical migration,
monitoring, all based on services. It's easy with Debian packages,
because service creation is included.
> I have streaming replication in place also, and I think for minor upgrade
> it won't be a problem to first upgrade standby, resync replication, then
> failover primary to newer minor version standby (altho I did read that this
> is not supported but will likely work..).
It'll work.
> For major upgrade this isn't an option though, or I would have to
> implement Slony (I think)..
Why don't you use logical replication ? I recently migrate the 10x5
clusters from 9.6 to 10 with pglogical in 2 days of work. It was also
from Red Hat to Debian and i automate cluster per cluster with
services. Next step is to migrate from 10 to 11, also with logical
migration, by hand this time, because pglogical don't do so much and
due to the lack of documentation, i already wrote the missing parts.
> So, just creating separate services isn't really an option, because
> it won't help me with the upgrades.
It does as the major version is in the service name (i.e.
postgresql@<version>-<clustername>), you won't have to update it once
it's written.
Regards,
--
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane@hexack.fr
+33 6 64 31 72 52
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stephane@hexack.fr, erika.knihti@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Multiple postgresql clusters with same version and separate binaries
In-Reply-To: <20190108085032.okxliytuo3pfyyu7@office.hexack.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox