Re: Patroni set up

So what's the best architecture

On Wed, 2 Jul 2025, 14:28 kaido vaikla, <kaido(dot)vaikla(at)gmail(dot)com> wrote:

> 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(dot)dba09(at)gmail(dot)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
>>
>