Contents

Pgpool-II

A middleware application which provides connection pooling, replication and load balancing functionality

Pgpool-II is a middleware application which provides connection pooling, replication and load balancing functionality.

Pgpool-II is mainly developed by SRA OSS and was first released in 2006 (initial commit 6c8e01ef).

Release history

This is a partial summary of recent releases; for a full and detailed list of releases, see the pgpool-II release notes. A brief history of PgPool is available here.

Note that multiple Pgpool-II versions are maintained and released in parallel. In general, a new point release (e.g. 3.7, 4.0, 4.1) occurs around the same time as a major PostgreSQL release.

  • 2020-11-26
    • 4.2.0 release, featuring:
      • logging collector
      • LDAP authentication
      • SHOW POOL_HEALTH_CHECK_STATS and SHOW POOL_BACKEND_STATS  commands
      • New PCP command pcp_reload_config
  • 2019-10-31
    • 4.1.0 new release, featuring:
      • statement level load balancing
      • auto failback
      • PostgreSQL 12 parser support
    • 3.4.26 update release (final release in the 3.4.x series)
  • 2018-10-19
    • 4.0.0 new release, featuring:
      • SCRAM and certificate authentication support
      • detection of "false" primary server ("split brain" scenario)
      • load balancing improvements
      • PostgreSQL 11 parser support
  • 2018-07-31
    • 3.3.22 update release (final release in the 3.3.x series)
  • 2017-11-22
    • 3.7.0 new release, featuring:
      • quorum-aware failover feature
      • per node health check parameters
      • AWS Aurora support
      • logical replication support
      • PostgreSQL 10 parser support
  • 2017-09-05
    • 3.2.22 update release (final release in the 3.2.x series)
  •  2016-12-26
    • 3.1.21 update release (final release in the 3.1.x series)
  • 2016-11-21
    • 3.6.0 new release, featuring:
      • new SET, RESET and SHOW commands
      • watchdog enhancements
      • failover improvements
      • PostgreSQL 9.6 parser support
  • 2016-02-25
    • 3.0.20 update release (final release in the 3.0.x series)
  • 2016-01-29
    • 3.5.0 new release, featuring:
      • watchdog feature enhancements
      • improved extended query protocol performance
      • overcoming the "thundering herd" problem
      • PostgreSQL 9.5 parser support

 

Categories

Performance, Replication

See also

pgpoolAdmin, PgBouncer, repmgr