Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
Pgpool-II Guide¶
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 Advanced Server.
Note
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.