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