Re: Postgres 10 automatic failover

Great, thanks for the update.
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com

On Fri, Sep 28, 2018 at 12:07 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
wrote:

> 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
>>
>