On Sun, Sep 09, 2018 at 10:29:08PM +0800, magodo wrote: > So I want to know what is the correct way to do it. Thank you in > advance!
There are pg_last_wal_receive_lsn() and pg_last_wal_replay_lsn() which allow you to know what is the last LSN received and replayed on a standby. Those can be used when an instance is in recovery. -- Michael
signature.asc
Description: PGP signature