Re: Upgrading hot standbys

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Upgrading hot standbys
Дата
Msg-id CABUevEw10_xOg_2iUyQaBraUytKXtf3faAL+ekLNQB2QFepXuQ@mail.gmail.com
обсуждение исходный текст
Ответ на Upgrading hot standbys  (Aaron Burnett <Aaron.Burnett@us.dunnhumby.com>)
Ответы Re: Upgrading hot standbys  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
On Wed, Apr 29, 2015 at 6:19 AM, Aaron Burnett <Aaron.Burnett@us.dunnhumby.com> wrote:


Greetings,


I'm in the process of upgrading PG 9.1.3 to 9.4.1 in the near future.


I have several machines which each house unique databases. Each of those are replicated to a standby server with matching configurations. A total of 10 servers, 5 masters, 5 slaves. Everything runs on Ubuntu.


My question, as I can't seem to find any documentation on this part, is once I successfully upgrade the master I will need to upgrade the standby as well. Will I have to rebuild the standby from scratch, or will the standby pick up where it was before the upgrade if I do things correctly?



You upgrade the master, and then you rebuild the standbys from a new basebackup (using pg_basebackup or manually with start/stop backups etc). You can't upgrade the standbys and have them re-join the master, they have to be redone from scratch.
 
--

В списке pgsql-general по дате отправления:

Предыдущее
От: Ladislav Lenart
Дата:
Сообщение: Re: newsfeed type query
Следующее
От: Mitu Verma
Дата:
Сообщение: Re: clearing of the transactions shown in pg_locks