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
>
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 |