2017-09-12 23:57 GMT+02:00 Don Seiler <don@seiler.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).