I am new to PostgreSQL, and I have a task of implementing replication and failover in PostgreSQL database. We are using 2 nodes (1st Primary and 2nd Slave). I have configured the streaming replication ...
I am trying to setup repmgr using the autofailover quick setup tutorial provided on Github Link But I am kind of stuck on the witness section, when trying to create the witness with repmgr -d repmgr ...
We are using this awesome tool repmgr developed by 2nd Quadrant for streaming replication. We set 1000 WALs to be archived. What I noticed though is that on master we have about 600 WALs in the ...
We're setting up a PostgreSQL cluster, and we're looking at using repmgr to handle standby promotion and so on. Our cluster has one master and a hot standby, and uses the streaming replication ...
I'm running tests with PostgreSQL hot standby with 1 master, and exactly 1 slave. I am using the instructions on this guide: ...
I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...