Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture

2025-07-23 Thread Jehan-Guillaume de Rorthais
On Wed, 23 Jul 2025 12:13:26 +0100 Achilleas Mantzios wrote: … > Have you consider pgpool-ii ?  I know most support / service companies > push for patroni, and manually separating read / write traffic from > within the app, Indeed > but I still find pgpool's query routing very nice. Using Pgp

Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture

2025-07-23 Thread Achilleas Mantzios
On 6/18/25 18:12, vijay patil wrote: Hi Team, I am planning to implement a PostgreSQL High Availability (HA) and Load Balancing setup and would greatly appreciate your feedback on the architecture we've designed (see attached diagram). image.png *Overview of the Setup:* * Two Postgr

Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture

2025-07-21 Thread Greg Sabino Mullane
> > Is this architecture considered a best practice within the PostgreSQL > community? I would say Patroni is probably "best practice", but there are other people out there happy with, and expert with, repmgr as well. Are there any potential bottlenecks or failure points I should be aware of?

Request for Feedback on PostgreSQL HA + Load Balancing Architecture

2025-06-18 Thread vijay patil
Hi Team, I am planning to implement a PostgreSQL High Availability (HA) and Load Balancing setup and would greatly appreciate your feedback on the architecture we've designed (see attached diagram). [image: image.png] *Overview of the Setup:* - Two PostgreSQL nodes (VM1 and VM2) configure