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