Pgpool-II vs Supavisor
Pgpool-II
pgpool.netSupavisor
github.comSide by side
| Figure | Pgpool-II | Supavisor |
|---|---|---|
| Price from | Free | $25/mo |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | Yes |
| Linux | Yes | Yes |
| API | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 5 |
| Spec score · Database Proxy Software | 7.4 (#21) | 8.5 (#4) |
| Authentication | Supported authentication methods include trust, clear-text password, MD5, SCRAM-SHA-256, certificate, PAM, and LDAP; GSSAPI is not supported. | Client credentials can be verified using tenant user records or an authentication query. |
| High availability | It provides automatic failover, Watchdog for Pgpool-II high availability, quorum, and split-brain prevention. | Cluster nodes monitor tenant pools and reconnecting clients can start replacement pools after a node failure. |
| Purpose | Pgpool-II is middleware between PostgreSQL servers and database clients that relays PostgreSQL protocol messages transparently. | Supavisor is a scalable, cloud-native Postgres connection pooler. |
Plans
Supavisor
- FreeFree
- Open-source SupavisorFree
- Pro$25 a month
- Team$599 a month
- EnterprisePriced on request
In their own words
Pgpool-II
Pgpool-II is free, self-hosted middleware positioned between PostgreSQL servers and database clients. It relays PostgreSQL protocol messages, reuses matching server connections to reduce overhead, and distributes SELECT queries across replicated databases. High-availability functions include automatic failover, Watchdog, quorum, and split-brain prevention. Additional features include replication, online recovery, connection limiting, and an in-memory query cache. The project is available in binary and source formats, including RPM packages for Red Hat Enterprise Linux and compatible distributions; Debian and Ubuntu users are directed to PostgreSQL community packages. Authentication supports trust, clear-text password, MD5, SCRAM-SHA-256, certificates, PAM, and LDAP, but not GSSAPI. SSL can protect frontend and backend traffic when enabled; it is off by default and requires OpenSSL support. Community assistance is available through mailing lists and GitHub Issues, while SRA OSS K.K. offers commercial support, consulting, and integration. The license permits use, modification, copying, and distribution without a fee.