Major version upgrades + Replication

From: Rob Emery <re-pgsql(at)codeweavers(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Major version upgrades + Replication
Date: 2015-12-02 15:55:50
Message-ID: CAPCETptgbfBKPGpS8X8YG-T1O30q3FU44PMKeR7NhBvNOQz-bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

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

--
<https://www.codeweavers.net>

Codeweavers November Newsletter
<http://us6.campaign-archive2.com/?u=db934935d4174e46e9063c8c4&id=2f013c63b5>
l Latest from the company <https://www.codeweavers.net/company-blog>

*Phone:* 0800 021 0888 * Email: *contactus(at)codeweavers(dot)net
*Codeweavers Ltd* | Barn 4 | Dunston Business Village | Dunston | ST18 9AB
Registered in England and Wales No. 04092394 | VAT registration no. 974
9705 63

<https://www.linkedin.com/company/codeweavers-limited>
<https://vimeo.com/codeweaversltd>
<https://plus.google.com/b/105942302039373248738/+CodeweaversNet/posts>
<https://twitter.com/CodeweaversTeam?lang=en-gb>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vladimir Borodin 2015-12-02 16:48:55 Re: Major version upgrades + Replication
Previous Message Tom Lane 2015-12-02 15:05:40 Re: Find if a function is being referenced in another function in the database