Pgpool-II
pgpool.net
- Free plan
- Linux
- Self-hosted
What Pgpool-II is
Pgpool-II is free, self-hosted middleware for PostgreSQL deployments. It sits between PostgreSQL servers and database clients, relaying PostgreSQL protocol messages without requiring client-side changes. Connection pooling reuses server connections with matching properties, reducing connection overhead and improving throughput. With replicated databases, Pgpool-II can distribute SELECT queries across servers to spread load. Its high-availability features include automatic failover, Watchdog, quorum, and split-brain prevention. Other listed capabilities include replication, online recovery, connection limiting, and an in-memory query cache. The software supports PostgreSQL and runs on Linux in a self-hosted setup. Binary and source distributions are available, including RPM packages for Red Hat Enterprise Linux and compatible distributions; Debian and Ubuntu users are directed to PostgreSQL community packages. Authentication methods include trust, clear-text password, MD5, SCRAM-SHA-256, certificate, PAM, and LDAP, but not GSSAPI. SSL can protect both communication directions when enabled, with OpenSSL support required.
Who it suits
Pgpool-II suits teams running PostgreSQL servers that need pooling, query routing, replication, or automatic failover in a Linux self-hosted environment. It is also relevant to organizations that want open-source licensing and community or commercial support options.
Good to know, and what to watch
- Free open-source license
- Automatic failover and split-brain prevention
- Connection pooling reduces overhead
- SELECT query load balancing
- Multiple authentication methods
- GSSAPI authentication is unsupported
- SSL is off by default
- Self-hosted Linux deployment required
- Unsupported releases lack formal binary packages
Plans
Every plan and pricePgpool-II
Free plan
The verdict
Pgpool-II combines PostgreSQL connection pooling, replicated-query routing, and high-availability controls in self-hosted middleware. Check its Linux deployment model, authentication limits, and SSL setup requirements before adoption.
What the maker publishes
- Additional features
- Additional features include in-memory query cache, online recovery, connection limiting, Watchdog, and replication. source
- APT packages
- Users of Debian or Ubuntu are directed to packages provided by the PostgreSQL community. source
- Authentication
- Supported authentication methods include trust, clear-text password, MD5, SCRAM-SHA-256, certificate, PAM, and LDAP; GSSAPI is not supported. source
- Connection pooling
- It reuses PostgreSQL server connections with matching properties to reduce connection overhead and improve throughput. source
- Distribution
- Pgpool-II is available as binary and source formats; the project provides RPM packages for Red Hat Enterprise Linux and compatible distributions. source
- Documentation
- Official documentation is available in English and Japanese, with tutorials for basic configuration, Watchdog, AWS, and Aurora. source
- High availability
- It provides automatic failover, Watchdog for Pgpool-II high availability, quorum, and split-brain prevention. source
- License
- The license permits use, copying, modification, and distribution of the software and documentation for any purpose without a fee. source
- Load balancing
- For replicated databases, it distributes SELECT queries across servers to reduce load and improve throughput. source
- Purpose
- Pgpool-II is middleware between PostgreSQL servers and database clients that relays PostgreSQL protocol messages transparently. source
- Release support
- The project aims to fully support each major release for five years; unsupported releases receive only possible best-effort critical fixes and no formal binary packages. source
- Security reporting
- The community asks vulnerability reporters to email the project leader privately and does not offer bug bounties. source
- SSL
- When enabled, SSL protects both frontend and backend communications, but it is off by default and requires OpenSSL support. source
- Support
- Community support is provided through mailing lists and GitHub Issues, while SRA OSS K.K. offers commercial technical support, consulting, and system integration. source
Checked against the maker's pages on 1 Oct 2026.