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