Pgpool-II Guide

The Pgpool-II utility package acts as a middleman between client applications and a Postgres database server. Pgpool-II functionality is transparent to client applications; client applications connect to Pgpool-II instead of directly to Advanced Server, which then assigns one of its pooled sessions to the client. When the client closes its application session, Pgpool puts its session back into the pool, ready to be reused.

EnterpriseDB supports the following Pgpool-II functionality:

  • Load balancing

  • Connection pooling

  • High availability

  • Connection limits

Conventions Used in this Guide

In this guide:

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

  • The terms primary node and standby node are equivalent to the master node and slave node terminology used in the Pgpool community guide.