[ADMIN] Upgrade master/slave: rsync?

Поиск
Список
Период
Сортировка
От Don Seiler
Тема [ADMIN] Upgrade master/slave: rsync?
Дата
Msg-id CAHJZqBA_Z_HYf13Mqg=T0uDWHpoxoUAxoAv3BUJsSPHNwNr+cw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [ADMIN] Upgrade master/slave: rsync?  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: [ADMIN] Upgrade master/slave: rsync?  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] pg_dump making schema output consistent.
Следующее
От: Ashok Kumar Tiwari
Дата:
Сообщение: [ADMIN] Configure Python 3