EDB Pgpool-II v4.3
EDB Pgpool-II is an enhanced version of the community Pgpool product, intended to support additional EDB Postgres Advanced Server capabilities. You can use it with PostgreSQL and EDB Postgres Advanced Server. EDB Pgpool-II acts as middleware between client applications and a PostgreSQL database server.
Using EDB 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
installing_and_configuring_the_pgpool-II extensions configuring_connection_pooling connecting_a_client_to_pgpool-II upgrade uninstalling_pgpool-II conclusion