In my opinion this 5-node set up is very elaborate and should work , which is distributed different across different seismic zone (across Mumbai (primary DC) and Chennai (DR site)) . Probably below mentioned parameters were factored when designing the system
network latency between Mumbai and Chennai
application switch over in case of fail-over and the downtime.
Thanks
Dinesh Nair
From: kaido vaikla <kaido.vaikla@gmail.com> Sent: Wednesday, July 2, 2025 2:28 PM To: Raj <rajeshkumar.dba09@gmail.com> Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org> Subject: Re: Patroni set up
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.
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.
