Re: recovery_target_action=pause with confusing hint

From: David Steele <david(at)pgmasters(dot)net>
To: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Sergei Kornilov <sk(at)zsrv(dot)org>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: recovery_target_action=pause with confusing hint
Date: 2020-03-09 12:30:53
Message-ID: 086216a0-e367-3367-a15e-ff70cef04866@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Sergei,

On 1/30/20 12:00 PM, Fujii Masao wrote:
>
>> - check for standby triggers only for recovery_target_action - I am
>> not sure this would be safe for pg_wal_replay_pause() call case
>
> Agreed. Basically I think that recoveryPausesHere() should the promotion
> trigger whether recovery target is reached or not. But one question is;
> how should the recovery behave if recovery target is reached with
> recovery_target_action=pause after the promotion is requested?
> It should pause? Or promote?

Do you have thoughts on Fujii's comments?

Regards,
--
-David
david(at)pgmasters(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Surafel Temesgen 2020-03-09 12:34:54 Re: Conflict handling for COPY FROM
Previous Message Prabhat Sahu 2020-03-09 12:24:01 Re: [Proposal] Global temporary tables