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
andSHOW POOL_BACKEND_STATS
commands- New PCP command
pcp_reload_config
- 4.2.0 release, featuring:
- 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)
- 4.1.0 new release, featuring:
- 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
- 4.0.0 new release, featuring:
- 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
- 3.7.0 new release, featuring:
- 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
andSHOW
commands - watchdog enhancements
- failover improvements
- PostgreSQL 9.6 parser support
- new
- 3.6.0 new release, featuring:
- 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
- 3.5.0 new release, featuring:
References
- Pgpool website: https://www.pgpool.net/
- Current documentation: https://www.pgpool.net/docs/latest/en/html/
- Git repository: https://git.postgresql.org/gitweb/?p=pgpool2.git;a=summary
- Twitter: Pgpool-II (@pgpool2)
Useful links
- Authentication in Pgpool-II - August 2020 blog article by Bo Peng
- Connection Pooling in Pgpool-II - July 2020 blog article by Bo Peng
- Consensus based failover with Pgpool-II - August 2020 article by HighGo Software