Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 10 automatic failover - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Postgres 10 automatic failover
Date
Msg-id CAGDYbUNJUjdOqUXmZsAf5Nkee+DD0+mk_wMFG9d87f77Hfdf+g@mail.gmail.com
Whole thread Raw
In response to Postgres 10 automatic failover  (Prince Pathria <prince.pathria@goevive.com>)
Responses Re: Postgres 10 automatic failover
List pgsql-admin
Tree view
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 Pathria
Systems Architect Evive +91 9478670472 goevive.com

pgsql-admin by date:

Previous
From: Prince Pathria
Date:
Subject: Postgres 10 automatic failover
Next
From: Prince Pathria
Date:
Subject: Re: Postgres 10 automatic failover