Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeremy Finzel
Subject Get LSN at which a cluster was promoted on previous timeline
Date
Msg-id CAMa1XUgf+53v9=ER55o5nPMaAnN1zNVCQ5s_3zCpe6YT=sQW=w@mail.gmail.com
Whole thread Raw
Responses Re: Get LSN at which a cluster was promoted on previous timeline
List pgsql-general
Tree view
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.

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

pgsql-general by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Immutable way to cast timestamp TEXT to DATE? (for index)
Next
From: Jerry Sievers
Date:
Subject: Re: Get LSN at which a cluster was promoted on previous timeline