pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedupgrading postgresql cluster(3 nodes) to v10 without DOWNTIME
2+ messages / 2 participants
[nested] [flat]
* upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME
@ 2018-07-11 14:38 Mariel Cherkassky <mariel.cherkassky@gmail.com>
2018-07-11 16:06 ` Re: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Mariel Cherkassky @ 2018-07-11 14:38 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
I have in my company 3 postgresql nodes(v9.6) that are configured as one
primary and 2 slaves. The repmgr tool is reponsible for the replication. I
want to upgrade all the nodes to version 10.4. I know that PostgreSQL
doesnt support streaming replication between different major versions. Did
someone try this kind of upgrade without having any downtime ?
Thanks , Mariel.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME
2018-07-11 14:38 upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME Mariel Cherkassky <mariel.cherkassky@gmail.com>
@ 2018-07-11 16:06 ` John Scalia <jayknowsunix@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: John Scalia @ 2018-07-11 16:06 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
You can do this with the pglogical extension. I asked a similar question about a week ago.
—
Jay
Sent from my iPhone
> On Jul 11, 2018, at 10:38 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
>
> Hi,
> I have in my company 3 postgresql nodes(v9.6) that are configured as one primary and 2 slaves. The repmgr tool is reponsible for the replication. I want to upgrade all the nodes to version 10.4. I know that PostgreSQL doesnt support streaming replication between different major versions. Did someone try this kind of upgrade without having any downtime ?
>
> Thanks , Mariel.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-07-11 16:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-11 14:38 upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME Mariel Cherkassky <mariel.cherkassky@gmail.com>
2018-07-11 16:06 ` John Scalia <jayknowsunix@gmail.com>
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