On Fri, 2020-05-15 at 23:56 -0400, Peter Wainaina wrote: > Hello hope you well ,want to implement the below: > a) Pg-bouncer to detect a promoted standby database automatically > b) High availability by having more than pg-bouncer That is not pgBounder's job. For high availability, run a pg_bouncer on each standby. Use libpg's HA features to make the client connect to the right one: "host=host1,host2 port=port1,port2 target_session_attrs=read-write" Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
