Re: Upgrade master/slave: rsync?

2017-09-12 23:57 GMT+02:00 Don Seiler <don(at)seiler(dot)us>:

> 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?
>

It is.

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).
>
>

--
Guillaume.