Downloads
Home   >   mailing lists

Re: Patroni set up - Mailing list pgsql-admin

From Raj
Subject Re: Patroni set up
Date
Msg-id CAJk5Ata3SF4jhpAZcf3dbhLjaw_=27doUq+Sv_qW8jKaO5_ojw@mail.gmail.com
Whole thread Raw
In response to Re: Patroni set up  (Raj <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
Tree view
I want to use as minimum as possible number of nodes. But want to achive quorum, ip rerouting, and if possible read queries on dr and also backup must be available when one site is down


On Wed, 2 Jul 2025, 19:24 Raj, <rajeshkumar.dba09@gmail.com> wrote:
Then what's the right architecture Kaido

On Wed, 2 Jul 2025, 19:22 kaido vaikla, <kaido.vaikla@gmail.com> wrote:


On Wed, 2 Jul 2025 at 13:19, DINESH NAIR <Dinesh_Nair@iitmpravartak.net> wrote:
Hi, 

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

  1. network latency between Mumbai and Chennai
  2. application switch over in case of fail-over and the downtime.

Thanks 

Dinesh Nair



If  Mumbai (primary DC) is down then is down pg+patroni on Chennai. etcd quurom is lost
br
Kaido

pgsql-admin by date:

Previous
From: Raj
Date:
Subject: Re: Patroni set up
Next
From: kaido vaikla
Date:
Subject: Re: Patroni set up