From: Bruce Momjian <bruce@momjian.us>
To: Vladimir Borodin <root@simply.name>
Cc: Rob Emery <re-pgsql@codeweavers.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Major version upgrades + Replication
Date: Wed, 2 Dec 2015 21:04:32 -0500
Message-ID: <20151203020432.GA12780@momjian.us> (raw)
In-Reply-To: <DA4F4C7D-9E27-47A2-B9D1-F0B81E297399@simply.name>
References: <CAPCETptgbfBKPGpS8X8YG-T1O30q3FU44PMKeR7NhBvNOQz-bg@mail.gmail.com>
<DA4F4C7D-9E27-47A2-B9D1-F0B81E297399@simply.name>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Wed, Dec 2, 2015 at 07:48:55PM +0300, Vladimir Borodin wrote:
>
> 2 дек. 2015 г., в 18:55, Rob Emery <re-pgsql@codeweavers.net> написал(а):
>
> Hello,
>
> We have a setup with 1 primary, a synchronous replica and two asynchronous
> replicas all running on PostgreSQL 9.1. I'm in the progress of planning an
> upgrade to 9.4 so that we can make use of cascading replication.
>
> The process I'm planning currently is:
> □ Kill primary
> □ Upgrade primary to 9.4 with pg_upgrade --link
> □ Upgrade synchronous secondary with pg_upgrade —link
>
>
> No, it won’t work. See https://simply.name/upgrading-postgres-to-9.4.html and
> links from that post for details.
It will work if you use the 9.5 pg_upgrade instructions, which also work
in 9.4 and earlier:
http://momjian.us/main/blogs/pgblog/2015.html#June_10_2015
Vladimir is right that you have to do both upgrades while both servers
are down.
---------------------------------------------------------------------------
>
>
> At this point will the secondary replicate from the primary correctly or do
> I need to
> rsync everything across again?
>
> I understand that the 9.1 replicas won't be able to replicate from 9.4
> until they're upgraded; however I'm I'm hoping to essentially pg_upgrade
> all the replicas and avoid having to rsync the upgraded master to all it's
> replicas.
>
> Thanks,
> Rob
>
> [bc5d5152-e]
>
> Codeweavers November Newsletter l Latest from the company
>
> Phone: 0800 021 0888 Email: contactus@codeweavers.net
> Codeweavers Ltd | Barn 4 | Dunston Business Village | Dunston | ST18 9AB
> Registered in England and Wales No. 04092394 | VAT registration no. 974
> 9705 63
>
> ● ● ● ●
>
>
>
> --
> May the force be with you…
> https://simply.name
>
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: bruce@momjian.us, root@simply.name, re-pgsql@codeweavers.net
Subject: Re: Major version upgrades + Replication
In-Reply-To: <20151203020432.GA12780@momjian.us>
* 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