pgpool-ii
« Back to VersTracker
Description:
PostgreSQL connection pool server
Type: Formula  |  Latest Version: 4.6.5@0  |  Tracked Since: Nov 25, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: postgresql database connection-pool load-balancing high-availability
Install: brew install pgpool-ii
About:
Pgpool-II is a middleware tool that sits between PostgreSQL servers and client applications. It provides connection pooling, load balancing, and automated failover to improve database performance and reliability. Its main value is enhancing scalability and high availability for PostgreSQL clusters.
Key Features:
  • Connection pooling to reduce overhead
  • Load balancing across multiple PostgreSQL servers
  • Automatic failover and high availability
  • Watchdog for monitoring and managing nodes
  • Parallel query execution for faster results
Use Cases:
  • Improving performance and scalability of a PostgreSQL database cluster
  • Providing high availability and automatic failover for critical databases
  • Managing read-heavy workloads by distributing queries across replicas
Alternatives:
  • pgbouncer – PgBouncer is a lightweight connection pooler, while Pgpool-II offers additional features like load balancing and failover.
  • haproxy – HAProxy is a general-purpose TCP/HTTP load balancer, whereas Pgpool-II is PostgreSQL-specific with deeper protocol understanding.
Version History
Detected Version Rev Change Commit
Dec 23, 2025 7:37am 4.6.5 0 VERSION_BUMP d6125390
Dec 21, 2025 9:05pm 4.6.4 0 VERSION_BUMP 32caa263
Nov 25, 2025 11:24am 0 VERSION_BUMP e5b7eda2
Oct 15, 2025 5:03pm 0 VERSION_BUMP ef185e80