PgBouncer
PgBouncer: A mature, free PostgreSQL pooler for self-hosted infrastructure. Ranked #15 of 31 in Database Proxy Software by our editors (7.7/10); pricing: Free plan; best for mature, free PostgreSQL connection pooling.
At a glance
- Editor score7.7 / 10
- PricingFree plan
- Best forMature, free PostgreSQL connection pooling
- Free planYes
- Paid fromFree
- Deployment modelSelf-hosted
- Founded2007
- Facts checked20 Sep 2026
Where it wins
- Supports session, transaction, and statement pooling modes
- Offers password, certificate, PAM, and LDAP authentication options
- Includes TLS, connection limits, routing, and an administration console
Where it doesn't
- Supports PostgreSQL rather than multiple database systems
- Does not provide automatic failover
- Self-hosted deployment requires compilation and infrastructure management
Our verdict on PgBouncer
PgBouncer is an open-source PostgreSQL connection pooler for developers and database administrators operating PostgreSQL infrastructure. It accepts client connections and reuses connections to PostgreSQL servers, helping reduce the overhead of opening database connections. The software supports Windows and Linux, is self-hosted, and is distributed as source releases that can be compiled for Unix-like systems and Windows. Its focus is narrow: managing PostgreSQL connections rather than providing a broad database proxy layer.
Connection pooling is the product’s central strength. Administrators can choose session, transaction, or statement pooling, then configure client and server connection limits to control resource use. PgBouncer also supports client authentication through password, certificate, PAM, and LDAP options, along with TLS for client and server connections. Database-to-backend routing is configured through the configuration file, while round-robin selection can distribute new connections across multiple backend hosts. An administrative console provides inspection of pools, clients, servers, and configuration, plus controls for reload, reconnect, pause, suspend, resume, and shutdown.
PgBouncer is a strong fit when PostgreSQL connection pooling, authentication control, and operational visibility are the main requirements. Its open-source model avoids a paid plan structure, but the self-hosted deployment places compilation, configuration, and ongoing administration with the operator. The published capabilities support backend selection and connection-destination balancing, not SQL query routing. Automatic failover is also outside its feature set, so teams needing those functions should choose a PostgreSQL proxy or platform designed around query-aware routing and failover management instead. Choose PgBouncer for focused, configurable pooling; avoid it when the requirement extends beyond connection management.
Your product? Our editors can test PgBouncer in depth and publish a review, labelled as paid · from $149/mo →
PgBouncer pricing
PgBouncer fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Deployment model | Self-hosted |
| Connection pooling | Yes |
| Query routing | No |
| Load balancing | Yes |
| Automatic failover | No |
| Supported databases | PostgreSQL |
| Maximum connections | Not verified |
| Deployment | Self-hosted |
| Platforms | Windows, Linux |
| Support | Community, Docs |
| Pricing | Free plan |
| Website | pgbouncer.org |
| Facts checked | 20 Sep 2026 |
Alternatives to PgBouncer
- Heimdall Database ProxyA broad database proxy with pooling, routing, analytics, security, and failover.9.4
- ProxySQLA free, open-source proxy for routing, pooling, balancing, and managing database traffic.9.2
- ShardingSphere-ProxyA self-hosted proxy for routing, scaling, and high availability across four database protocols.9.0
See all PgBouncer alternatives →
Also Ranked In
PgBouncer is ranked in 2 of our directories.
Used PgBouncer? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used PgBouncer for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
PgBouncer is listed in our Database Proxy Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/pgbouncer/"><img src="https://www.itechguides.com/best/badge/pgbouncer.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update