For a database cluster design as below:

enter image description here

In order to do high availability, prepare 2 pgBouncer servers. If the first server down, then the second server act as new connection pool, use HAProxy(Load Balancer) to choose active server. Is it possible?

Sure if repmgr master down, it can use bash scirpt send new master host ip to pgBouncer, is it possible to send to all of the 2 hosts?

For backup, repmgr master point to Barman backup active server, if it down, is it posible to use bash script to point to backup server when the new repmgr master be selected again?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.