Re: Postgres 10 automatic failover

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: Postgres 10 automatic failover
Дата
Msg-id CAGDYbUNJUjdOqUXmZsAf5Nkee+DD0+mk_wMFG9d87f77Hfdf+g@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres 10 automatic failover  (Prince Pathria <prince.pathria@goevive.com>)
Ответы Re: Postgres 10 automatic failover  (Prince Pathria <prince.pathria@goevive.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Prince Pathria
Дата:
Сообщение: Postgres 10 automatic failover
Следующее
От: Prince Pathria
Дата:
Сообщение: Re: Postgres 10 automatic failover