Re: Postgres 10 automatic failover

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

 



Hi Prince,

The pgpool is on top of repmgr with one master server and 2 slave servers with streaming replication.

We have implemented the HA using pgpool automatic failover with forward and backward reverse replication and its working perfectly.

Pgpool is smart enough to see which machine is the master or slave and will send the requests to the correct place.




On Fri, Sep 28, 2018 at 5:30 AM Prince Pathria <prince.pathria@xxxxxxxxxxx> wrote:
Hi,

I have pgpool-II for load balancing and repmgr for automatic failover. Pgpool-II also can also run failover I am just wondering doing automatic failover using pgpool or repmgr? If pgpool can do the failover do I need to use repmgr? and use shell scripts to the promotion of new master? Any scenario where repmgr is better than pgpool?

Thanks!

Prince Pathria
Systems Architect Evive +91 9478670472 goevive.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