clarification about async streaming replication and replication slots

Started by Tom DalPozzoalmost 9 years ago1 messagesgeneral
Jump to latest
#1Tom DalPozzo
t.dalpozzo@gmail.com

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