Re: how to know current xlog location on standby after primary is down

2018-09-09 Thread Michael Paquier
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

how to know current xlog location on standby after primary is down

2018-09-09 Thread magodo
Hello, I'm working on a high availability project for PG(v9.6). Suppose I have a priamry-standby setup, I need to do promote once primary is down, but only when standby is as new as primary (before it is down). Therefore, I need a way to know the wal replay location on standby. I tried to set