Re: Recovery test failure for recovery_min_apply_delay on hamster

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Recovery test failure for recovery_min_apply_delay on hamster
Дата
Msg-id CAB7nPqSGFpe1q3p3ErnNA6jhaU-DBgmWR_tkkz97CssYURX4fw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recovery test failure for recovery_min_apply_delay on hamster  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Recovery test failure for recovery_min_apply_delay on hamster  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Mar 9, 2016 at 12:14 AM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> Is there anything we can do to short-circuit the wait in the case that
> replication happens promptly?  A one-minute wait would be acceptable we
> terminate it early by checking every second.

After sleeping (best debugger ever) on that, actually a way popped up
in my mind, and I propose the attached, which refactors a bit 005 and
checks that the LSN position of master has been applied on standby
after at least the delay wanted. A maximum delay of 90s is authorized,
like poll_query_until.
--
Michael

Вложения

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Proposal: RETURNING primary_key()
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Parallel query fails on standby server