Pgpool-II Guide v1.0
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
- High availability
- Connection limits
- 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.
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.
- Upstream merge with Pgpool-II 4.2.0 and 4.2.1.
- 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