Re: Postgres Automated Failover

From: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres Automated Failover
Date: 2019-01-17 14:29:16
Message-ID: 606e5d68-5c45-0a46-78aa-a04992e43ded@portavita.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

In my opinion repmgr it's worth a look.

https://repmgr.org/

regards,

fabio pardi

On 17/01/2019 14:32, AI Rumman wrote:
> Hi,
>
> I am planning to use Postgresql with TimescaleDb extension. I have to design a system similar to AWS RDS which supports automated failover, transparent minor version upgrades etc.
> In early days, I worked with PgPool II to enable heartbeat between the Postgres servers. Is there any new tool to achieve the same by which I can design a transparent failover system for Postgres?
>
> Also is there any multi-master Postgresql solution? Is Postgres-XC production ready?
>
> Any suggestions is appreciated. 
>
> Thanks.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ROS Didier 2019-01-17 14:32:55 RE: Postgres Automated Failover
Previous Message Jehan-Guillaume (ioguix) de Rorthais 2019-01-17 14:12:56 Re: Barman versus pgBackRest