[ADMIN] Upgrade master/slave: rsync? - Mailing list pgsql-admin

From Don Seiler
Subject [ADMIN] Upgrade master/slave: rsync?
Date
Msg-id CAHJZqBA_Z_HYf13Mqg=T0uDWHpoxoUAxoAv3BUJsSPHNwNr+cw@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] Upgrade master/slave: rsync?  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: [ADMIN] Upgrade master/slave: rsync?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Planning steps to upgrade our 9.2 DB to the latest stable 9.6 using pg_upgrade. I've gone through the steps for a primary/standalone DB and they work well. Looking into how then to upgrade the standby, the documentation says that the data_dir from the master should be rsync'ed to each slave.

Is this truly the case? Having to copy all the data from the primary will be a huge issue for our larger databases. I had hoped we'd just need to upgrade the binaries, copy the old data dir to the new data dir, update conf files as needed and turn it back on (similar to Oracle standby upgrade).

Don.

--
Don Seiler
www.seiler.us

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] pg_dump making schema output consistent.
Next
From: Ashok Kumar Tiwari
Date:
Subject: [ADMIN] Configure Python 3