Re: Patroni set up

From: Venkat Akhil Pavuluri <akhil(dot)venkat(at)opensource-db(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-04 04:35:06
Message-ID: CAPCUgKrnDcWgBiR7832q35qK7n=vdH2=aaozfuLMoyd4cXhFYw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-07-04 06:31:24 Re: monthly consolidate PG db downtime report
Previous Message Peter Garza 2025-07-03 16:24:46 Re: monthly consolidate PG db downtime report