Re: Patroni set up
| От | Venkat Akhil Pavuluri |
|---|---|
| Тема | Re: Patroni set up |
| Дата | |
| Msg-id | CAPCUgKrnDcWgBiR7832q35qK7n=vdH2=aaozfuLMoyd4cXhFYw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Patroni set up (Raj <rajeshkumar.dba09@gmail.com>) |
| Список | 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 Partner https://opensource-db.com/
On Wed, 2 Jul 2025 at 13:08, 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 по дате отправления: