public inbox for [email protected]  

help / color / mirror / Atom feed
From: vijay patil <[email protected]>
To: [email protected]
Subject: Request for Feedback on PostgreSQL HA + Load Balancing Architecture
Date: Wed, 18 Jun 2025 22:42:30 +0530
Message-ID: <CAD5k+7wgFmO7V_ncFCHBOzO0d9H51O5aKDD+hcnrCbUgZomqiQ@mail.gmail.com> (raw)

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) configured with:
   -

      Asynchronous replication from the Primary DB (on VM1) to the Standby
      DB (on VM2) using repmgr
      -

      HAProxy for failover management:
      -

         HAProxy 1 (active) on VM1
         -

         HAProxy 2 (passive) on VM2 with Keepalive for heartbeat and
         failover detection
         -

      PgBouncer on both nodes for connection pooling
      -

   A Virtual IP (VIP) managed by HAProxy for routing traffic from the
   application
   -

   Read/Write operations go to the Primary DB, and Read-Only queries can be
   served from either node

*Objectives:*

   -

   Ensure high availability with automatic failover
   -

   Enable basic load balancing for read-only queries
   -

   Maintain connection pooling and routing efficiency

*Request for Feedback:*

   -

   Is this architecture considered a best practice within the PostgreSQL
   community?
   -

   Are there any potential bottlenecks or failure points I should be aware
   of?
   -

   Would you recommend any improvements or alternative tools for achieving
   better reliability and performance?

Thanks

Vijay


Attachments:

  [image/png] image.png (83.3K, 3-image.png)
  download | view image

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture
  In-Reply-To: <CAD5k+7wgFmO7V_ncFCHBOzO0d9H51O5aKDD+hcnrCbUgZomqiQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox