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:
Limiting Exceeding Connections
In Memory Query Cache
Conventions Used in this Guide
In this guide:
The term Postgres refers to either PostgreSQL or EDB Advanced Server.
If you are using the pdf version of this document, using cut/paste to copy command may result in extra spaces or carriage returns in the pasted command. If a command fails, check the command carefully for additional characters.
- Installing Pgpool-II
- Installing and Managing Extensions
- Configuring Pgpool-II
- Connecting a Client to Pgpool-II
- Upgrading Pgpool-II and Extensions
- Uninstalling Pgpool-II and Extensions