Jeremy Finzel <finzelj@xxxxxxxxx> 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@xxxxxxxxxxx