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