On Mon, 19 Oct 2020 at 15:11, Dilip Kumar <dilipbalaut@gmail.com> wrote:
> We have an interface to pause the WAL replay (pg_wal_replay_pause) and
> to know whether the WAL replay pause is requested
> (pg_is_wal_replay_paused). But there is no way to know whether the
> recovery is actually paused or not. Actually, the recovery process
> might process an extra WAL before pausing the recovery. So does it
> make sense to provide a new interface to tell whether the recovery is
> actually paused or not?
>
> One solution could be that we convert the XLogCtlData->recoveryPause
> from bool to tri-state variable (0-> recovery not paused 1-> pause
> requested 2-> actually paused).
>
> Any opinion on this?
Why would we want this? What problem are you trying to solve?
If we do care, why not fix pg_is_wal_replay_paused() so it responds as you wish?
--
Simon Riggs http://www.EnterpriseDB.com/