How to check if checkpoint is finished in sql script?

Поиск
Список
Период
Сортировка
От Yi Sun
Тема How to check if checkpoint is finished in sql script?
Дата
Msg-id CABWY_HA=4H7DBj_d11whAckeuRHaY45407YeeqWpm-b2-PJEYg@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to check if checkpoint is finished in sql script?  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
Дерево обсуждения
Hello all,

We want to restart postgresql 3 nodes(2 replica nodes) by ansible as below steps:
1. Restart 2 replica nodes one by one
2. Run checkpoint in the leader node
3. Once checkpoint finished, restart the leader node

How to check if the checkpoint is finished in sql script please? We know that the log file will show it, but we want to check it in sql then can easily be used by ansible, thanks

Best regards
Oliver Sun

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

Предыдущее
От: "sivapostgres@yahoo.com"
Дата:
Сообщение: Re: Creating constraint dynamically
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: How to check if checkpoint is finished in sql script?