Re: PGBOUNCER FAILOVER AND HIGH AVAILABILITY

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux