public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: vijay patil <[email protected]>
Cc: [email protected]
Subject: Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture
Date: Mon, 21 Jul 2025 15:26:37 -0400
Message-ID: <CAKAnmmLxh5bzdi_f7FJX+fq7YqEGMZ9+FVKBi0uKG44ssTEgLQ@mail.gmail.com> (raw)
In-Reply-To: <CAD5k+7wgFmO7V_ncFCHBOzO0d9H51O5aKDD+hcnrCbUgZomqiQ@mail.gmail.com>
References: <CAD5k+7wgFmO7V_ncFCHBOzO0d9H51O5aKDD+hcnrCbUgZomqiQ@mail.gmail.com>
>
> 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?
How is pgbouncer supposed to know which db to go to?I would think since
HAProxy has some way to tell, that pgbouncer should go on other side of
haproxy (between the app and haproxy)
Would you recommend any improvements or alternative tools for achieving
> better reliability and performance?
Seems you need a witness server or some sort. Your HA system should have a
few main goals:
* Immediately fail over to a replica should the primary go down
* Reroute the application traffic
* Rebuild the old primary as a replica
* Never, ever allow there to be more than one primary server
Secondary goals:
* make the non-Postgres things redundant (as with keepalived and haproxy)
* provide read/write traffic routing (as you kind of have here)
* some sort of backup system (don't see any here)
Your design will also depend on how bulletproof you want your HA system to
be, and how much data your application is allowed to lose.
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
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], [email protected]
Subject: Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture
In-Reply-To: <CAKAnmmLxh5bzdi_f7FJX+fq7YqEGMZ9+FVKBi0uKG44ssTEgLQ@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