Victor Sudakov wrote: > > Based on your personal experience and industry best practices, what load > balancer combined with connection pooler can you advise? > > 1. I have good experience with pgpool, it's a great and robust > connection pooler, but it cannot do load balancing and failover (or > rather, it can do very rudimentary load balancing). > > 2. I have limited experience with Haproxy, it's great for load balancing > and failover, but it's not a connection pooler, and its pgsql-check is > not good enough, I guess you have to use an external check. > > Is there the "one thing to rule them all" that does all of the above and > is well-tested and reliable? If it could parse Patroni's REST API like Haproxy can, it would be even more perfect. -- Victor Sudakov VAS4-RIPE http://vas.tomsk.ru/ 2:5005/49@fidonet
