Re: Major version upgrades + Replication

> 2 дек. 2015 г., в 18:55, Rob Emery <re-pgsql(at)codeweavers(dot)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 <https://simply.name/upgrading-postgres-to-9.4.html> and links from that post for details.

> 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 <mailto: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>

--
May the force be with you…
https://simply.name