Need auto fail over cluster solution for PostGres

[Girish Kumar]

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)

Regards,
Girish kumar

Sent from Mail for Windows 10

Re: Need auto fail over cluster solution for PostGres

[Fabrízio de Royes Mello]

Em seg., 30 de dez. de 2019 às 13:30, Girish Kumar 
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

Re: Need auto fail over cluster solution for PostGres

[Girish Kumar]

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 
Sent: Monday, December 30, 2019 10:15:09 PM
To: Girish Kumar 
Cc: pgsql-general@lists.postgresql.org 
Subject: Re: Need auto fail over cluster solution for PostGres


Em seg., 30 de dez. de 2019 às 13:30, Girish Kumar 
mailto:girish_ku...@live.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