Sample Header Ad - 728x90

Streaming replication and failover on PostgreSQL

14 votes
2 answers
5038 views
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 not providing automatic failover for streaming replication. We can switch the slave to master using a trigger file but it is not manageable. So I'd like a solution with automatic failover and high availability. Different solutions are available: 1. Repmgr 2. Linux Heartbeat 3. Pgpool-II (for automatic failover only) 4. Any other tool in case you used. My question is which solution should be used?
Asked by Saurabh (141 rep)
Jan 9, 2012, 09:20 AM
Last activity: Jul 29, 2012, 03:05 PM