Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.
Дата
Msg-id 20210519.095308.1406400973910988323.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Ответы Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список pgsql-hackers
At Tue, 18 May 2021 12:48:38 +0900, Fujii Masao <masao.fujii@oss.nttdata.com> wrote in 
> Currently a promotion causes all available WAL to be replayed before
> a standby becomes a primary whether it was in paused state or not.
> OTOH, something like immediate promotion (i.e., standby becomes
> a primary without replaying outstanding WAL) might be useful for
> some cases. I don't object to that.

Mmm. I was confused with recovery target + pause. Actually promotion
works as so and it is documented.  Anyway it is a matter of the next
version.

I forgot to mention the patch itself, but what the patch does looks
fine to me.  Disabling pause after setting SharedProteIsTriggered
prevents later re-pausing (from the sql function).

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_dumpall misses --no-toast-compression
Следующее
От: Takashi Menjo
Дата:
Сообщение: Map WAL segment files on PMEM as WAL buffers