Postgres Pro
Downloads
Home   >   mailing lists

upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME - Mailing list pgsql-admin

From Mariel Cherkassky
Subject upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME
Date
Msg-id CA+t6e1nrnU8En7FLJJbchruz-NydkT=-BO-QD46chGQdFyS0tQ@mail.gmail.com
Whole thread Raw
Responses Re: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: invalid value for parameter "client_encoding": "ISO_8859_8"
Next
From: Tom Lane
Date:
Subject: Re: row is too big: size 8168, maximum size 8160