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