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