Replication Manager for PostgreSQL clusters

learn more… | top users | synonyms

0
votes
1answer
27 views

repmgr: Can I replicate databases from two different masters to a third slave?

If I have a master node 1 (with database A) and a master node 2 (with database B) can I use repmgr and have both A and B replicated to a hot standby node 3 ? [ EDIT: They would all be running ...
0
votes
1answer
186 views

Taking hot backup of slave node in postgres (master-slave config with repmgr)

I have a postgresql setup with master-slave configuration using repmgr. I'm struggling with taking a consistent snapshot backup (pg_start_backup) of the slave node, this is due the fact that the slave ...
0
votes
0answers
74 views

How do I automate failover in PostgreSQL 9.1?

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 ...
1
vote
0answers
727 views

Can't set up witness in Repmgr 2.0

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 ...
3
votes
1answer
205 views

Witnessing standby failure with repmgr

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 ...
5
votes
1answer
2k views

PostgreSQL: Unable to run repmgr cloned database

I'm running tests with PostgreSQL hot standby with 1 master, and exactly 1 slave. I am using the instructions on this guide: ...
10
votes
2answers
2k views

Streaming replication and failover on PostgreSQL

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