Pgpool-II Guide v4.2

Pgpool-II acts as middleware between client applications and a PostgreSQL database server.

Using Pgpool-II adds the following benefits to your application connection infrastructure:

  • Transparently reroutes and ensures load balancing of Read Only transactions to Standby database servers
  • Reuses connections to prevent reconnects
  • Brings down Postgres connections by queuing stale connections
  • Integrates with Failover managers to follow the primary

EDB supports the following Pgpool-II functionality:

  • Load balancing
  • Connection pooling
  • Replication
  • High availability
  • Connection limits
  • Watchdog
  • Limiting Exceeding Connections
  • In Memory Query Cache

Conventions Used in this Guide

The term Postgres refers to either PostgreSQL or EDB Postgres Advanced Server.

installing_and_configuring_the_pgpool-II extensions configuring_connection_pooling connecting_a_client_to_pgpool-II upgrade uninstalling_pgpool-II conclusion