Search Postgresql Archives

Re: Postgres Automated Failover

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks, I'll check it out. 

On Thu, Jan 17, 2019 at 9:06 AM Jehan-Guillaume (ioguix) de Rorthais <ioguix@xxxxxxx> wrote:
On Thu, 17 Jan 2019 08:32:48 -0500
AI Rumman <rummandba@xxxxxxxxx> 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?

There is multiple HA solutions, none are "transparent failover" though. They
are just automated-failover. A rollback-ed transaction because of failover will
never be transparent from the application point of view.

Look at Patroni or PAF, depending on what you want to achieve.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux