Re: Changes to recovery_min_apply_delay are ignored while waiting for delay

From: Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, ashwinstar(at)gmail(dot)com
Subject: Re: Changes to recovery_min_apply_delay are ignored while waiting for delay
Date: 2021-08-06 23:59:55
Message-ID: CAE-ML+9MUbZ7t6picoOQHn2ihAoZmSUPHmFvbcBurcuky_3HjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rebased. Also added a stronger check to see if the standby is stuck in
recovery_min_apply_delay:

$node_standby->poll_query_until('postgres', qq{
SELECT wait_event = 'RecoveryApplyDelay' FROM pg_stat_activity
WHERE backend_type='startup';
}) or die "Timed out checking if startup is in recovery_min_apply_delay";

Attached v3.

Regards,
Soumyadeep (VMware)

Attachment Content-Type Size
v3-0001-Refresh-delayUntil-in-recovery-delay-loop.patch text/x-patch 4.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2021-08-07 00:10:35 Re: Use generation context to speed up tuplesorts
Previous Message Masahiko Sawada 2021-08-06 23:50:19 Re: [BUG] wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION