https://www.niwi.nz/2013/02/16/replication-status-in-postgresql/

 

select client_addr, state, sent_location, write_location,
        flush_location, replay_location from pg_stat_replication;

This query can output can be like this:

postgres=# select client_addr, state, sent_location,write_location, flush_location, replay_location, sync_priority from pg_stat_replication;
Disable Streaming Replication without restarting either master or slave
oradebug

Leave a Comment

Your email address will not be published. Required fields are marked *