Re: Automatic Failover in PostgreSQL using PAF/repmgr

From: "Jehan-Guillaume (ioguix) de Rorthais" <ioguix(at)free(dot)fr>
To: Devendra Y <devendraydba(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Automatic Failover in PostgreSQL using PAF/repmgr
Date: 2019-06-29 11:09:58
Message-ID: 20190629130958.42b6f22b@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 29 Jun 2019 00:34:13 +0530
Devendra Y <devendraydba(at)gmail(dot)com> wrote:

> Dear Experts,
>
> I have configured Wal replication (standby) in PostgreSQL as Master and
> slave. And I have also configured Logical replication (standby) in
> PostgreSQL as Master and slave for different application's.
>
> Now I am trying to integrate the Failover part to Automatic Failover using
> PAF (Postgresql automatic Failover) or repmgr.

Well, this requires a lot a time to understand, setup and master the automatic
failover you are building.

First advice: consider Patroni as well.
Second advice: in regard with PAF, read documentations, cookbooks and quick
starts on its official website. Come back to the list with specific question.

Good luck !

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-06-29 13:59:20 Re: Azure Database for PostgreSQL - how to add pgbouncer or similar?
Previous Message Alexander Farber 2019-06-29 07:34:05 Azure Database for PostgreSQL - how to add pgbouncer or similar?