Pgpool-II Guide v1.0

Edit this page

Pgpool-II acts as a middleman 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

In this guide:

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

If you are using the pdf version of this document, using the cut/paste command may result in extra spaces or carriage returns in the pasted command. If a command fails, check the command carefully for additional characters.

What's New

  1. Upstream merge with Pgpool-II 4.2.0 and 4.2.1.
  2. 4.2 is a major release. For more details on migrating to 4.2, see the Migration Section.

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