Add DBState to pg_control_system function

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Add DBState to pg_control_system function
Дата
Msg-id CALj2ACWBFEDA4a6EGn6F6ADLUqn-XieUy-wWvLdzR6R_yVknGw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Add DBState to pg_control_system function  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список pgsql-hackers
Дерево обсуждения 
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.
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Add checkpoint and redo LSN to LogCheckpointEnd log message
Следующее
От: "kuroda.hayato@fujitsu.com"
Дата:
Сообщение: RE: [Proposal] Add foreign-server health checks infrastructure