From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: load balancer and connection pooling combined
Date: Wed, 3 Mar 2021 16:31:58 +0700
Message-ID: <YD9XjqV5tNptwQVq@admin.sibptus.ru> (raw)
Dear Colleagues,
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?
--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet
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: pgsql-admin@postgresql.org
Cc: vas@sibptus.ru, pgsql-admin@lists.postgresql.org
Subject: Re: load balancer and connection pooling combined
In-Reply-To: <YD9XjqV5tNptwQVq@admin.sibptus.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox