Re: Patroni set up

From: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
To: Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Patroni set up
Date: 2025-07-02 08:58:18
Message-ID: CA+427g-P+in9gcZadAOw-QmDe88tK3H1Wjn_DZq5m9P-YTeAVg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raj 2025-07-02 10:17:05 Re: Patroni set up
Previous Message Raj 2025-07-02 07:37:45 Patroni set up