Horton

Re: pause recovery if pitr target not reached

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: leif@lako.no, michael@paquier.xyz, masao.fujii@gmail.com, pgsql-hackers@postgresql.org
Date: 2020-01-27T11:16:02Z
Lists: pgsql-hackers

Attachments

On 2020-01-15 05:02, Kyotaro Horiguchi wrote:
> FWIW, I restate this (perhaps) more clearly.
> 
> At Wed, 15 Jan 2020 11:02:24 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in
>> recvoery_target_* is not cleared after startup. If a server crashed
>> just after the last shutdown checkpoint, any recovery_target_* setting
>> prevents the server from starting regardless of its value.
> 
> recvoery_target_* is not automatically cleared after a successful
> archive recovery.  After that, if the server crashed just after the
> last shutdown checkpoint, any recovery_target_* setting prevents the
> server from starting regardless of its value.

Thank you for this clarification.  Here is a new patch that addresses 
that and also the other comments raised about my previous patch.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Fail if recovery target is not reached