Re: pause recovery if pitr target not reached

On 2019-09-17 13:23, Leif Gunnar Erlandsen wrote:
> This patch allows PostgreSQL to pause recovery before PITR target is reached 
> if recovery_target_time is specified.
> 
> Missing WAL's could then be restored from backup and applied on next restart.
> 
> Today PostgreSQL opens the database in read/write on a new timeline even when 
> PITR tareg is not reached.

I think this idea is worth thinking about.  I don't think this should be
specific to a time-based recovery target.  This could apply for example
to a target xid as well.  Also, there should be a way to get the old
behavior.  Perhaps this whole thing should be a new
recovery_target_action, say, 'pause_unless_reached'.

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