pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Major version upgrades + Replication 3+ messages / 3 participants [nested] [flat]
* Major version upgrades + Replication @ 2015-12-02 15:55 Rob Emery <re-pgsql@codeweavers.net> 0 siblings, 1 reply; 3+ messages in thread From: Rob Emery @ 2015-12-02 15:55 UTC (permalink / raw) To: 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@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 <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; ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Major version upgrades + Replication @ 2015-12-02 16:48 Vladimir Borodin <root@simply.name> parent: Rob Emery <re-pgsql@codeweavers.net> 0 siblings, 1 reply; 3+ messages in thread From: Vladimir Borodin @ 2015-12-02 16:48 UTC (permalink / raw) To: Rob Emery <re-pgsql@codeweavers.net>; +Cc: pgsql-admin > 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 <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@codeweavers.net <mailto: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 > > <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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Major version upgrades + Replication @ 2015-12-03 02:04 Bruce Momjian <bruce@momjian.us> parent: Vladimir Borodin <root@simply.name> 0 siblings, 0 replies; 3+ messages in thread From: Bruce Momjian @ 2015-12-03 02:04 UTC (permalink / raw) To: Vladimir Borodin <root@simply.name>; +Cc: Rob Emery <re-pgsql@codeweavers.net>; pgsql-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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-12-03 02:04 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2015-12-02 15:55 Major version upgrades + Replication Rob Emery <re-pgsql@codeweavers.net> 2015-12-02 16:48 ` Vladimir Borodin <root@simply.name> 2015-12-03 02:04 ` Bruce Momjian <bruce@momjian.us>
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