Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 in them and it works fine. But now I am unable to configure the automatic failover in them. When the primary goes down the slave should be promoted as a primary.

I have tried Pgpool but after reading on some forums I dropped it, now planning to go for repmgr. Is repmgr a good solution? I also need a step by step configuration of failover in PostgreSQL with repmgr.

I have tried many scripts for failover but it seems to be not working. Can anyone provide me a sample script for failover process, and steps to how to execute them?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.