Re: Need auto fail over cluster solution for PostGres

Girish Kumar <[email protected]> Tue, 31 Dec 2019 15:53:45 +0000

Newsgroups	gmane.comp.db.postgresql.general
Message-ID	<MN2PR01MB59030F1C25B050CB3E901FACF4260@MN2PR01MB5903.prod.exchangelabs.com>

If it's on Windows, does Windows Fail over cluster supports Postgres auto failover? I need a solution where secondary node becomes primary when primary fails and vice versa automatically without any manual intervention ( this is exactly how AAG works with SQL server on Windows)

Regards,
Girish kumar

Get Outlook for Android<https://aka.ms/ghei36>

________________________________
From: Fabrízio de Royes Mello <[email protected]>
Sent: Monday, December 30, 2019 10:15:09 PM
To: Girish Kumar <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Need auto fail over cluster solution for PostGres


Em seg., 30 de dez. de 2019 às 13:30, Girish Kumar <[email protected]<mailto:[email protected]>> escreveu:
>
> Hello,
>
> I need to setup an auto fail over cluster for Postgres similar to Always Available Group(AAG) provided by Microsoft for SQL Server. Any suggestions? Prefer open source solutions(On Ubuntu)
>

Some FOSS options:

https://github.com/zalando/patroni
https://github.com/sorintlab/stolon
https://github.com/ClusterLabs/PAF

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento