Re: FAIL-OVER AND LOAD BALANCING

Prince Pathria <[email protected]> Wed, 25 Sep 2019 22:25:55 +0530
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAON0DawYM8a0bhs2FE5i0Z0y_X1=rQCGcwhey2F0ukELA383Vw@mail.gmail.com>
repmgr for automated failovers.
pgpool2 for connection pooling, read and write query load balancing.

Although you can use pgpool2 for failovers as well but repmgr is more
reliable for the same job.

Happy to help :)
Prince Pathria Systems Engineer Evive +91 9478670472 goevive.com


On Wed, Sep 25, 2019 at 9:17 PM Peter Wainaina <[email protected]> wrote:

> Hello i need an advice on an OPEN SOURCE TOOL to handle failover for
> replication.Currently am trying pg_auto_failover but stacked in the
> configuration.
> *WEB developer and programmer*
>
> *system analyst-crm*
>
> *blogger*
>