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