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?
We're satisfied with PgPool for HA. Can't give the same, and it's only a few hundred GB, though.