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 |…
I have the following software installed on a Windows laptop: Virtualbox Vagrant Many of you know what Virtualbox and Vagrant do. If not this is what’s written on Vagrant’s website: ” Vagrant is a tool for building and managing virtual machine environments in a single workflow. With an easy-to-use workflow and focus on automation, Vagrant…
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…
