Re: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME
Date: 2018-07-11 16:06:44
Message-ID: B026F1CB-EC28-4141-A019-2955F8FEE274@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)cherkassky(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2018-07-11 16:17:38 Re: row is too big: size 8168, maximum size 8160
Previous Message ramsiddu007 2018-07-11 15:49:27 Re: row is too big: size 8168, maximum size 8160