Re: Need auto fail over cluster solution for PostGres

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 <fabrizio(at)timbira(dot)com(dot)br>
Sent: Monday, December 30, 2019 10:15:09 PM
To: Girish Kumar <girish_kumar(at)live(dot)in>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Need auto fail over cluster solution for PostGres

Em seg., 30 de dez. de 2019 às 13:30, Girish Kumar <girish_kumar(at)live(dot)in<mailto:girish_kumar(at)live(dot)in>> 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