Monitoring PostgreSQL Replication
After I have built my postgres hosts using Vagrant, I’m doing the following tests in order to check my replication: pg_stat_replication view Run the following statement on the master / primary host: postgres=# SELECT * FROM pg_stat_replication; pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | backend_xmin |…
