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

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.
Дата
Msg-id 7713989e-add9-b2ca-8804-236fc924f283@oss.nttdata.com
обсуждение исходный текст
Ответ на Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers

On 2021/05/19 9:53, Kyotaro Horiguchi wrote:
> 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).

Thanks for the review! I pushed the patch.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Forget close an open relation in ReorderBufferProcessTXN()