How to check if checkpoint is finished in sql script? - Mailing list pgsql-general

From Yi Sun
Subject How to check if checkpoint is finished in sql script?
Date
Msg-id CABWY_HA=4H7DBj_d11whAckeuRHaY45407YeeqWpm-b2-PJEYg@mail.gmail.com
Whole thread Raw
Responses Re: How to check if checkpoint is finished in sql script?
List 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 by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Creating constraint dynamically
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: How to check if checkpoint is finished in sql script?