Hi,
I need a clarification about async streaming replication and replication slots.
I have a master and a standby both with server process running but with network disconnected between them.
In my primary, I see:
pg_current_xlog_location = B/48DFF790
and, through pg_replication_slots, that standby restart_lsn = B/48DFF6E8.
In my standby, I see:
pg_last_xlog_receive_location = B/48000000
pg_last_xlog_replay_location = B/48DFF6E8
My questions are:
1) why is pg_last_xlog_receive_location< pg_last_xlog_replay_location ? The standby should receive some parts from master's WAL, write them down to its WAL and then replay them, right?
2) Can I compare master's pg_current_xlog_location against pg_replication_slots.restart_lsn
in order to check if the standby is synchronized?
Regards
Pupillo
