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? Regards, Bharath Rupireddy.
v1-0001-Add-DBState-to-pg_control_system-function.patch
Description: Binary data