Is Recovery actually paused?
Dilip Kumar <dilipbalaut@gmail.com>
From: Dilip Kumar <dilipbalaut@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-10-19T14:10:49Z
Lists: pgsql-hackers
Hello, 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? -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com
Commits
-
Be clear about whether a recovery pause has taken effect.
- 32fd2b57d7f6 14.0 landed
-
Pause recovery for insufficient parameter settings
- 15251c0a60be 14.0 cited
-
Remove most volatile qualifiers from xlog.c
- 6ba4ecbf477e 9.5.0 cited