On Mon, 3 Apr 2023 06:33:46 +0000
Inzamam Shafiq <inzamam.shafiq@hotmail.com> wrote:
[...]
> Can someone please suggest what is one (Patroni vs PGPool II) is best for
> achieving HA/Auto failover, Load balancing for DB servers. Along with this,
> can you please share the company/client names using these tools for large PG
> databases?
Load balancing is best achieved from the application side.
The most popular auto failover solution is Patroni.
Other solutions are involving Pacemaker to either:
* build a shared storage cluster with a standalone instance moving from node to
node (but this can include standbys)
* build a cluster with a promotable resource using eg. the PAF resource agent,
that will decide where to start the standbys and which one to promote.
No matter the solution you pick, be prepared to learn and train. A lot.