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