On 2022/02/01 13:22, Bharath Rupireddy wrote:
Hi, I think emitting DBState (staring up, shut down, shut down in recovery, shutting down, in crash recovery, in archive recovery, in production) via the pg_control_system function would help know the database state, especially during PITR/archive recovery. During archive recovery, the server can open up for read-only connections even before the archive recovery finishes. Having, pg_control_system emit database state would help the users/service layers know it and so they can take some actions based on it. Attaching a patch herewith. Thoughts?
This information seems not so helpful because only "in production" and "archive recovery" can be reported during normal running and recovery, respectively. No? In the state other than them, we cannot connect to the server and execute pg_control_system(). Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION
