Date: Wed, 2 Dec 2015 21:04:32 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Vladimir Borodin <root@simply.name>
Cc: Rob Emery <re-pgsql@codeweavers.net>, pgsql-admin@postgresql.org
Subject: Re: Major version upgrades + Replication
Message-ID: <20151203020432.GA12780@momjian.us>
References: 
 <CAPCETptgbfBKPGpS8X8YG-T1O30q3FU44PMKeR7NhBvNOQz-bg@mail.gmail.com>
 <DA4F4C7D-9E27-47A2-B9D1-F0B81E297399@simply.name>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <DA4F4C7D-9E27-47A2-B9D1-F0B81E297399@simply.name>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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