Hi guys,
I use these queries to monitor the streaming replication:
on master:
select client_addr, state, sent_location, write_location, flush_location, replay_location, sync_priority from pg_stat_replication;
On slave:
select now() - pg_last_xact_replay_timestamp() AS replication_delay;
Can I create a table to store that data?
I also need the data is constantly put into this table. How would be the best way to do it?
Cheers
Patrick