upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME
Date: 2018-07-11 14:38:01
Message-ID: CA+t6e1nrnU8En7FLJJbchruz-NydkT=-BO-QD46chGQdFyS0tQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2018-07-11 14:40:28 Re: row is too big: size 8168, maximum size 8160
Previous Message Mariel Cherkassky 2018-07-11 14:37:00 Re: invalid value for parameter "client_encoding": "ISO_8859_8"