For a database cluster design as below:
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?