Get LSN at which a cluster was promoted on previous timeline

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Get LSN at which a cluster was promoted on previous timeline
Date: 2019-01-05 01:36:53
Message-ID: CAMa1XUgf+53v9=ER55o5nPMaAnN1zNVCQ5s_3zCpe6YT=sQW=w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2019-01-05 02:41:35 Re: Get LSN at which a cluster was promoted on previous timeline
Previous Message Andrew Gierth 2019-01-05 01:09:50 Re: Immutable way to cast timestamp TEXT to DATE? (for index)