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 |…

Postgres: PANIC: could not locate a valid checkpoint record

I recently started to play with Postgres and this was one of the errors I got from my setup when I was trying to bring up the database:   [Tue Nov 06 09:58:10 root@postgres-primary:~ ] $ su – postgres -c ‘/usr/pgsql-10/bin/pg_ctl -D $PGDATA start’ waiting for server to start….2018-11-06 09:58:37.346 UTC [21595] LOG: listening on…