Re: Patroni set up

Hi Raj,
We recently deployed a similar architecture for one of our clients.
The only addition was the configuration of PgBouncer, a lightweight
connection pooling mechanism, on all three nodes where PostgreSQL is
installed.

Regarding pgBackRest, I recommend using a dedicated backup server if
your backup size is large or if you have a longer retention policy.
However, if storage and retention are moderate or having any
limitations in providing dedicated servers, utilizing the existing
HAProxy servers for backups is also a viable and efficient option.

Thanks and regards
Venkat Akhil P
OpenSource DB
Your Trusted Data Partnerhttps://opensource-db.com/

On Wed, 2 Jul 2025 at 13:08, 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
>