Re: Patroni set up
| От | kaido vaikla |
|---|---|
| Тема | Re: Patroni set up |
| Дата | |
| Msg-id | CA+427g-P+in9gcZadAOw-QmDe88tK3H1Wjn_DZq5m9P-YTeAVg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Patroni set up (Raj <rajeshkumar.dba09@gmail.com>) |
| Ответы |
Re: Patroni set up
|
| Список | pgsql-admin |
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
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 upMumbai: Node 1: postgres+etcd+patroniMumbai: Node 2: postgres+etcd+patroniChennai: Node 3: postgres+etcd+patroniMumbai: haproxy+keepalivedChennai: haproxy+keepalivedWill 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 по дате отправления: