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
