Re: Postgres 10 automatic failover

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.

<http://www.shreeyansh.com>

On Fri, Sep 28, 2018 at 5:30 AM Prince Pathria <prince(dot)pathria(at)goevive(dot)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 Pathria
> Systems Architect Evive +91 9478670472 goevive.com
>