Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Pgpool-II

pgpool.net

  • Free plan
  • Linux
  • Self-hosted
7.0 Club score Visit pgpool.net

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

Pgpool-II

Free

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.