Обсуждение: Add DBState to pg_control_system function

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.

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
runningand 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