Re: pg9.6 when is a promoted cluster ready to accept "rewind" request?

Поиск
Список
Период
Сортировка
От talk to ben
Тема Re: pg9.6 when is a promoted cluster ready to accept "rewind" request?
Дата
Msg-id CAPE8EZ7XPRS-dgFUaM8K2guuWnPpkAy-6T5J+B6q9EVBp9EhZA@mail.gmail.com
обсуждение исходный текст
Ответ на pg9.6 when is a promoted cluster ready to accept "rewind" request?  (magodo <wztdyl@sina.com>)
Список pgsql-general
Дерево обсуждения
Hi, 

You might have to wait for pg_is_in_recovery to be false after the promotion. (in 9.6 pg_ctl promote doesn't wait for promotion to complete unlike 10).  [1]

You should CHECKOINT between 2 and 3. (or wait for the first checkpoint to finish)
In the thread [2], Michael Paquier explains that:

" This makes the promoted standby update its
timeline number in the on-disk control file, which is used by pg_rewind
to check if a rewind needs to happen or not. " 

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

Предыдущее
От: Om Prakash Jaiswal
Дата:
Сообщение: Db restore Error literal carriage return found hint use \r
Следующее
От: George Woodring
Дата:
Сообщение: Plpgsql search_path issue going from 9.3 to 9.6