Downloads
Home   >   mailing lists

Re: Patroni set up - Mailing list pgsql-admin

From kaido vaikla
Subject Re: Patroni set up
Date
Msg-id CA+427g-P+in9gcZadAOw-QmDe88tK3H1Wjn_DZq5m9P-YTeAVg@mail.gmail.com
Whole thread Raw
In response to Patroni set up  (Raj <rajeshkumar.dba09@gmail.com>)
Responses Re: Patroni set up
List pgsql-admin
Tree view
Hi, 
Based on my opinion and setups.
I would keep etcd cluster on separate nodes and separate data centre.
Mumbai down means whole pg patroni cluster is down, because you dont have an etcd quorum. And other reasons, why create separet etcd cluster.

Take a backup from leader. Leader donw means no replicas. Replica down does not mean leader down.

br
Kaido

On Wed, 2 Jul 2025 at 10:38, Raj <rajeshkumar.dba09@gmail.com> wrote:
I am looking to DR set up patroni. For 5 node set up

Mumbai: Node 1: postgres+etcd+patroni 
Mumbai: Node 2: postgres+etcd+patroni
Chennai: Node 3: postgres+etcd+patroni 

Mumbai: haproxy+keepalived
Chennai: haproxy+keepalived

Will this work? And I want to know in which node should I take daily backup. Meaning- in which node I should configure pgbackrest backup

pgsql-admin by date:

Previous
From: Raj
Date:
Subject: Patroni set up
Next
From: "DINESH NAIR"
Date:
Subject: Re: Patroni set up