Postgres Pro
Downloads
Home   >   mailing lists

Re: how to know current xlog location on standby after primary isdown - Mailing list pgsql-general

From Michael Paquier
Subject Re: how to know current xlog location on standby after primary isdown
Date
Msg-id 20180910065054.GH19122@paquier.xyz
Whole thread Raw
In response to how to know current xlog location on standby after primary is down  (magodo <wztdyl@sina.com>)
List pgsql-general
Tree view 
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
Attachment

pgsql-general by date:

Previous
From: "Ahmed, Nawaz"
Date:
Subject: RE: connection error
Next
From: Csaba Ragasits
Date:
Subject: PG8.3->10 migration data differences