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 PathriaSystems Architect Evive +91 9478670472 goevive.com
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@goevive.com> 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 PathriaSystems Architect Evive +91 9478670472 goevive.com