Re: Get LSN at which a cluster was promoted on previous timeline - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Get LSN at which a cluster was promoted on previous timeline
Date
Msg-id 87zhsfzuzk.fsf@jsievers.enova.com
Whole thread Raw
In response to Get LSN at which a cluster was promoted on previous timeline  (Jeremy Finzel <finzelj@gmail.com>)
Responses Re: Get LSN at which a cluster was promoted on previous timeline  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
Jeremy Finzel <finzelj@gmail.com> writes:

> I am having a hard time finding out how I can easily determine at
> which LSN a streamer was promoted after promotion.  A related
> question is that if I pause wal replay, I am able to see the last
> replayed LSN but I can't simply immediately promote.

Take a look at the *.history file in pg_xlog or pg_wal.

> I want to know the state of the streamer post-promotion with respect
> to the master by getting the LSN at which it was promoted.
>
> Thanks,
> Jeremy
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net


pgsql-general by date:

Previous
From: Jeremy Finzel
Date:
Subject: Get LSN at which a cluster was promoted on previous timeline
Next
From: Michael Paquier
Date:
Subject: Re: Get LSN at which a cluster was promoted on previous timeline