Major version upgrades + Replication - Mailing list pgsql-admin

From Rob Emery
Subject Major version upgrades + Replication
Date
Msg-id CAPCETptgbfBKPGpS8X8YG-T1O30q3FU44PMKeR7NhBvNOQz-bg@mail.gmail.com
Whole thread Raw
Responses Re: Major version upgrades + Replication
List 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




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 

      

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Find if a function is being referenced in another function in the database
Next
From: Vladimir Borodin
Date:
Subject: Re: Major version upgrades + Replication