Latest revision as of 01:19, 28 February 2025

Welcome to Pgpool Wiki!

What is Pgpool-II?

Pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It is distributed under a license similar to BSD and MIT. It provides the following features.

Connection Pooling

Pgpool-II saves connections to the PostgreSQL servers, and reuse them whenever a new connection with the same properties (i.e. username, database, protocol version) comes in. It reduces connection overhead, and improves system's overall throughput.

Replication

Pgpool-II can manage multiple PostgreSQL servers. Using the replication function enables creating a realtime backup on 2 or more physical disks, so that the service can continue without stopping servers in case of a disk failure.

Load Balancing

If a database is replicated, executing a SELECT query on any server will return the same result. Pgpool-II takes an advantage of the replication feature to reduce the load on each PostgreSQL server by distributing SELECT queries among multiple servers, improving system's overall throughput. At best, performance improves proportionally to the number of PostgreSQL servers. Load balance works best in a situation where there are a lot of users executing many queries at the same time.

Limiting Exceeding Connections

There is a limit on the maximum number of concurrent connections with PostgreSQL, and connections are rejected after this many connections. Setting the maximum number of connections, however, increases resource consumption and affect system performance. pgpool-II also has a limit on the maximum number of connections, but extra connections will be queued instead of returning an error immediately.

Watchdog

Watchdog can coordinate multiple Pgpool-II, create a robust cluster system and avoid the single point of failure or split brain. Watchdog can perform lifecheck against other pgpool-II nodes, to detect a fault of Pgpoll-II. If active Pgpool-II goes down, standby Pgpool-II can be promoted to active, and take over Virtual IP.

In Memory Query Cache

In memory query cache allows to save a pair of SELECT statement and its result. If an identical SELECTs comes in, Pgpool-II returns the value from cache. Since no SQL parsing nor access to PostgreSQL are involved, using in memory cache is extremely fast. On the other hand, it might be slower than the normal path in some cases, because it adds some overhead of storing cache data.

Pgpool-II speaks PostgreSQL's backend and frontend protocol, and relays messages between a backend and a frontend. Therefore, a database application (frontend) thinks that Pgpool-II is the actual PostgreSQL server, and the server (backend) sees Pgpool-II as one of its clients. Because Pgpool-II is transparent to both the server and the client, an existing database application can be used with Pgpool-II almost without a change to its sources.

Pgpool-II License

See License.

Stable versions

Pgpool-II: 4.6, 4.5, 4.4, 4.3, 4.2

Contacts

If you have technical questions regarding Pgpool-II, please subscribe Pgpool-II mailing lists and send questions to it (pgpool-general will be a starter). Please do not send technical questions via private email. We will not respond such that messages.

If you believe that you found a vulnerability/security issues with Pgpool-II, please send a private email to ishii at postgresql.org (he is the project leader).

What's new

News

Pgpool-II 4.6.0 officially released (2025/02/28)

Pgpool-II 4.6.0 is now released. This is the first stable release of Pgpool-II 4.6.x.

V4.6 contains new features and enhancements, including:

New PCP command to trigger log rotation.

Allow logging_collector related parameters to be changed by reloading.

New PCP command to invalidate query cache.

Allow to force to create query cache

New PGPOOL SET CACHE DELETE command.

New configuration parameter log_backend_messages.

Import PostgreSQL 17's SQL parser.

Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.

You can download it from here.

Release notes: English

Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released (2025/02/28)

Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released.

You can download them here.

4.5.6 : English Japanese
4.4.11 : English Japanese
4.3.14 : English Japanese
4.2.21 : English Japanese

Events

PostgreSQL Conference in Russia 2016

Tatsuo gave a talk "How to manage a herd of elephants" at "PostgreSQL Conference in Russia 2016", held in Moscow from February 4th to 5th. The slides are available in Developer's documentation.

PostgreSQL Conference in China 2015

Tatsuo gave a talk "How to manage a herd of elephants" at "PostgreSQL Conference in China 2015", held in Beijing from November 21th to 22th. The slides are available in Developer's documentation.

pgCon 2015 Cluster Hacker Summit

We participated "6th Postgres Cluster Hacker Summit" which was held as a part of PgCon 2015 Developer Unconference. We reported about Development Status Updates and pgpool-II 3.5 features. The slides are available in Developer's documentation.

Pgpool-II Day 2015 in Tokyo

We had the very first time pgpool-II decicated conference. See the event report.

Stable

Pgpool-II 4.6.0 officially released (2025/02/28)

Pgpool-II 4.6.0 is now released. This is the first stable release of Pgpool-II 4.6.x.

V4.6 contains new features and enhancements, including:

New PCP command to trigger log rotation.

Allow logging_collector related parameters to be changed by reloading.

New PCP command to invalidate query cache.

Allow to force to create query cache

New PGPOOL SET CACHE DELETE command.

New configuration parameter log_backend_messages.

Import PostgreSQL 17's SQL parser.

Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.

You can download it from here.

Release notes: English

Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released (2025/02/28)

Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released.

You can download them here.

4.5.6 : English Japanese
4.4.11 : English Japanese
4.3.14 : English Japanese
4.2.21 : English Japanese

Pgpool-II 4.5.5, 4.4.10, 4.3.13, 4.2.20 and 4.1.23 officially released (2024/11/28)

Pgpool-II 4.5.5, 4.4.10, 4.3.13, 4.2.20 and 4.1.23 officially released.

Please note that 4.1.23 is the last release of the 4.1.x series.

You can download them here.

4.5.5 : English Japanese
4.4.10 : English Japanese
4.3.13 : English Japanese
4.2.20 : English Japanese
4.1.23 : English Japanese

Pgpool-II 4.5.4, 4.4.9, 4.3.12, 4.2.19 and 4.1.22 officially released (2024/09/09)

Pgpool-II 4.5.4, 4.4.9, 4.3.12, 4.2.19 and 4.1.22 officially released.

This release contains a security fix.

When the query cache feature is enabled, it was possible that a database user can read rows from tables that should not be visible for the user through query cache (CVE-2024-45624).

All versions of Pgpool-II older than 4.5.4, 4.4.9, 4.3.12, 4.2.19, 4.1.22, and all older versions that has the query cache feature (the query cache feature was implemented in 3.2) are affected by the vulnerability. It is strongly recommend to upgrade to Pgpool-II 4.5.4, 4.4.9, 4.3.12, 4.2.19 and 4.1.22 or later. Or you should better turn off the query cache feature.

You can download them here.

4.5.4 : English Japanese
4.4.9 : English Japanese
4.3.12 : English Japanese
4.2.19 : English Japanese
4.1.22 : English Japanese

Pgpool-II 4.5.3, 4.4.8, 4.3.11, 4.2.18 and 4.1.21 officially released (2024/08/15)

Pgpool-II 4.5.3, 4.4.8, 4.3.11, 4.2.18 and 4.1.21 officially released.

You can download them here.

4.5.3 : English Japanese
4.4.8 : English Japanese
4.3.11 : English Japanese
4.2.18 : English Japanese
4.1.21 : English Japanese

Pgpool-II 4.5.2, 4.4.7, 4.3.10, 4.2.17 and 4.1.20 officially released (2024/05/16)

Pgpool-II 4.5.2, 4.4.7, 4.3.10, 4.2.17 and 4.1.20 officially released.

You can download them here.

4.5.2 : English Japanese
4.4.7 : English Japanese
4.3.10 : English Japanese
4.2.17 : English Japanese
4.1.20 : English Japanese

Pgpool-II 4.5.1, 4.4.6, 4.3.9, 4.2.16 and 4.1.19 officially released (2024/02/29)

Pgpool-II 4.5.1, 4.4.6, 4.3.9, 4.2.16 and 4.1.19 officially released.

You can download them here.

4.5.1 : English Japanese
4.4.6 : English Japanese
4.3.9 : English Japanese
4.2.16 : English Japanese
4.1.19 : English Japanese

Pgpool-II 4.5.0 released (2023/12/12)

Pgpool-II 4.5.0 is now released. This is the first stable release of Pgpool-II 4.5.x.

V4.5 contains new features and enhancements, including:

Allow to use more kind of multiple statements in a query string.

Allow to load balance PREPARE/EXECUTE/DEALLOCATE.

Allow to set delay_threshold_by_time in milliseconds.

Avoid session disconnection issue in failover/failback/backend error in some cases.

Allow to route queries to a specific backend node for a specific user connection.

Support multiple directories specification for pcp_socket_dir.

Import PostgreSQL 16's SQL parser.

You can download it from here.

Release notes: English

Pgpool-II 4.4.5, 4.3.8, 4.2.15, 4.1.18 and 4.0.25 officially released (2023/11/30)

Pgpool-II 4.4.5, 4.3.8, 4.2.15, 4.1.18 and 4.0.25 officially released.

Please note that 4.0.25 is the last release of the 4.0.x series.

You can download them here.

4.4.5 : English Japanese
4.3.8 : English Japanese
4.2.15 : English Japanese
4.1.18 : English Japanese
4.0.25 : English Japanese

Pgpool-II 4.4.4, 4.3.7, 4.2.14, 4.1.17 and 4.0.24 officially released (2023/08/17)

Pgpool-II 4.4.4, 4.3.7, 4.2.14, 4.1.17 and 4.0.24 officially released.

You can download them here.

4.4.4 : English Japanese
4.3.7 : English Japanese
4.2.14 : English Japanese
4.1.17 : English Japanese
4.0.24 : English Japanese

Pgpool-II 4.4.3, 4.3.6, 4.2.13, 4.1.16 and 4.0.23 officially released (2023/05/18)

Pgpool-II 4.4.3, 4.3.6, 4.2.13, 4.1.16 and 4.0.23 officially released.

You can download them here.

4.4.3 : English Japanese
4.3.6 : English Japanese
4.2.13 : English Japanese
4.1.16 : English Japanese
4.0.23 : English Japanese

End-of-Life (EOL) Announcement for pgpoolAdmin (2023/02/17)

Pgpool Global Development Group announces end-of-life date for pgpoolAdmin, which is the management tool for Pgpool-II.

Pgpool Global Development Group will provide maintenance for pgpoolAdmin 4.0, 4.1 and 4.2 until December 31, 2023. After this date, bug fixes and security fixes for these versions will no longer be provided.

In addition, pgpoolAdmin for Pgpool-II 4.3 or later will not be released.

We would like to thank you for using pgpoolAdmin over the years.

Pgpool-II 4.4.2, 4.3.5, 4.2.12, 4.1.15 and 4.0.22 officially released (2023/01/23)

Pgpool-II 4.4.2, 4.3.5, 4.2.12, 4.1.15 and 4.0.22 officially released.

This release contains a security fix.

If following conditions are all met, the password of "wd_lifecheck_user" is exposed by "SHOW POOL STATUS" command. The command can be executed by any user who can connect to Pgpool-II. (CVE-2023-22332)

Version 3.3 or later
use_watchdog = on
wd_lifecheck_method = 'query'
A plain text password is set to wd_lifecheck_password

In this case it is strongly recommended to upgrade to this version (we do not expose wd_lifecheck_password in show pool_status command any more), or use one of following workarounds.

Workarounds for 4.0.x to 4.4.x users:

Disable watchdog. Set use_watchdog to off.
Change wd_lifecheck_method to heartbeat.
Set an empty string to wd_lifecheck_password. This will use password in the pool_passwd file.
Set an AES encrypted password to wd_lifecheck_password.

In any case we recommend to change "wd_lifecheck_password" in PostgreSQL.

Workarounds for 3.0.x to 3.7.x users:

Disable watchdog. Set use_watchdog to off.
Change wd_lifecheck_method to heartbeat.

In any case we recommend to change "wd_lifecheck_password" in PostgreSQL.

Please note that Pgpool-II 3.7.x or before are end of life and no minor updates are provided for those versions.

You can download them here.

4.4.2 : English Japanese
4.3.5 : English Japanese
4.2.12 : English Japanese
4.1.15 : English Japanese
4.0.22 : English Japanese

Pgpool-II 4.4.1, 4.3.4, 4.2.11, 4.1.14, 4.0.21 and 3.7.26 officially released (2022/12/22)

Pgpool-II 4.4.1, 4.3.4, 4.2.11, 4.1.14, 4.0.21 and 3.7.26 officially released.

You can download them here.

4.4.1 : English Japanese
4.3.4 : English Japanese
4.2.11 : English Japanese
4.1.14 : English Japanese
4.0.21 : English Japanese
3.7.26 : English Japanese

Pgpool-II 4.4.0 released (2022/12/06)

Pgpool-II 4.4.0 is now released. This is the first stable release of Pgpool-II 4.4.x.

V4.4 contains new features and enhancements, including:

Add new dynamic spare process management feature. This feature allows selecting between static and dynamic process management modes.

Allow to specify replication delay by time in streaming replication mode. For this purpose new parameter delay_threshold_by_time is introduced.

As PostgreSQL already does, Pgpool-II now supports unix_socket_directories, unix_socket_group and unix_socket_permissions for more flexible and precise control of UNIX domain sockets.

Allow to use comma separated multiple listen addresses in listen_addresses and pcp_listen_addresses. They control which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces.

Allow to customize the command used by trusted_servers for checking upstream connection. For this purpose new parameter trusted_server_command is introduced.

Import PostgreSQL 15's SQL parser.

Speed up query cache by reducing lock contention. This allows concurrent running clients to fetch cache contents much more quicker.

You can download it from here.

Release notes: English Japanese

Pgpool-II 4.3.3, 4.2.10, 4.1.13, 4.0.20 and 3.7.25 officially released (2022/08/18)

Pgpool-II 4.3.3, 4.2.10, 4.1.13, 4.0.20 and 3.7.25 officially released.

You can download them here.

4.3.3 : English Japanese
4.2.10 : English Japanese
4.1.13 : English Japanese
4.0.20 : English Japanese
3.7.25 : English Japanese

Pgpool-II 4.3.2, 4.2.9, 4.1.12, 4.0.19 and 3.7.24 officially released (2022/05/19)

Pgpool-II 4.3.2, 4.2.9, 4.1.12, 4.0.19 and 3.7.24 officially released.

You can download them here.

4.3.2 : English Japanese
4.2.9 : English Japanese
4.1.12 : English Japanese
4.0.19 : English Japanese
3.7.24 : English Japanese

Pgpool-II 4.3.1, 4.2.8, 4.1.11, 4.0.18 and 3.7.23 officially released (2022/02/17)

Pgpool-II 4.3.1, 4.2.8, 4.1.11, 4.0.18 and 3.7.23 officially released.

You can download them here.

4.3.1 : English Japanese
4.2.8 : English Japanese
4.1.11 : English Japanese
4.0.18 : English Japanese
3.7.23 : English Japanese

Pgpool-II 4.2.7, 4.1.10, 4.0.17 and 3.7.22 officially released (2021/12/23)

Pgpool-II 4.2.7, 4.1.10, 4.0.17 and 3.7.22 officially released.

The purpose of this release is to provide packages for PostgreSQL 14.

You can download them here.

4.2.7 : English Japanese
4.1.10 : English Japanese
4.0.17 : English Japanese
3.7.22 : English Japanese

Pgpool-II 4.3.0 released (2021/12/07)

Pgpool-II 4.3.0 is now released. Please take a look at 4.3.0

V4.3.0 contains new features and enhancements, including:

A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.

Allow to choose the least replication delay standby node when selecting the load balance node.

Allow to specify the node id to be promoted in pcp_promote_node.

Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.

Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.

Allow pcp_node_info to list all backend nodes information.

Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.

Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.

Add support for log time stamp with milliseconds.

Import PostgreSQL 14's SQL parser.

Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.

pgpool.conf sample files are unified into single sample file for easier configuration.

All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.

You can download it from here.

Release notes: English

Pgpool-II 4.2.6, 4.1.9, 4.0.16, 3.7.21 and 3.6.28 officially released (2021/11/18)

Pgpool-II 4.2.6, 4.1.9, 4.0.16, 3.7.21 and 3.6.28 officially released.

You can download them here.

4.2.6 : English Japanese
4.1.9 : English Japanese
4.0.16 : English Japanese
3.7.21 : English Japanese
3.6.28 : English Japanese

Pgpool-II 4.2.5 released (2021/09/14)

Pgpool Global Development Group is pleased to announce the availability of Pgpool-II 4.2.5.

You can download them here.

4.2.5 : English Japanese

Pgpool-II 4.2.4, 4.1.8, 4.0.15, 3.7.20 and 3.6.27 officially released (2021/08/05)

Pgpool-II 4.2.4, 4.1.8, 4.0.15, 3.7.20 and 3.6.27 officially released.

You can download them here.

4.2.4 : English Japanese
4.1.8 : English Japanese
4.0.15 : English Japanese
3.7.20 : English Japanese
3.6.27 : English Japanese

pgpoolAdmin 4.2.0 officially released (2021/06/17)

pgpoolAdmin 4.2.0 officially released.

pgpoolAdmin 4.2.0 adds support for Pgpool-II 4.2. Please take a look at release notes.

You can download them here.

Pgpool-II 4.2.3, 4.1.7, 4.0.14, 3.7.19 and 3.6.26 officially released (2021/05/20)

Pgpool-II 4.2.3, 4.1.7, 4.0.14, 3.7.19 and 3.6.26 officially released.

You can download them here.

4.2.3 : English Japanese
4.1.7 : English Japanese
4.0.14 : English Japanese
3.7.19 : English Japanese
3.6.26 : English Japanese

Pgpool-II 4.2.2, 4.1.6, 4.0.13, 3.7.18 and 3.6.25 officially released (2021/02/18)

Pgpool-II 4.2.2, 4.1.6, 4.0.13, 3.7.18 and 3.6.25 officially released.

You can download them here.

4.2.2 : English Japanese
4.1.6 : English Japanese
4.0.13 : English Japanese
3.7.18 : English Japanese
3.6.25 : English Japanese

Pgpool-II 4.2.1 released (2020/12/23)

Pgpool-II 4.2.1 is now released.

You can download them from here.

4.2.1 : English Japanese

Pgpool-II 4.2.0 released (2020/11/26)

Pgpool-II 4.2.0 is now released.

V4.2 contains new features and enhancements, including:

Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.

Implement logging_collector for easier log management.

Implement log_disconnections to collect disconnection logs.

Implement pg_enc and pg_md5 to allow to register multiple passwords at once.

Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.

New PCP command pcp_reload_config is added.

Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.

Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.

Support LDAP authentication between clients and Pgpool-II.

Add ssl_crl_file and ssl_passphrase_command to SSL configuration.

Import PostgreSQL 13's SQL parser.

You can download it from here.

Release notes: English

Development

Pgpool-II 4.6 RC1 released (2025/02/20)

Pgpool-II 4.6 RC1 is now released.

Note that this is not a stable version but just for developers.

V4.6 contains new features and enhancements, including:

New PCP command to trigger log rotation.

Allow logging_collector related parameters to be changed by reloading.

New PCP command to invalidate query cache.

Allow to force to create query cache

New PGPOOL SET CACHE DELETE command.

New configuration parameter log_backend_messages.

Import PostgreSQL 17's SQL parser.

Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.

You can download it from here.

Release notes: English

Pgpool-II 4.6 beta1 released (2025/02/13)

Pgpool-II 4.6 beta1 is now released.

Note that this is not a stable version but just for developers.

V4.6 contains new features and enhancements, including:

New PCP command to trigger log rotation.

Allow logging_collector related parameters to be changed by reloading.

New PCP command to invalidate query cache.

Allow to force to create query cache

New PGPOOL SET CACHE DELETE command.

New configuration parameter log_backend_messages.

Import PostgreSQL 17's SQL parser.

Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.

You can download it from here.

Release notes: English

Pgpool-II 4.5 RC1 released (2023/11/28)

Pgpool-II 4.5 RC1 is now released.

Note that this is not a stable version but just for developers.

V4.5 contains new features and enhancements, including:

Allow to use multiple statements in a query string.

Allow to set delay_threshold_by_time in milliseconds.

Avoid session disconnection issue in failover/failback/backend error in some cases.

Allow to route queries to a specific backend node for a specific user connection.

Support multiple directories specification for pcp_socket_dir.

Import PostgreSQL 16's SQL parser.

You can download it from here.

Release notes: English

Pgpool-II 4.5 beta1 released (2023/11/14)

Pgpool-II 4.5 beta1 is now released.

Note that this is not a stable version but just for developers.

V4.5 contains new features and enhancements, including:

Allow to use multiple statements in a query string.

Allow to set delay_threshold_by_time in milliseconds.

Avoid session disconnection issue in failover/failback/backend error in some cases.

Allow to route queries to a specific backend node for a specific user connection.

Support multiple directories specification for pcp_socket_dir.

Import PostgreSQL 16's SQL parser.

You can download it from here.

Release notes: English

Pgpool-II 4.4 RC1 released (2022/11/22)

Pgpool-II 4.4 RC1 is now released.

Note that this is not a stable version but just for developers.

V4.4 contains new features and enhancements, including:

Add new dynamic spare process management feature. This feature allows selecting between static and dynamic process management modes.

Allow to specify replication delay by time in streaming replication mode. For this purpose new parameter delay_threshold_by_time is introduced.

As PostgreSQL already does, Pgpool-II now supports unix_socket_directories, unix_socket_group and unix_socket_permissions for more flexible and precise control of UNIX domain sockets.

Allow to use comma separated multiple listen addresses in listen_addresses and pcp_listen_addresses. They control which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces.

Allow to customize the command used by trusted_servers for checking upstream connection. For this purpose new parameter trusted_server_command is introduced.

Import PostgreSQL 15's SQL parser.

Speed up query cache by reducing lock contention. This allows concurrent running clients to fetch cache contents much more quicker.

You can download it from here.

Release notes: English

Pgpool-II 4.4 beta1 released (2022/11/14)

Pgpool-II 4.4 beta1 is now released.

Note that this is not a stable version but just for developers.

V4.4 contains new features and enhancements, including:

Add new dynamic spare process management feature. This feature allows selecting between static and dynamic process management modes.

Allow to specify replication delay by time in streaming replication mode. For this purpose new parameter delay_threshold_by_time is introduced.

As PostgreSQL already does, Pgpool-II now supports unix_socket_directories, unix_socket_group and unix_socket_permissions for more flexible and precise control of UNIX domain sockets.

Allow to use comma separated multiple listen addresses in listen_addresses and pcp_listen_addresses. They control which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces.

Allow to customize the command used by trusted_servers for checking upstream connection. For this purpose new parameter trusted_server_command is introduced.

Import PostgreSQL 15's SQL parser.

Speed up query cache by reducing lock contention. This allows concurrent running clients to fetch cache contents much more quicker.

You can download it from here.

Release notes: English

Pgpool-II 4.3 RC1 released (2021/11/25)

Pgpool-II 4.3 RC1 is now released. Please take a look at 4.3 RC1

Note that this is not a stable version but just for developers.

V4.3 contains new features and enhancements, including:

A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.

Allow to choose the least replication delay standby node when selecting the load balance node.

Allow to specify the node id to be promoted in pcp_promote_node.

Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.

Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.

Allow pcp_node_info to list all backend nodes information.

Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.

Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.

Add support for log time stamp with milliseconds.

Import PostgreSQL 14's SQL parser.

Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.

pgpool.conf sample files are unified into single sample file for easier configuration.

All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.

You can download it from here.

Release notes: English

Pgpool-II 4.3 beta2 released (2021/11/18)

Pgpool-II 4.3 beta2 is now released. Please take a look at 4.3 beta2

Note that this is not a stable version but just for developers.

V4.3 contains new features and enhancements, including:

A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.

Allow to choose the least replication delay standby node when selecting the load balance node.

Allow to specify the node id to be promoted in pcp_promote_node.

Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.

Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.

Allow pcp_node_info to list all backend nodes information.

Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.

Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.

Add support for log time stamp with milliseconds.

Import PostgreSQL 14's SQL parser.

Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.

pgpool.conf sample files are unified into single sample file for easier configuration.

All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.

You can download it from here.

Release notes: English

Pgpool-II 4.3 beta1 released (2021/11/09)

Pgpool-II 4.3 beta1 is now released.

Note that this is not a stable version but just for developers.

V4.3 contains new features and enhancements, including:

A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.

Allow to choose the least replication delay standby node when selecting the load balance node.

Allow to specify the node id to be promoted in pcp_promote_node.

Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.

Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.

Allow pcp_node_info to list all backend nodes information.

Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.

Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.

Add support for log time stamp with milliseconds.

Import PostgreSQL 14's SQL parser.

Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.

pgpool.conf sample files are unified into single sample file for easier configuration.

All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.

You can download it from here.

Release notes: English

Pgpool-II 4.2 beta1 released (2020/10/27)

Pgpool-II 4.2 beta1 is now released.

Note that this is not a stable version but just for developers.

V4.2 contains new features and enhancements, including:

Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.

Implement logging_collector for easier log management.

Implement log_disconnections to collect disconnection logs.

Implement pg_enc and pg_md5 to allow to register multiple passwords at once.

Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.

New PCP command pcp_reload_config is added.

Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.

Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.

Support LDAP authentication between clients and Pgpool-II.

Add ssl_crl_file and ssl_passphrase_command to SSL configuration.

Import PostgreSQL 13's SQL parser.

You can download it from here.

Release notes: English

Pgpool-II 4.2 alpha1 released (2020/10/06)

Pgpool-II 4.2 alpha1 is now released.

Note that this is not a stable version but just for developers.

V4.2 contains new features and enhancements, including:

Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.

Implement logging_collector for easier log management.

Implement log_disconnections to collect disconnection logs.

Implement pg_enc and pg_md5 to allow to register multiple passwords at once.

Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.

New PCP command pcp_reload_config is added.

Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.

Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.

Support LDAP authentication between clients and Pgpool-II.

Add ssl_crl_file and ssl_passphrase_command to SSL configuration.

Import PostgreSQL 13's SQL parser.

You can download it from here.

Release notes: English

Old

See this page.

Where can I get commercial support for Pgpool-II?

Some commercial packages include Pgpool-II support. Consulting and annual support can be purchased from SRA OSS LLC (https://www.sraoss.co.jp/index_en.php).

@@ Line 10: / Line 10: @@
 * [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]
 -->
 <!-- MAINTENANCE MESSAGE -->
 <!--
 <font color="red">
@@ Line 18: / Line 16: @@
 The pgpool.net server will be shut down for maintenance work
-from 04:00 JST (UTC+0900) to 21:00 JST (UTC+0900), Sat, 16 November 2020.
+from 12:00 JST (UTC+0900) to 13:00 JST (UTC+0900), Tue, 28 May 2024.
 All services on pgpool.net will be unavailable for the maintenance period.
 Sorry for inconvenience.
 </font>
 -->
 <!--
 <font color="red">
@@ Line 29: / Line 26: @@
 The pgpool.net server will be shut down for maintenance work
-from 11:00 JST (UTC+0900) to 13:00 JST (UTC+0900), Thu, 26 November 2020.
+from 12:00 JST (UTC+0900) to 13:00 JST (UTC+0900), on Thursday, February 20, 2025.
 All services on pgpool.net will be unavailable for the maintenance period.
 Sorry for inconvenience.
 </font>
 -->
 <!--
 <font color="red">
@@ Line 45: / Line 41: @@
 == What is Pgpool-II? ==
-Pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It is licensed under BSD license. It provides the following features.
+Pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It is distributed under a license similar to BSD and MIT. It provides the following features.
 * '''Connection Pooling'''
@@ Line 65: / Line 61: @@
 : In memory query cache allows to save a pair of SELECT statement and its result. If an identical SELECTs comes in, Pgpool-II returns the value from cache. Since no SQL parsing nor access to PostgreSQL are involved, using in memory cache is extremely fast. On the other hand, it might be slower than the normal path in some cases, because it adds some overhead of storing cache data.
-Pgpool-II speaks PostgreSQL's backend and frontend protocol, and relays messages between a backend and a frontend. Therefore, a database application (frontend) thinks that Pgpool-II is the actual PostgreSQL server, and the server (backend) sees Pgpool-II as one of its clients. Because Pgpool-II is transparent to both the server and the client, an existing database application can be used with Pgpool-II almost without a
+Pgpool-II speaks PostgreSQL's backend and frontend protocol, and relays messages between a backend and a frontend. Therefore, a database application (frontend) thinks that Pgpool-II is the actual PostgreSQL server, and the server (backend) sees Pgpool-II as one of its clients. Because Pgpool-II is transparent to both the server and the client, an existing database application can be used with Pgpool-II almost without a change to its sources.
-Pgpool-II talks PostgreSQL's backend and frontend protocol, and relays a connection between them. Therefore, a database application (frontend) thinks that Pgpool-II is the actual PostgreSQL server, and the server (backend) sees Pgpool-II as one of its clients. Because Pgpool-II is transparent to both the server and the client, an existing database application can be used with Pgpool-II almost without a change to its sources.
 == Pgpool-II License ==
@@ Line 75: / Line 69: @@
 == Stable versions ==
-* Pgpool-II: 4.0, 3.7, 3.6, 3.5, 3.4
+* Pgpool-II: 4.6, 4.5, 4.4, 4.3, 4.2
-* pgpoolAdmin: 4.0, 3.7, 3.6, 3.5, 3.4
 == Contacts ==
@@ Line 82: / Line 75: @@
 * If you have technical questions regarding Pgpool-II, please subscribe [https://pgpool.net/mediawiki/index.php/Mailing_lists Pgpool-II mailing lists] and send questions to it (pgpool-general will be a starter). Please '''do not''' send technical questions via private email. We will not respond such that messages.
-* If you believe that you found a vulnerability/security issues with Pgpool-II, please send a '''private email''' to ishii at sraoss.co.jp (he is the project leader).
+* If you believe that you found a vulnerability/security issues with Pgpool-II, please send a '''private email''' to ishii at postgresql.org (he is the project leader).
 = What's new =
@@ Line 88: / Line 81: @@
 == News ==
-=== Pgpool-II 4.2.0 released (2020/11/26) ===
+=== Pgpool-II 4.6.0 officially released (2025/02/28) ===
+Pgpool-II 4.6.0 is now released. This is the first stable release of Pgpool-II 4.6.x.
-Pgpool-II 4.2.0 is now released.
+V4.6 contains new features and enhancements, including:
-V4.2 contains new features and enhancements, including:
+* New PCP command to trigger log rotation.
-* Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.
+* Allow logging_collector related parameters to be changed by reloading.
-* Implement logging_collector for easier log management.
+* New PCP command to invalidate query cache.
-* Implement log_disconnections to collect disconnection logs.
+* Allow to force to create query cache
-* Implement pg_enc and pg_md5 to allow to register multiple passwords at once.
+* New PGPOOL SET CACHE DELETE command.
-* Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.
+* New configuration parameter log_backend_messages.
-* New PCP command pcp_reload_config is added.
+* Import PostgreSQL 17's SQL parser.
-* Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.
+* Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.
-* Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.
+You can download it from [https://pgpool.net/mediawiki/index.php/Downloads here].
-* Support LDAP authentication between clients and Pgpool-II.
+Release notes:
+[https://www.pgpool.net/docs/46/en/html/release-4-6-0.html English]
-* Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
+=== Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released (2025/02/28) ===
-* Import PostgreSQL 13's SQL parser.
+Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released.
-You can download it from [https://pgpool.net/mediawiki/index.php/Downloads here].
+You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-Release notes:
+* 4.5.6  :  [https://www.pgpool.net/docs/latest/en/html/release-4-5-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-5-6.html Japanese]
-[https://www.pgpool.net/docs/42/en/html/release-4-2-0.html English]
+* 4.4.11 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-11.html Japanese]
+* 4.3.14 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-14.html Japanese]
+* 4.2.21 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-21.html Japanese]
 == Events ==
@@ Line 153: / Line 151: @@
 We had the very first time pgpool-II decicated conference. See the [https://pgpool.net/mediawiki/index.php/pgpool-II_Day_2015 event report].
-== New docs ==
-=== pgpool-II 3.5 is coming soon! ===
-pgpool-II 3.5 alpha1 has been out. Tatsuo introduces [https://pgpool.net/mediawiki/index.php?title=pgpool-II_3.5_features&redirect=no "new features of pgpool-II 3.5."]
 == Stable ==
-=== Pgpool-II 4.2.0 released (2020/11/26) ===
+=== Pgpool-II 4.6.0 officially released (2025/02/28) ===
-Pgpool-II 4.2.0 is now released.
+Pgpool-II 4.6.0 is now released. This is the first stable release of Pgpool-II 4.6.x.
-V4.2 contains new features and enhancements, including:
+V4.6 contains new features and enhancements, including:
-* Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.
+* New PCP command to trigger log rotation.
-* Implement logging_collector for easier log management.
+* Allow logging_collector related parameters to be changed by reloading.
-* Implement log_disconnections to collect disconnection logs.
+* New PCP command to invalidate query cache.
-* Implement pg_enc and pg_md5 to allow to register multiple passwords at once.
+* Allow to force to create query cache
-* Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.
+* New PGPOOL SET CACHE DELETE command.
-* New PCP command pcp_reload_config is added.
+* New configuration parameter log_backend_messages.
-* Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.
+* Import PostgreSQL 17's SQL parser.
-* Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.
-* Support LDAP authentication between clients and Pgpool-II.
+* Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.
-* Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
-* Import PostgreSQL 13's SQL parser.
 You can download it from [https://pgpool.net/mediawiki/index.php/Downloads here].
 Release notes:
-[https://www.pgpool.net/docs/42/en/html/release-4-2-0.html English]
+[https://www.pgpool.net/docs/46/en/html/release-4-6-0.html English]
-=== Pgpool-II 4.1.5, 4.0.12, 3.7.17, 3.6.24 and 3.5.28 officially released (2020/11/19) ===
+=== Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released (2025/02/28) ===
-Pgpool-II 4.1.5, 4.0.12, 3.7.17, 3.6.24 and 3.5.28 officially released
+Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 4.1.5 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-5.html Japanese]
+* 4.5.6  :  [https://www.pgpool.net/docs/latest/en/html/release-4-5-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-5-6.html Japanese]
-* 4.0.12 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-12.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-12.html Japanese]
+* 4.4.11 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-11.html Japanese]
-* 3.7.17 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-17.html Japanese]
+* 4.3.14 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-14.html Japanese]
-* 3.6.24 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-24.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-24.html Japanese]
+* 4.2.21 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-21.html Japanese]
-* 3.5.28 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-28.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-28.html Japanese]
+=== Pgpool-II 4.5.5, 4.4.10, 4.3.13, 4.2.20 and 4.1.23 officially released (2024/11/28) ===
-=== Pgpool-II 4.1.4, 4.0.11, 3.7.16, 3.6.23 and 3.5.27 officially released (2020/09/17) ===
+Pgpool-II 4.5.5, 4.4.10, 4.3.13, 4.2.20 and 4.1.23 officially released.
-Pgpool-II 4.1.4, 4.0.11, 3.7.16, 3.6.23 and 3.5.27 officially released
+Please note that 4.1.23 is the last release of the 4.1.x series.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 4.1.4 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-4.html Japanese]
+* 4.5.5  :  [https://www.pgpool.net/docs/latest/en/html/release-4-5-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-5-5.html Japanese]
-* 4.0.11 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-11.html Japanese]
+* 4.4.10 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-10.html Japanese]
-* 3.7.16 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-16.html Japanese]
+* 4.3.13 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-13.html Japanese]
-* 3.6.23 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-23.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-23.html Japanese]
+* 4.2.20 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-20.html Japanese]
-* 3.5.27 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-27.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-27.html Japanese]
+* 4.1.23 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-23.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-23.html Japanese]
-=== Pgpool-II 4.1.3, 4.0.10, 3.7.15, 3.6.22 and 3.5.26 officially released (2020/08/20) ===
+=== Pgpool-II 4.5.4, 4.4.9, 4.3.12, 4.2.19 and 4.1.22 officially released (2024/09/09) ===
-Pgpool-II 4.1.3, 4.0.10, 3.7.15, 3.6.22 and 3.5.26 officially released
+Pgpool-II 4.5.4, 4.4.9, 4.3.12, 4.2.19 and 4.1.22 officially released.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+This release contains a security fix.
-* 4.1.3 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-3.html Japanese]
+When the query cache feature is enabled, it was possible that a database user can read rows from tables that should not be visible for the user through query cache (CVE-2024-45624).
-* 4.0.10 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-10.html Japanese]
-* 3.7.15 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-15.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-15.html Japanese]
-* 3.6.22 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-22.html Japanese]
-* 3.5.26 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-26.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-26.html Japanese]
-=== Pgpool-II 4.1.2, 4.0.9, 3.7.14, 3.6.21 and 3.5.25 officially released (2020/05/21) ===
+All versions of Pgpool-II older than 4.5.4, 4.4.9, 4.3.12, 4.2.19, 4.1.22, and all older versions that has the query cache feature (the query cache feature was implemented in 3.2) are affected by the vulnerability.
+It is strongly recommend to upgrade to Pgpool-II 4.5.4, 4.4.9, 4.3.12, 4.2.19 and 4.1.22 or later. Or you should better turn off the query cache feature.
-Pgpool-II 4.1.2, 4.0.9, 3.7.14, 3.6.21 and 3.5.25 officially released
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 4.1.2 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-2.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-2.html Japanese]
+* 4.5.4 :  [https://www.pgpool.net/docs/latest/en/html/release-4-5-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-5-4.html Japanese]
-* 4.0.9 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-9.html Japanese]
+* 4.4.9 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-9.html Japanese]
-* 3.7.14 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-14.html Japanese]
+* 4.3.12 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-12.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-12.html Japanese]
-* 3.6.21 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-21.html Japanese]
+* 4.2.19 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-19.html Japanese]
-* 3.5.25 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-25.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-25.html Japanese]
+* 4.1.22 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-22.html Japanese]
-=== Pgpool-II 4.1.1, 4.0.8, 3.7.13, 3.6.20, 3.5.24 and pgpoolAdmin 4.1.0 officially released (2020/02/20) ===
+=== Pgpool-II 4.5.3, 4.4.8, 4.3.11, 4.2.18 and 4.1.21 officially released (2024/08/15) ===
-Pgpool-II 4.1.1, 4.0.8, 3.7.13, 3.6.20, 3.5.24 and pgpoolAdmin 4.1.0 officially released
+Pgpool-II 4.5.3, 4.4.8, 4.3.11, 4.2.18 and 4.1.21 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 4.1.1 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-1.html Japanese]
+* 4.5.3 :  [https://www.pgpool.net/docs/latest/en/html/release-4-5-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-5-3.html Japanese]
-* 4.0.8 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-8.html Japanese]
+* 4.4.8 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-8.html Japanese]
-* 3.7.13 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-13.html Japanese]
+* 4.3.11 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-11.html Japanese]
-* 3.6.20 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-20.html Japanese]
+* 4.2.18 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-18.html Japanese]
-* 3.5.24 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-24.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-24.html Japanese]
+* 4.1.21 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-21.html Japanese]
-=== Pgpool-II 4.1.0, 4.0.7, 3.7.12, 3.6.19, 3.5.23 and 3.4.26 RPMs Update 2 officially released (2019/11/19) ===
+=== Pgpool-II 4.5.2, 4.4.7, 4.3.10, 4.2.17 and 4.1.20 officially released (2024/05/16) ===
-Pgpool-II 4.1.0, 4.0.7, 3.7.12, 3.6.19, 3.5.23 and 3.4.26 RPMs Update 2 are officially released.
+Pgpool-II 4.5.2, 4.4.7, 4.3.10, 4.2.17 and 4.1.20 officially released.
-The updated RPM packages fixed the bug which logs are not output, when log_destination = 'syslog' is configured.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-=== Pgpool-II 4.1.0 released (2019/10/31) ===
+* 4.5.2 :  [https://www.pgpool.net/docs/latest/en/html/release-4-5-2.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-5-2.html Japanese]
+* 4.4.7 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-7.html Japanese]
+* 4.3.10 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-10.html Japanese]
+* 4.2.17 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-17.html Japanese]
+* 4.1.20 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-20.html Japanese]
-Pgpool-II 4.1.0 is now relased.
+=== Pgpool-II 4.5.1, 4.4.6, 4.3.9, 4.2.16 and 4.1.19 officially released (2024/02/29) ===
-Major enhancements in Pgpool-II 4.1 include:
+Pgpool-II 4.5.1, 4.4.6, 4.3.9, 4.2.16 and 4.1.19 officially released.
-* Statement level load balancing.
+You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* Auto failback.
-* Enhance performance in number of areas.
-** Shared relation cache allows to reuse relation cache among sessions to reduce internal queries against PostgreSQL system catalogs.
-** Have separate SQL parser for DML statements to eliminate unnecessary parsing effort.
-** Load balancing control for specific queries.
-* Reduce Internal Queries against System Catalogs.
-* Import PostgreSQL 12 SQL parser.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Downloads here].
-Release notes:
+* 4.5.1 :  [https://www.pgpool.net/docs/latest/en/html/release-4-5-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-5-1.html Japanese]
-[https://www.pgpool.net/docs/latest/en/html/ English]
+* 4.4.6 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-6.html Japanese]
-[https://www.pgpool.net/docs/latest/ja/html/ Japanese]
+* 4.3.9 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-9.html Japanese]
+* 4.2.16 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-16.html Japanese]
+* 4.1.19 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-19.html Japanese]
-=== Pgpool-II 4.0.7, 3.7.12, 3.6.19, 3.5.23 and 3.4.26 officially released (2019/10/31) ===
+=== Pgpool-II 4.5.0 released (2023/12/12) ===
-Pgpool-II 4.0.7, 3.7.12, 3.6.19, 3.5.23 and 3.4.26 officially released
+Pgpool-II 4.5.0 is now released. This is the first stable release of Pgpool-II 4.5.x.
-Please note that 3.4.26 is the last release of 3.4 series
+V4.5 contains new features and enhancements, including:
-because 5 years has passed since 3.4 was out (2014/11).
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Allow to use more kind of multiple statements in a query string.
-* 4.0.7 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-6.html Japanese]
+* Allow to load balance PREPARE/EXECUTE/DEALLOCATE.
-* 3.7.12 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-11.html Japanese]
-* 3.6.19 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-18.html Japanese]
-* 3.5.23 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-22.html Japanese]
-* 3.4.26:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-25.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-25.html Japanese]
-=== Pgpool-II 4.0.6, 3.7.11, 3.6.18, 3.5.22 and 3.4.25 officially released (2019/08/15) ===
+* Allow to set delay_threshold_by_time in milliseconds.
-Pgpool-II 4.0.6, 3.7.11, 3.6.18, 3.5.22 and 3.4.25 officially released
+* Avoid session disconnection issue in failover/failback/backend error in some cases.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Allow to route queries to a specific backend node for a specific user connection.
-* 4.0.6 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-6.html Japanese]
+* Support multiple directories specification for pcp_socket_dir.
-* 3.7.11 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-11.html Japanese]
-* 3.6.18 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-18.html Japanese]
-* 3.5.22 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-22.html Japanese]
-* 3.4.25:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-25.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-25.html Japanese]
-=== Pgpool-II 4.0.5, 3.7.10, 3.6.17, 3.5.21 and 3.4.24 officially released (2019/05/16) ===
+* Import PostgreSQL 16's SQL parser.
-Pgpool-II 4.0.5, 3.7.10, 3.6.17, 3.5.21 and 3.4.24 officially released
+You can download it from [https://www.pgpool.net/mediawiki/index.php/Downloads here].
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+Release notes:
+[https://www.pgpool.net/docs/45/en/html/release-4-5-0.html English]
-* 4.0.5 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-5.html Japanese]
+=== Pgpool-II 4.4.5, 4.3.8, 4.2.15, 4.1.18 and 4.0.25 officially released (2023/11/30) ===
-* 3.7.10 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-10.html Japanese]
-* 3.6.17 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-17.html Japanese]
-* 3.5.21 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-21.html Japanese]
-* 3.4.24:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-24.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-24.html Japanese]
-=== Pgpool-II 4.0.4, 3.7.9, 3.6.16, 3.5.20 and 3.4.23 officially released (2019/03/29) ===
+Pgpool-II 4.4.5, 4.3.8, 4.2.15, 4.1.18 and 4.0.25 officially released.
-Pgpool-II 4.0.4, 3.7.9, 3.6.16, 3.5.20 and 3.4.23 officially released
+Please note that 4.0.25 is the last release of the 4.0.x series.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 4.0.4 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-4.html Japanese]
+* 4.4.5 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-5.html Japanese]
-* 3.7.9 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-9.html Japanese]
+* 4.3.8 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-8.html Japanese]
-* 3.6.16 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-16.html Japanese]
+* 4.2.15 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-15.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-15.html Japanese]
-* 3.5.20 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-20.html Japanese]
+* 4.1.18 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-18.html Japanese]
-* 3.4.23:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-23.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-23.html Japanese]
+* 4.0.25 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-25.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-25.html Japanese]
-=== Pgpool-II 4.0.3, 3.7.8, 3.6.15, 3.5.19 and 3.4.22 officially released (2019/02/21) ===
+=== Pgpool-II 4.4.4, 4.3.7, 4.2.14, 4.1.17 and 4.0.24 officially released (2023/08/17) ===
-Pgpool-II 4.0.3, 3.7.8, 3.6.15, 3.5.19 and 3.4.22 officially released
+Pgpool-II 4.4.4, 4.3.7, 4.2.14, 4.1.17 and 4.0.24 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 4.0.3 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-3.html Japanese]
+* 4.4.4 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-4.html Japanese]
-* 3.7.8 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-8.html Japanese]
+* 4.3.7 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-7.html Japanese]
-* 3.6.15 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-15.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-15.html Japanese]
+* 4.2.14 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-14.html Japanese]
-* 3.5.19 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-19.html Japanese]
+* 4.1.17 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-17.html Japanese]
-* 3.4.22:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-22.html Japanese]
+* 4.0.24 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-24.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-24.html Japanese]
-=== pgpoolAdmin 4.0.1 officially released (2018/12/20) ===
-PgPool Global Development Group has released a Security Update of pgpoolAdmin.
-The purpose of this release is to address CVE-2018-16203, which
-allow an attacker to login without properly checking the authorization.
-Once getting into gpoolAdmin, the attacker can control Pgpool-II.
-Also it may be possible to obtain the superuser role of a PostgreSQL database.
-This vulnability affects all versions of pgpoolAdmin. We recommend
+=== Pgpool-II 4.4.3, 4.3.6, 4.2.13, 4.1.16 and 4.0.23 officially released (2023/05/18) ===
-upgrade pgpoolAdmin to 4.0.1 immediately (remember that PgpoolAdmin
-.0.1 is compatible with Pgpool-II 3.4 or later).
-PgPool Global Development Group would like to thank Fotios Rogkotis
+Pgpool-II 4.4.3, 4.3.6, 4.2.13, 4.1.16 and 4.0.23 officially released.
-of DarkMatter for finding the security issue and giving us the
-detailed studies on it.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-=== Pgpool-II 4.0.2, 3.7.7, 3.6.14, 3.5.18 and 3.4.21 officially released (2018/11/22) ===
+* 4.4.3 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-3.html Japanese]
+* 4.3.6 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-6.html Japanese]
+* 4.2.13 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-13.html Japanese]
+* 4.1.16 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-16.html Japanese]
+* 4.0.23 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-23.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-23.html Japanese]
-Pgpool-II 4.0.2, 3.7.7, 3.6.14, 3.5.18 and 3.4.21 officially released
+=== End-of-Life (EOL) Announcement for pgpoolAdmin (2023/02/17) ===
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+Pgpool Global Development Group announces end-of-life date for pgpoolAdmin, which is the management tool for Pgpool-II.
-* 4.0.2 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-2.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-2.html Japanese]
+Pgpool Global Development Group will provide maintenance for pgpoolAdmin 4.0, 4.1 and 4.2 until December 31, 2023.
-* 3.7.7 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-7.html Japanese]
+After this date, bug fixes and security fixes for these versions will no longer be provided.
-* 3.6.14 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-14.html Japanese]
-* 3.5.18 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-18.html Japanese]
-* 3.4.21:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-21.html Japanese]
-=== Pgpool-II 4.0.1, 3.7.6, 3.6.13, 3.5.17 and 3.4.20 officially released (2018/10/31) ===
+In addition, pgpoolAdmin for Pgpool-II 4.3 or later will not be released.
-Pgpool-II 4.0.1, 3.7.6, 3.6.13, 3.5.17 and 3.4.20 officially released
+We would like to thank you for using pgpoolAdmin over the years.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+=== Pgpool-II 4.4.2, 4.3.5, 4.2.12, 4.1.15 and 4.0.22 officially released (2023/01/23) ===
-* 4.0.1 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-1.html Japanese]
+Pgpool-II 4.4.2, 4.3.5, 4.2.12, 4.1.15 and 4.0.22 officially released.
-* 3.7.6 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-6.html Japanese]
-* 3.6.13 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-13.html Japanese]
-* 3.5.17 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-17.html Japanese]
-* 3.4.20:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-20.html Japanese]
-=== Pgpool-II 4.0.0 and pgpoolAdmin 4.0.0 officially released (2018/10/19) ===
+This release contains a security fix.
-Pgpool-II 4.0.0 and pgpoolAdmin 4.0.0 are now relased.
+If following conditions are all met, the password of "wd_lifecheck_user" is exposed by "SHOW POOL STATUS" command.
+The command can be executed by any user who can connect to Pgpool-II. (CVE-2023-22332)
+* Version 3.3 or later
+* use_watchdog = on
+* wd_lifecheck_method = 'query'
+* A plain text password is set to wd_lifecheck_password
-V4.0 has new features:
+In this case it is strongly recommended to upgrade to this version (we do not expose wd_lifecheck_password in show pool_status command any more), or use one of following workarounds.
-* Add SCRAM and Certificate authentication support.
+Workarounds for 4.0.x to 4.4.x users:
-* Detecting "false" primary server of PostgreSQL.
+* Disable watchdog. Set use_watchdog to off.
-* Improvements to load balancing:
+* Change wd_lifecheck_method to heartbeat.
-** More load balancing fine control after write queries.
+* Set an empty string to wd_lifecheck_password. This will use password in the pool_passwd file.
-** Load balancing control for specific queries.
+* Set an AES encrypted password to wd_lifecheck_password.
-** Allow to specify load balance weight ratio for load balance parameters.
-* Add last state change timestamp to SHOW POOL NODES.
-* Import PostgreSQL 11 SQL parser.
-* Logging client messages.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Downloads here].
+In any case we recommend to change "wd_lifecheck_password" in PostgreSQL.
-Release notes:
+Workarounds for 3.0.x to 3.7.x users:
-[https://www.pgpool.net/docs/latest/en/html/release-4-0.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0.html Japanese]
+* Disable watchdog. Set use_watchdog to off.
+* Change wd_lifecheck_method to heartbeat.
-=== Pgpool-II 3.7.5, 3.6.12, 3.5.16, 3.4.19 and 3.3.22 officially released (2018/07/31) ===
+In any case we recommend to change "wd_lifecheck_password" in PostgreSQL.
-Pgpool-II 3.7.5, 3.6.12, 3.5.16, 3.4.19 and 3.3.22 officially released
+Please note that Pgpool-II 3.7.x or before are end of life and no minor updates are provided for those versions.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.7.5 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-5.html Japanese]
+* 4.4.2 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-2.html Japanese]
-* 3.6.12 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-12.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-12.html Japanese]
+* 4.3.5 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-5.html Japanese]
-* 3.5.16 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-16.html Japanese]
+* 4.2.12 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-12.html Japanese]
-* 3.4.19:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-19.html Japanese]
+* 4.1.15 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-15.html Japanese]
-* 3.3.22:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-22.html Japanese]
+* 4.0.22 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-22.html Japanese]
-Please note that 3.3.22 is the last release of 3.3 series because 5 years has passed since 3.3 was out (2013/07/30).
+=== Pgpool-II 4.4.1, 4.3.4, 4.2.11, 4.1.14, 4.0.21 and 3.7.26 officially released (2022/12/22) ===
-=== Pgpool-II 3.7.4, 3.6.11, 3.5.15 and 3.4.18 officially released (2018/06/12) ===
+Pgpool-II 4.4.1, 4.3.4, 4.2.11, 4.1.14, 4.0.21 and 3.7.26 officially released.
-Pgpool-II 3.7.4, 3.6.11, 3.5.15 and 3.4.18 officially released
+You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* 4.4.1 :  [https://www.pgpool.net/docs/latest/en/html/release-4-4-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-4-1.html Japanese]
+* 4.3.4 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-4.html Japanese]
+* 4.2.11 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-11.html Japanese]
+* 4.1.14 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-14.html Japanese]
+* 4.0.21 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-21.html Japanese]
+* 3.7.26 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-26.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-26.html Japanese]
-* 3.7.4 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-4.html Japanese]
+=== Pgpool-II 4.4.0 released (2022/12/06) ===
-* 3.6.11 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-11.html Japanese]
-* 3.5.15 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-15.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-15.html Japanese]
-* 3.4.18:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-18.html Japanese]
-=== Pgpool-II 3.7.3, 3.6.10, 3.5.14, 3.4.17 and 3.3.21 officially released (2018/04/17) ===
+Pgpool-II 4.4.0 is now released. This is the first stable release of Pgpool-II 4.4.x.
-Pgpool-II 3.7.3, 3.6.10, 3.5.14, 3.4.17 and 3.3.21 officially released
+V4.4 contains new features and enhancements, including:
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Add new dynamic spare process management feature. This feature allows selecting between static and dynamic process management modes.
-* 3.7.3 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-3.html Japanese]
+* Allow to specify replication delay by time in streaming replication mode. For this purpose new parameter delay_threshold_by_time is introduced.
-* 3.6.10 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-10.html Japanese]
-* 3.5.14 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-14.html Japanese]
-* 3.4.17:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-17.html Japanese]
-* 3.3.21:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-21.html Japanese]
-=== Pgpool-II 3.7.2-2 RPMs are released. (2018/03/14) ===
+* As PostgreSQL already does, Pgpool-II now supports unix_socket_directories, unix_socket_group and unix_socket_permissions for more flexible and precise control of UNIX domain sockets.
-Pgpool-II 3.7.2-2 RPMs are released.
+* Allow to use comma separated multiple listen addresses in listen_addresses and pcp_listen_addresses. They control which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Allow to customize the command used by trusted_servers for checking upstream connection. For this purpose new parameter trusted_server_command is introduced.
-=== Pgpool-II 3.7.2, 3.6.9, 3.5.13, 3.4.16 and 3.3.20 officially released (2018/02/13) ===
+* Import PostgreSQL 15's SQL parser.
-Pgpool-II 3.7.2, 3.6.9, 3.5.13, 3.4.16 and 3.3.20 officially released
+* Speed up query cache by reducing lock contention. This allows concurrent running clients to fetch cache contents much more quicker.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+You can download it from [https://www.pgpool.net/mediawiki/index.php/Downloads here].
-* 3.7.2 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-2.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-2.html Japanese]
+Release notes:
-* 3.6.9 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-9.html Japanese]
+[https://www.pgpool.net/docs/44/en/html/release-4-4-0.html English] [https://www.pgpool.net/docs/44/ja/html/release-4-4-0.html Japanese]
-* 3.5.13 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-13.html Japanese]
-* 3.4.16:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-16.html Japanese]
-* 3.3.20:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-20.html Japanese]
-=== pgpoolAdmin 3.7.1 officially released (2018/02/05) ===
+=== Pgpool-II 4.3.3, 4.2.10, 4.1.13, 4.0.20 and 3.7.25 officially released (2022/08/18) ===
-pgpoolAdmin 3.7.1 is officially released.
+Pgpool-II 4.3.3, 4.2.10, 4.1.13, 4.0.20 and 3.7.25 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-[https://www.pgpool.net/docs/pgpoolAdmin/NEWS Release notes]
+* 4.3.3 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-3.html Japanese]
+* 4.2.10 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-10.html Japanese]
+* 4.1.13 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-13.html Japanese]
+* 4.0.20 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-20.html Japanese]
+* 3.7.25 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-25.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-25.html Japanese]
-=== Pgpool-II 3.7.1, 3.6.8, 3.5.12, 3.4.15 and 3.3.19 officially released (2018/01/09) ===
+=== Pgpool-II 4.3.2, 4.2.9, 4.1.12, 4.0.19 and 3.7.24 officially released (2022/05/19) ===
-Pgpool-II 3.7.1, 3.6.8, 3.5.12, 3.4.15 and 3.3.19 officially released
+Pgpool-II 4.3.2, 4.2.9, 4.1.12, 4.0.19 and 3.7.24 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.7.1 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-1.html Japanese]
+* 4.3.2 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-2.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-2.html Japanese]
-* 3.6.8 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-8.html Japanese]
+* 4.2.9 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-9.html Japanese]
-* 3.5.12 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-12.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-12.html Japanese]
+* 4.1.12 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-12.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-12.html Japanese]
-* 3.4.15:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-15.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-15.html Japanese]
+* 4.0.19 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-19.html Japanese]
-* 3.3.19:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-19.html Japanese]
+* 3.7.24 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-24.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-24.html Japanese]
-=== Pgpool-II 3.7.0 and pgpoolAdmin 3.7.0 officially released (2017/11/22) ===
+=== Pgpool-II 4.3.1, 4.2.8, 4.1.11, 4.0.18 and 3.7.23 officially released (2022/02/17) ===
-Pgpool-II 3.7.0 and pgpoolAdmin 3.7.0 are now relased.
+Pgpool-II 4.3.1, 4.2.8, 4.1.11, 4.0.18 and 3.7.23 officially released.
-V3.7 has new features:
-* Quorum aware failover feature.
-* Allow specifying the hostnames in pool_hba.
-* Allow to specify per node health check parameters.
-* Support AWS Aurora.
-* Import PostgreSQL 10 SQL parser.
-* Support logical replication.
-* etc.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-Release notes:
+* 4.3.1 :  [https://www.pgpool.net/docs/latest/en/html/release-4-3-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-3-1.html Japanese]
-[https://www.pgpool.net/docs/latest/en/html/release-3-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7.html Japanese]
+* 4.2.8 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-8.html Japanese]
+* 4.1.11 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-11.html Japanese]
-=== Pgpool-II 3.6.7, 3.5.11, 3.4.14 and 3.3.18 officially released (2017/11/01) ===
+* 4.0.18 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-18.html Japanese]
+* 3.7.23 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-23.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-23.html Japanese]
-Pgpool-II 3.6.7, 3.5.11, 3.4.14 and 3.3.18 officially released
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.6.7 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-7.html Japanese]
+=== Pgpool-II 4.2.7, 4.1.10, 4.0.17 and 3.7.22 officially released (2021/12/23) ===
-* 3.5.11 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-11.html Japanese]
-* 3.4.14:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-14.html Japanese]
-* 3.3.18:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-18.html Japanese]
-=== Pgpool-II 3.6.6, 3.5.10, 3.4.13, 3.3.17 and 3.2.22 officially released (2017/09/05) ===
+Pgpool-II 4.2.7, 4.1.10, 4.0.17 and 3.7.22 officially released.
-Pgpool-II 3.6.6, 3.5.10, 3.4.13, 3.3.17, 3.2.22 and pgpoolAdmin 3.6.2 officially released
+The purpose of this release is to provide packages for PostgreSQL 14.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.6.6 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-6.html Japanese]
+* 4.2.7 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-7.html Japanese]
-* 3.5.10 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-10.html Japanese]
+* 4.1.10 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-10.html Japanese]
-* 3.4.13:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-13.html Japanese]
+* 4.0.17 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-17.html Japanese]
-* 3.3.17:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-17.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-17.html Japanese]
+* 3.7.22 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-22.html Japanese]
-* 3.2.22:  [https://www.pgpool.net/docs/latest/en/html/release-3-2-22.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-2-22.html Japanese]
-=== Pgpool-II 3.6.5, 3.5.9, 3.4.12, 3.3.16 and 3.2.21 officially released (2017/07/11) ===
+=== Pgpool-II 4.3.0 released (2021/12/07) ===
-Pgpool-II 3.6.5, 3.5.9, 3.4.12, 3.3.16 and 3.2.21 officially released
+Pgpool-II 4.3.0 is now released. Please take a look at [https://www.pgpool.net/docs/43/en/html/release-4-3-0.html 4.3.0]
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+V4.3.0 contains new features and enhancements, including:
+* A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.
-* 3.6.5 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-5.html Japanese]
+* Allow to choose the least replication delay standby node when selecting the load balance node.
-* 3.5.9 :  [https://www.pgpool.net/docs/latest/en/html/release-3-5-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-9.html Japanese]
-* 3.4.12:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-12.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-12.html Japanese]
-* 3.3.16:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-16.html Japanese]
-* 3.2.21:  [https://www.pgpool.net/docs/latest/en/html/release-3-2-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-2-21.html Japanese]
-=== Pgpool-II 3.6.4, 3.5.8 officially released (2017/05/11) ===
+* Allow to specify the node id to be promoted in pcp_promote_node.
-Pgpool-II 3.6.4, 3.5.8 officially released
+* Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.
-* 3.6.4:  [https://www.pgpool.net/docs/latest/en/html/release-3-6-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-4.html Japanese]
+* Allow pcp_node_info to list all backend nodes information.
-* 3.5.8:  [https://www.pgpool.net/docs/latest/en/html/release-3-5-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-8.html Japanese]
-=== Pgpool-II 3.6.3, 3.5.7, 3.4.11, 3.3.15, 3.2.20 and pgpoolAdmin 3.6.1 officially released (2017/04/28) ===
+* Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.
-Pgpool-II 3.6.3, 3.5.7, 3.4.11, 3.3.15, 3.2.20 and pgpoolAdmin 3.6.1 officially released
+* Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Add support for log time stamp with milliseconds.
-* 3.6.3:  [https://www.pgpool.net/docs/latest/en/html/release-3-6-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-3.html Japanese]
+* Import PostgreSQL 14's SQL parser.
-* 3.5.7:  [https://www.pgpool.net/docs/latest/en/html/release-3-5-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-7.html Japanese]
-* 3.4.11:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-11.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-11.html Japanese]
-* 3.3.15:  [https://www.pgpool.net/docs/latest/ja/html/release-3-3-15.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-15.html Japanese]
-* 3.2.20:  [https://www.pgpool.net/docs/latest/ja/html/release-3-2-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-2-20.html Japanese]
-=== Pgpool-II 3.6.2, 3.5.6, 3.4.10, 3.3.14 and 3.2.19 officially released (2017/03/17) ===
+* Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.
-Pgpool-II 3.6.2, 3.5.6, 3.4.10, 3.3.14 and 3.2.19 officially released
+* pgpool.conf sample files are unified into single sample file for easier configuration.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.
-* 3.6.2:  [https://www.pgpool.net/docs/latest/en/html/release-3-6-2.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-2.html Japanese]
+You can download it from [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.5.6:  [https://www.pgpool.net/docs/latest/en/html/release-3-5-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-6.html Japanese]
-* 3.4.10:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-10.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-10.html Japanese]
-* 3.3.14:  [https://www.pgpool.net/docs/latest/ja/html/release-3-3-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-14.html Japanese]
-* 3.2.19:  [https://www.pgpool.net/docs/latest/ja/html/release-3-2-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-2-19.html Japanese]
-=== pgpoolAdmin 3.6.0 officially released (2017/02/28) ===
+Release notes:
+[https://www.pgpool.net/docs/43/en/html/release-4-3-0.html English]
-pgpoolAdmin 3.6.0 is officially released.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-=== pgpool-II 3.6.1, 3.5.5, 3.4.9, 3.3.13, 3.2.18 and 3.1.21 officially released (2016/12/26) ===
+=== Pgpool-II 4.2.6, 4.1.9, 4.0.16, 3.7.21 and 3.6.28 officially released (2021/11/18) ===
-These are the latest stable versions of each major branches.
+Pgpool-II 4.2.6, 4.1.9, 4.0.16, 3.7.21 and 3.6.28 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.6.1:  [https://www.pgpool.net/docs/latest/en/html/release-3-6-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-1.html Japanese]
+* 4.2.6 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-6.html Japanese]
-* 3.5.5:  [https://www.pgpool.net/docs/latest/en/html/release-3-5-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-5-5.html Japanese]
+* 4.1.9 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-9.html Japanese]
-* 3.4.9:  [https://www.pgpool.net/docs/latest/en/html/release-3-4-9.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-4-9.html Japanese]
+* 4.0.16 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-16.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-16.html Japanese]
-* 3.3.13:  [https://www.pgpool.net/docs/latest/en/html/release-3-3-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-3-13.html Japanese]
+* 3.7.21 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-21.html Japanese]
-* 3.2.18:  [https://www.pgpool.net/docs/latest/en/html/release-3-2-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-2-18.html Japanese]
+* 3.6.28 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-28.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-28.html Japanese]
-* 3.1.21:  [https://www.pgpool.net/docs/latest/en/html/release-3-1-21.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-1-21.html Japanese]
-pgpool-II 3.1.21 is the final release of the 3.1.x. This series has reached "End of Life", and is no longer maintained and does not receive any updates.
+=== Pgpool-II 4.2.5 released (2021/09/14) ===
-=== pgpool-II 3.6.0 officially released (2016/11/21) ===
+Pgpool Global Development Group is pleased to announce the availability of Pgpool-II 4.2.5.
-Pgpool-II 3.6.0 is now officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-V3.6's new features are:
+* 4.2.5 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-5.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-5.html Japanese]
-* Improve the behavior of fail-over.
+=== Pgpool-II 4.2.4, 4.1.8, 4.0.15, 3.7.20 and 3.6.27 officially released (2021/08/05) ===
-* New PGPOOL SET command has been introduced.
-* Watchdog is significantly enhanced.
-* Handling of extended query protocol (e.g. used by Java applications) in streaming replication mode speeds up if many rows are returned in a result set.
-* Import parser of PostgreSQL 9.6.
-* In some cases pg_terminate_backend() now does not trigger a fail-over.
-* Change documentation format from raw HTML to SGML.
-* etc.
-=== pgpool-II 3.5.4, 3.4.8, 3.3.12, 3.2.17 and 3.1.20 officially released (2016/08/31) ===
+Pgpool-II 4.2.4, 4.1.8, 4.0.15, 3.7.20 and 3.6.27 officially released.
-These are the latest stable versions of each major branches.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.5.4:  [https://www.pgpool.net/docs/pgpool-II-3.5.4/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.5.4/doc/pgpool-ja.html#release3.5.4 Japanese]
+* 4.2.4 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-4.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-4.html Japanese]
-* 3.4.8:  [https://www.pgpool.net/docs/pgpool-II-3.4.8/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.8/doc/pgpool-ja.html#release3.4.8 Japanese]
+* 4.1.8 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-8.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-8.html Japanese]
-* 3.3.12:  [https://www.pgpool.net/docs/pgpool-II-3.3.12/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.12/doc/pgpool-ja.html#release3.3.12 Japanese]
+* 4.0.15 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-15.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-15.html Japanese]
-* 3.2.17:  [https://www.pgpool.net/docs/pgpool-II-3.2.17/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.17/doc/pgpool-ja.html#release3.2.17 Japanese]
+* 3.7.20 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-20.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-20.html Japanese]
-* 3.1.20: [https://www.pgpool.net/docs/pgpool-II-3.1.20/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.20/doc/pgpool-ja.html#release3.1.20 Japanese]
+* 3.6.27 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-27.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-27.html Japanese]
-=== pgpool-II 3.5.3, 3.4.7, 3.3.11, 3.2.16, 3.1.19, and pgpoolAdmin 3.5.3 officially released (2016/06/17) ===
+=== pgpoolAdmin 4.2.0 officially released (2021/06/17) ===
-These are the latest stable versions of each major branches.
+pgpoolAdmin 4.2.0 officially released.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+pgpoolAdmin 4.2.0 adds support for Pgpool-II 4.2.
+Please take a look at [https://www.pgpool.net/docs/pgpoolAdmin/NEWS release notes].
-* 3.5.3:  [https://www.pgpool.net/docs/pgpool-II-3.5.3/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.5.3/doc/pgpool-ja.html#release3.5.3 Japanese]
-* 3.4.7:  [https://www.pgpool.net/docs/pgpool-II-3.4.7/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.7/doc/pgpool-ja.html#release3.4.7 Japanese]
-* 3.3.11:  [https://www.pgpool.net/docs/pgpool-II-3.3.11/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.11/doc/pgpool-ja.html#release3.3.11 Japanese]
-* 3.2.16:  [https://www.pgpool.net/docs/pgpool-II-3.2.16/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.16/doc/pgpool-ja.html#release3.2.16 Japanese]
-* 3.1.19: [https://www.pgpool.net/docs/pgpool-II-3.1.19/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.19/doc/pgpool-ja.html#release3.1.19 Japanese]
-=== pgpool-II 3.5.2, 3.4.6, 3.3.10, 3.2.15, 3.1.18, and pgpoolAdmin 3.5.2 officially released (2016/04/26) ===
-These are the latest stable versions of each major branches.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.5.2:  [https://www.pgpool.net/docs/pgpool-II-3.5.2/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.5.2/doc/pgpool-ja.html#release3.5.2 Japanese]
+=== Pgpool-II 4.2.3, 4.1.7, 4.0.14, 3.7.19 and 3.6.26 officially released (2021/05/20) ===
-* 3.4.6:  [https://www.pgpool.net/docs/pgpool-II-3.4.6/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.6/doc/pgpool-ja.html#release3.4.6 Japanese]
-* 3.3.10:  [https://www.pgpool.net/docs/pgpool-II-3.3.10/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.10/doc/pgpool-ja.html#release3.3.10 Japanese]
-* 3.2.15:  [https://www.pgpool.net/docs/pgpool-II-3.2.15/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.15/doc/pgpool-ja.html#release3.2.15 Japanese]
-* 3.1.18: [https://www.pgpool.net/docs/pgpool-II-3.1.18/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.18/doc/pgpool-ja.html#release3.1.18 Japanese]
-=== pgpool-II 3.5.1, 3.4.5, 3.3.9, 3.2.14, 3.1.17, and pgpoolAdmin 3.5.1 officially released (2016/04/04) ===
-These are the latest stable versions of each major branches.
+Pgpool-II 4.2.3, 4.1.7, 4.0.14, 3.7.19 and 3.6.26 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.5.1:  [https://www.pgpool.net/docs/pgpool-II-3.5.1/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.5.1/doc/pgpool-ja.html#release3.5.1 Japanese]
+* 4.2.3 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-3.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-3.html Japanese]
-* 3.4.5:  [https://www.pgpool.net/docs/pgpool-II-3.4.5/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.5/doc/pgpool-ja.html#release3.4.5 Japanese]
+* 4.1.7 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-7.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-7.html Japanese]
-* 3.3.9:  [https://www.pgpool.net/docs/pgpool-II-3.3.9/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.9/doc/pgpool-ja.html#release3.3.9 Japanese]
+* 4.0.14 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-14.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-14.html Japanese]
-* 3.2.14:  [https://www.pgpool.net/docs/pgpool-II-3.2.14/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.14/doc/pgpool-ja.html#release3.2.14 Japanese]
+* 3.7.19 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-19.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-19.html Japanese]
-* 3.1.17: [https://www.pgpool.net/docs/pgpool-II-3.1.17/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.17/doc/pgpool-ja.html#release3.1.17 Japanese]
+* 3.6.26 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-26.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-26.html Japanese]
-=== pgpool-II 3.4.4, 3.3.8, 3.2.13, 3.1.16, and 3.0.20 officially released (2016/02/05) ===
+=== Pgpool-II 4.2.2, 4.1.6, 4.0.13, 3.7.18 and 3.6.25 officially released (2021/02/18) ===
-These are the latest stable versions of each major branches.
+Pgpool-II 4.2.2, 4.1.6, 4.0.13, 3.7.18 and 3.6.25 officially released.
 You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.4.4:  [https://www.pgpool.net/docs/pgpool-II-3.4.4/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.4/doc/pgpool-ja.html#release3.4.4 Japanese]
+* 4.2.2 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-2.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-2.html Japanese]
-* 3.3.8:  [https://www.pgpool.net/docs/pgpool-II-3.3.8/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.8/doc/pgpool-ja.html#release3.3.8 Japanese]
+* 4.1.6 :  [https://www.pgpool.net/docs/latest/en/html/release-4-1-6.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-1-6.html Japanese]
-* 3.2.13:  [https://www.pgpool.net/docs/pgpool-II-3.2.13/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.13/doc/pgpool-ja.html#release3.2.13 Japanese]
+* 4.0.13 :  [https://www.pgpool.net/docs/latest/en/html/release-4-0-13.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-0-13.html Japanese]
-* 3.1.16: [https://www.pgpool.net/docs/pgpool-II-3.1.16/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.16/doc/pgpool-ja.html#release3.1.16 Japanese]
+* 3.7.18 :  [https://www.pgpool.net/docs/latest/en/html/release-3-7-18.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-7-18.html Japanese]
-* 3.0.20: [https://www.pgpool.net/docs/pgpool-II-3.0.20/doc/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.0.20/doc/pgpool-ja.html#release3.0.20 Japanese]
+* 3.6.25 :  [https://www.pgpool.net/docs/latest/en/html/release-3-6-25.html English] [https://www.pgpool.net/docs/latest/ja/html/release-3-6-25.html Japanese]
-pgpool-II 3.0.20 is the final release of the 3.0.x. This series has reached "End of Life", and is no longer maintained and does not receive any updates.
+=== Pgpool-II 4.2.1 released (2020/12/23) ===
-=== pgpool-II 3.5.0 and pgpoolAdmin 3.5.0 officially released (2016/01/29) ===
+Pgpool-II 4.2.1 is now released.
-Pgpool-II 3.5.0 and pgpoolAdmin 3.5.0 are now officially released.
+You can download them from [https://pgpool.net/mediawiki/index.php/Downloads here].
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* 4.2.1 :  [https://www.pgpool.net/docs/latest/en/html/release-4-2-1.html English] [https://www.pgpool.net/docs/latest/ja/html/release-4-2-1.html Japanese]
+=== Pgpool-II 4.2.0 released (2020/11/26) ===
-V3.5's new features are:
+Pgpool-II 4.2.0 is now released.
-* Improved performance in extended query protocol
+V4.2 contains new features and enhancements, including:
-* Overcoming the thundering herd problem
-* watchdog feature enhancements to be more robust and adaptable
-* PCP command enhancements
-* Import PostgreSQL 9.5 parser
-* etc.
-Please see [https://pgpool.net/mediawiki/index.php?title=pgpool-II_3.5_features&redirect=no this] for details.
+* Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.
+* Implement logging_collector for easier log management.
-.5.0 release note:  [https://www.pgpool.net/docs/pgpool-II-3.5.0/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.5.0/doc/pgpool-ja.html#release3.5.0 Japanese]
+* Implement log_disconnections to collect disconnection logs.
-=== pgpool-II 3.4.3, 3.3.7, 3.2.12, 3.1.15, and 3.0.19 officially released (2015/07/24) ===
+* Implement pg_enc and pg_md5 to allow to register multiple passwords at once.
-These are the latest stable versions of each major branches.
+* Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* New PCP command pcp_reload_config is added.
-* 3.4.3:  [https://www.pgpool.net/docs/pgpool-II-3.4.3/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.3/doc/pgpool-ja.html#release3.4.3 Japanese]
+* Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.
-* 3.3.7:  [https://www.pgpool.net/docs/pgpool-II-3.3.7/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.7/doc/pgpool-ja.html#release3.3.7 Japanese]
-* 3.2.12:  [https://www.pgpool.net/docs/pgpool-II-3.2.12/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.12/doc/pgpool-ja.html#release3.2.12 Japanese]
-* 3.1.15: [https://www.pgpool.net/docs/pgpool-II-3.1.15/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.15/doc/pgpool-ja.html#release3.1.15 Japanese]
-* 3.0.19: [https://www.pgpool.net/docs/pgpool-II-3.0.19/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.0.19/doc/pgpool-ja.html#release3.0.19 Japanese]
+* Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.
-=== pgpool-II 3.4.2, 3.3.6, 3.2.11, 3.1.14, and 3.0.18 officially released (2015/04/08) ===
+* Support LDAP authentication between clients and Pgpool-II.
-These are the latest stable versions of each major branches.
+* Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Import PostgreSQL 13's SQL parser.
-* 3.4.2:  [https://www.pgpool.net/docs/pgpool-II-3.4.2/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.2/doc/pgpool-ja.html#release3.4.2 Japanese]
+You can download it from [https://pgpool.net/mediawiki/index.php/Downloads here].
-* 3.3.6:  [https://www.pgpool.net/docs/pgpool-II-3.3.6/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.6/doc/pgpool-ja.html#release3.3.6 Japanese]
-* 3.2.11:  [https://www.pgpool.net/docs/pgpool-II-3.2.11/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.11/doc/pgpool-ja.html#release3.2.11 Japanese]
-* 3.1.14: [https://www.pgpool.net/docs/pgpool-II-3.1.14/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.14/doc/pgpool-ja.html#release3.1.14 Japanese]
-* 3.0.18: [https://www.pgpool.net/docs/pgpool-II-3.0.18/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.0.18/doc/pgpool-ja.html#release3.0.18 Japanese]
-=== pgpool-II 3.4.1, 3.3.5, 3.2.10, 3.1.13, 3.0.17  and pgpoolAdmin 3.4.1 officially released (2015/02/05) ===
+Release notes:
+[https://www.pgpool.net/docs/42/en/html/release-4-2-0.html English]
-These are the latest stable versions of each major branches.
+== Development ==
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+=== Pgpool-II 4.6 RC1 released (2025/02/20) ===
-* 3.4.1:  [https://www.pgpool.net/docs/pgpool-II-3.4.1/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.1/doc/pgpool-ja.html#release3.4.1 Japanese]
+Pgpool-II 4.6 RC1 is now released.
-* 3.3.5:  [https://www.pgpool.net/docs/pgpool-II-3.3.5/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.5/doc/pgpool-ja.html#release3.3.5 Japanese]
-* 3.2.10:  [https://www.pgpool.net/docs/pgpool-II-3.2.10/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.10/doc/pgpool-ja.html#release3.2.10 Japanese]
-* 3.1.13: [https://www.pgpool.net/docs/pgpool-II-3.1.13/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.13/doc/pgpool-ja.html#release3.1.13 Japanese]
-* 3.0.17: [https://www.pgpool.net/docs/pgpool-II-3.0.17/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.0.17/doc/pgpool-ja.html#release3.0.17 Japanese]
-* pgpoolAdmin 3.4.1: [https://www.pgpool.net/docs/pgpoolAdmin-3.4.1/NEWS.txt English]
+Note that this is not a stable version but just for developers.
-=== The pgpool-II official yum repository released (2014/12/16) ===
+V4.6 contains new features and enhancements, including:
-PgPool Global Development Group announced the pgpool-II official yum repository.
+* New PCP command to trigger log rotation.
-With this repository, you will be able to install or update pgpool-II and pgpoolAdmin etc. by using yum.
-https://www.pgpool.net/yum/
+* Allow logging_collector related parameters to be changed by reloading.
-The yum repository currently supports pgpool-II 3.3 or above with RHEL6 x86_64.
+* New PCP command to invalidate query cache.
-See [[Yum Repository]] for detail.
+* Allow to force to create query cache
-=== pgpool-II 3.4.0 and pgpoolAdmin 3.4.0 officially released (2014/11/07) ===
+* New PGPOOL SET CACHE DELETE command.
-Pgpool-II 3.4.0 is now officially released.
+* New configuration parameter log_backend_messages.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Import PostgreSQL 17's SQL parser.
+* Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.
-V3.4's new features are:
+You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-* Allow fine control of load balancing by using application name or database name
+Release notes:
-* New features about log output
+[https://www.pgpool.net/docs/46/en/html/release-4-6-0.html English]
-** Allow to print pgpool-II process names
-**  Allow to control log verbosity like PostgreSQL
-* SQL parser compatible with PostgreSQL 9.4
-* Import PostgreSQL's memory manager and exception manager
-* Support IPv6 address
-* Reorganize source code tree
-* etc.
+=== Pgpool-II 4.6 beta1 released (2025/02/13) ===
-* 3.4.0 release note:  [https://www.pgpool.net/docs/pgpool-II-3.4.0/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.4.0/doc/pgpool-ja.html#release3.4.0 Japanese]
+Pgpool-II 4.6 beta1 is now released.
-=== pgpool-II 3.3.4, 3.2.9, 3.1.12, and 3.0.16 are officially released (2014/09/05) ===
+Note that this is not a stable version but just for developers.
-These are the latest stable versions of each major branches.
+V4.6 contains new features and enhancements, including:
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* New PCP command to trigger log rotation.
-* 3.3.4:  [https://www.pgpool.net/docs/pgpool-II-3.3.4/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.4/doc/pgpool-ja.html#release3.3.4 Japanese]
+* Allow logging_collector related parameters to be changed by reloading.
-* 3.2.9:  [https://www.pgpool.net/docs/pgpool-II-3.2.9/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.9/doc/pgpool-ja.html#release3.2.9 Japanese]
-* 3.1.12: [https://www.pgpool.net/docs/pgpool-II-3.1.12/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.12/doc/pgpool-ja.html#release3.1.12 Japanese]
-* 3.0.16: [https://www.pgpool.net/docs/pgpool-II-3.0.16/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.0.16/doc/pgpool-ja.html#release3.0.16 Japanese]
-=== pgpool-ha 2.2 released (2014/04/01) ===
+* New PCP command to invalidate query cache.
-This is the latest stable version.
+* Allow to force to create query cache
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads#pgpool-HA here].
+* New PGPOOL SET CACHE DELETE command.
+* New configuration parameter log_backend_messages.
-=== pgpool-II 3.3.3, 3.2.8, 3.1.11, 3.0.15  and pgpoolAdmin 3.3.1 officially released (2014/03/24) ===
+* Import PostgreSQL 17's SQL parser.
-These are the latest stable versions of each major branches.
+* Add IPv6 support for watchdog hostname and heartbeat_hostname parameter.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-* 3.3.3:  [https://www.pgpool.net/docs/pgpool-II-3.3.3/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.3/doc/pgpool-ja.html#release3.3.3 Japanese]
+Release notes:
-* 3.2.8:  [https://www.pgpool.net/docs/pgpool-II-3.2.8/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.8/doc/pgpool-ja.html#release3.2.8 Japanese]
+[https://www.pgpool.net/docs/46/en/html/release-4-6-0.html English]
-* 3.1.11: [https://www.pgpool.net/docs/pgpool-II-3.1.11/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.11/doc/pgpool-ja.html#release3.1.11 Japanese]
-* 3.0.15: [https://www.pgpool.net/docs/pgpool-II-3.0.15/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.0.15/doc/pgpool-ja.html#release3.0.15 Japanese]
-* pgpoolAdmin 3.3.1: [https://www.pgpool.net/docs/pgpoolAdmin-3.3.1/NEWS.txt English]
+=== Pgpool-II 4.5 RC1 released (2023/11/28) ===
-=== pgpool-II 3.2.7, 3.1.10, 3.0.14 officially released (2013/12/06) ===
+Pgpool-II 4.5 RC1 is now released.
-These are the latest stable versions of each major branches.
+Note that this is not a stable version but just for developers.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+V4.5 contains new features and enhancements, including:
-* 3.2.7:  [https://www.pgpool.net/docs/pgpool-II-3.2.7/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.2.7/doc/pgpool-ja.html#release3.2.7 Japanese]
+* Allow to use multiple statements in a query string.
-* 3.1.10: [https://www.pgpool.net/docs/pgpool-II-3.1.10/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.1.10/doc/pgpool-ja.html#release3.1.10 Japanese]
-* 3.0.14: [https://www.pgpool.net/docs/pgpool-II-3.0.14/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.0.14/doc/pgpool-ja.html#release3.0.14 Japanese]
-=== pgpool-II 3.3.2 officially released (2013/11/29) ===
+* Allow to set delay_threshold_by_time in milliseconds.
-These are the latest stable version of 3.3.
+* Avoid session disconnection issue in failover/failback/backend error in some cases.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Allow to route queries to a specific backend node for a specific user connection.
-* 3.3.2: [https://www.pgpool.net/docs/pgpool-II-3.3.2/NEWS.txt English] [https://www.pgpool.net/docs/pgpool-II-3.3.2/doc/pgpool-ja.html#release3.0.7 Japanese]
+* Support multiple directories specification for pcp_socket_dir.
-=== pgpool-II 3.3.1, 3.2.6, 3.1.9, 3.0.13 officially released (2013/09/06) ===
+* Import PostgreSQL 16's SQL parser.
-These are the latest stable versions of each major branches.
+You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+Release notes:
+[https://www.pgpool.net/docs/45/en/html/release-4-5-0.html English]
-=== Missing regression test suite in pgpool-II 3.3.0.tar.gz (2013/07/31) ===
+=== Pgpool-II 4.5 beta1 released (2023/11/14) ===
-New regression test suite was not accidentally included in the pgpool-II 3.3.0.tar.gz tar ball.
+Pgpool-II 4.5 beta1 is now released.
-You can get it from git repository or download from
-[https://www.pgpool.net/download.php?f=regression-3.3.0.tar.gz here].
-=== pgpool-II 3.3 and pgpoolAdmin 3.3 officially released (2013/07/30) ===
+Note that this is not a stable version but just for developers.
-Pgpool-II 3.3 is now officially released.
+V4.5 contains new features and enhancements, including:
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+* Allow to use multiple statements in a query string.
-V3.3's new features are:
+* Allow to set delay_threshold_by_time in milliseconds.
-* Enhancements for watchdog
+* Avoid session disconnection issue in failover/failback/backend error in some cases.
-** New monitoring method of watchdog lifecheck using heartbeat signal
-** Interlocking of failover/failback script
-** Secure watchdog communication
-** PCP command for retrieving the watchdog status
-** etc.
-* Othres
-** Import PostgreSQL 9.2 raw parser
-** New pgpool_setup tool
-** Support for using CREATE EXTENSION to install pgpool specific extensions
-** regression test suit
-** etc.
-* [https://www.pgpool.net/docs/pgpool-II-3.3.0/NEWS.txt pgpool-II 3.3 release note (English)]
+* Allow to route queries to a specific backend node for a specific user connection.
-* [https://www.pgpool.net/docs/pgpool-II-3.3.0/pgpool-ja.html#release3.3.0 pgpool-II 3.3 release note (Japanese)]
-=== pgpool-II 3.2.5, 3.1.8, 3.0.12 officially released (2013/07/10) ===
+* Support multiple directories specification for pcp_socket_dir.
-These are the latest stable versions of each major branches.
+* Import PostgreSQL 16's SQL parser.
-You can download them [https://pgpool.net/mediawiki/index.php/Downloads here].
+You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-== Development ==
+Release notes:
+[https://www.pgpool.net/docs/45/en/html/release-4-5-0.html English]
-=== Pgpool-II 4.2 beta1 released (2020/10/27) ===
+=== Pgpool-II 4.4 RC1 released (2022/11/22) ===
-Pgpool-II 4.2 beta1 is now released.
+Pgpool-II 4.4 RC1 is now released.
 Note that this is not a stable version but just for developers.
-V4.2 contains new features and enhancements, including:
+V4.4 contains new features and enhancements, including:
-* Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.
+* Add new dynamic spare process management feature. This feature allows selecting between static and dynamic process management modes.
-* Implement logging_collector for easier log management.
+* Allow to specify replication delay by time in streaming replication mode. For this purpose new parameter delay_threshold_by_time is introduced.
-* Implement log_disconnections to collect disconnection logs.
+* As PostgreSQL already does, Pgpool-II now supports unix_socket_directories, unix_socket_group and unix_socket_permissions for more flexible and precise control of UNIX domain sockets.
-* Implement pg_enc and pg_md5 to allow to register multiple passwords at once.
+* Allow to use comma separated multiple listen addresses in listen_addresses and pcp_listen_addresses. They control which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces.
-* Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.
+* Allow to customize the command used by trusted_servers for checking upstream connection. For this purpose new parameter trusted_server_command is introduced.
-* New PCP command pcp_reload_config is added.
+* Import PostgreSQL 15's SQL parser.
-* Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.
+* Speed up query cache by reducing lock contention. This allows concurrent running clients to fetch cache contents much more quicker.
-* Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.
-* Support LDAP authentication between clients and Pgpool-II.
-* Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
-* Import PostgreSQL 13's SQL parser.
 You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
 Release notes:
-[https://www.pgpool.net/docs/42/en/html/release-4-2-0.html English]
+[https://www.pgpool.net/docs/44/en/html/release-4-4-0.html English]
-=== Pgpool-II 4.2 alpha1 released (2020/10/06) ===
+=== Pgpool-II 4.4 beta1 released (2022/11/14) ===
-Pgpool-II 4.2 alpha1 is now released.
+Pgpool-II 4.4 beta1 is now released.
 Note that this is not a stable version but just for developers.
-V4.2 contains new features and enhancements, including:
+V4.4 contains new features and enhancements, including:
-* Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.
+* Add new dynamic spare process management feature. This feature allows selecting between static and dynamic process management modes.
-* Implement logging_collector for easier log management.
+* Allow to specify replication delay by time in streaming replication mode. For this purpose new parameter delay_threshold_by_time is introduced.
-* Implement log_disconnections to collect disconnection logs.
+* As PostgreSQL already does, Pgpool-II now supports unix_socket_directories, unix_socket_group and unix_socket_permissions for more flexible and precise control of UNIX domain sockets.
-* Implement pg_enc and pg_md5 to allow to register multiple passwords at once.
+* Allow to use comma separated multiple listen addresses in listen_addresses and pcp_listen_addresses. They control which interfaces accept connection attempts, which can help prevent repeated malicious connection requests on insecure network interfaces.
-* Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.
+* Allow to customize the command used by trusted_servers for checking upstream connection. For this purpose new parameter trusted_server_command is introduced.
-* New PCP command pcp_reload_config is added.
+* Import PostgreSQL 15's SQL parser.
-* Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.
+* Speed up query cache by reducing lock contention. This allows concurrent running clients to fetch cache contents much more quicker.
-* Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.
+You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-* Support LDAP authentication between clients and Pgpool-II.
+Release notes:
+[https://www.pgpool.net/docs/44/en/html/release-4-4-0.html English]
-* Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
+=== Pgpool-II 4.3 RC1 released (2021/11/25) ===
-* Import PostgreSQL 13's SQL parser.
+Pgpool-II 4.3 RC1 is now released. Please take a look at [https://www.pgpool.net/docs/43/en/html/release-4-3rc1.html 4.3 RC1]
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+Note that this is not a stable version but just for developers.
-Release notes:
+V4.3 contains new features and enhancements, including:
-[https://www.pgpool.net/docs/42/en/html/release-4-2-0.html English]
+* A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.
-=== Pgpool-II 4.1 RC1 released (2019/10/16) ===
+* Allow to choose the least replication delay standby node when selecting the load balance node.
-Pgpool-II 4.1 RC1 is now released.
+* Allow to specify the node id to be promoted in pcp_promote_node.
-This is not intended to be used in production but is close to the release version. So users are encouraged to test it out.
+* Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.
-Major enhancements in Pgpool-II 4.1 include:
+* Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.
-* Statement level load balancing.
+* Allow pcp_node_info to list all backend nodes information.
-* Auto failback.
-* Enhance performance in number of areas.
-** Shared relation cache allows to reuse relation cache among sessions to reduce internal queries against PostgreSQL system catalogs.
-** Have separate SQL parser for DML statements to eliminate unnecessary parsing effort.
-** Load balancing control for specific queries.
-* Reduce Internal Queries against System Catalogs.
-* Import PostgreSQL 12 SQL parser.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.
-Release notes:
+* Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.
-[https://www.pgpool.net/docs/41/en/html/ English]
-=== Pgpool-II 4.1 beta1 released (2019/09/06) ===
+* Add support for log time stamp with milliseconds.
-Pgpool-II 4.1 beta1 is now released.
+* Import PostgreSQL 14's SQL parser.
-This is not a stable version but just for developers.
+* Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.
-Major enhancements in Pgpool-II 4.1 include:
+* pgpool.conf sample files are unified into single sample file for easier configuration.
-* Statement level load balancing.
+* All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.
-* Auto failback.
-* Enhance performance in number of areas.
-** Shared relation cache allows to reuse relation cache among sessions to reduce internal queries against PostgreSQL system catalogs.
-** Have separate SQL parser for DML statements to eliminate unnecessary parsing effort.
-** Load balancing control for specific queries.
-* Reduce Internal Queries against System Catalogs.
-* Import PostgreSQL 12 SQL parser.
-* etc.
 You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
 Release notes:
-[https://www.pgpool.net/docs/41/en/html/ English]
+[https://www.pgpool.net/docs/43/en/html/release-4-3-0.html English]
-=== Pgpool-II 4.0 RC1 released (2018/10/03) ===
+=== Pgpool-II 4.3 beta2 released (2021/11/18) ===
-Pgpool-II 4.0 RC1 is now released.
+Pgpool-II 4.3 beta2 is now released. Please take a look at [https://www.pgpool.net/docs/43/en/html/release-4-3beta2.html 4.3 beta2]
-This is not intended to be used in production but is close to the release version. So users are encouraged to test it out.
+Note that this is not a stable version but just for developers.
-V4.0 has new features:
-* Add SCRAM and Certificate authentication support.
-* Detecting "false" primary server of PostgreSQL.
-* Improvements to load balancing:
-** More load balancing fine control after write queries.
-** Load balancing control for specific queries.
-** Allow to specify load balance weight ratio for load balance parameters.
-* Add last state change timestamp to SHOW POOL NODES.
-* Import PostgreSQL 11 SQL parser.
-* Logging client messages.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-Release notes:
+V4.3 contains new features and enhancements, including:
-[https://www.pgpool.net/docs/pgpool-II-4.0/en/html/release-4-0.html English]
+* A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.
-=== Pgpool-II 4.0 beta1 released (2018/09/19) ===
+* Allow to choose the least replication delay standby node when selecting the load balance node.
-Pgpool-II 4.0 beta1 is now released.
+* Allow to specify the node id to be promoted in pcp_promote_node.
-This is not a stable version but just for developers.
+* Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.
-V4.0 has new features:
+* Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.
-* Add SCRAM and Certificate authentication support.
+* Allow pcp_node_info to list all backend nodes information.
-* Detecting "false" primary server of PostgreSQL.
-* Improvements to load balancing:
-** More load balancing fine control after write queries.
-** Load balancing control for specific queries.
-** Allow to specify load balance weight ratio for load balance parameters.
-* Add last state change timestamp to SHOW POOL NODES.
-* Import PostgreSQL 11 SQL parser.
-* Logging client messages.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.
-Release notes:
+* Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.
-[https://www.pgpool.net/docs/pgpool-II-4.0/en/html/release-4-0.html English]
-=== Pgpool-II 4.0 alpha2 released (2018/09/06) ===
+* Add support for log time stamp with milliseconds.
-Pgpool-II 4.0 alpha2 is now released.
+* Import PostgreSQL 14's SQL parser.
-This is not a stable version but just for developers.
+* Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.
-V4.0 has new features:
+* pgpool.conf sample files are unified into single sample file for easier configuration.
-* Add SCRAM and Certificate authentication support.
+* All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.
-* Detecting "false" primary server of PostgreSQL.
-* Improvements to load balancing:
-** More load balancing fine control after write queries.
-** Load balancing control for specific queries.
-** Allow to specify load balance weight ratio for load balance parameters.
-* Add last state change timestamp to SHOW POOL NODES.
-* Import PostgreSQL 11 SQL parser.
-* Logging client messages.
-* etc.
 You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
 Release notes:
-[https://www.pgpool.net/docs/pgpool-II-4.0/en/html/release-4-0.html English]
+[https://www.pgpool.net/docs/43/en/html/release-4-3-0.html English]
-=== Pgpool-II 4.0 alpha1 released (2018/08/20) ===
+=== Pgpool-II 4.3 beta1 released (2021/11/09) ===
-Pgpool-II 4.0 alpha1 is now released.
+Pgpool-II 4.3 beta1 is now released.
-This is not a stable version but just for developers.
+Note that this is not a stable version but just for developers.
-V4.0 has new features:
+V4.3 contains new features and enhancements, including:
+* A new membership mechanism is introduced to Watchdog to allow to keep quorum/VIP when some of watchdog nodes are removed.
-* Add SCRAM and Certificate authentication support.
+* Allow to choose the least replication delay standby node when selecting the load balance node.
-* Detecting "false" primary server of PostgreSQL.
-* Improvements to load balancing:
-** More load balancing fine control after write queries.
-** Load balancing control for specific queries.
-** Allow to specify load balance weight ratio for load balance parameters.
-* Add last state change timestamp to SHOW POOL NODES.
-*Logging client messages.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Allow to specify the node id to be promoted in pcp_promote_node.
-Release notes:
+* Allow to configure to not trigger failover when PostgreSQL is shutdown by admin or killed by pg_terminate_backend.
-[https://www.pgpool.net/docs/pgpool-II-4.0/en/html/release-4-0.html English]
-=== Pgpool-II 3.7 RC1 and pgpoolAdmin 3.7 RC1 released (2017/11/13) ===
+* Add new fields to pcp_proc_info, SHOW POOL_PROCESSES and SHOW POOL_POOLS command to display more useful information to admin.
-Pgpool-II 3.7 RC1 and pgpoolAdmin 3.7 RC1 are now released.
+* Allow pcp_node_info to list all backend nodes information.
-This is not intended to be used in production but is close to the
+* Add new fields showing actual PostgreSQL status to SHOW POOL NODES command and friends.
-release version. So users are encouraged to test it out.
-V3.7 has new features:
+* Add a new parameter which represents the recovery source hostname to recovery_1st_stage_command and recovery_2nd_stage_command.
-* Quorum aware failover feature.
-* Allow specifying the hostnames in pool_hba.
-* Allow to specify per node health check parameters.
-* Support AWS Aurora.
-* Import PostgreSQL 10 SQL parser.
-* Support logical replication.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Add support for log time stamp with milliseconds.
-Release notes:
+* Import PostgreSQL 14's SQL parser.
-[https://www.pgpool.net/docs/pgpool-II-3.7.0/doc/en/html/release-3-7.html English] [https://www.pgpool.net/docs/pgpool-II-3.7.0/doc/ja/html/release-3-7.html Japanese]
-=== Pgpool-II 3.7 beta1 released (2017/10/17) ===
+* Support include directive in pgppol.conf file. You can have separate sub-config file to be included in pgpool.conf.
-Pgpool-II 3.7 beta1 is now released. This is not a stable version but just for developers.
+* pgpool.conf sample files are unified into single sample file for easier configuration.
-V3.7 has new features:
+* All configuration parameters in pgpool.conf sample file are commented out to clarify which parameter is needed to be changed.
-* Quorum aware failover feature.
-* Allow specifying the hostnames in pool_hba.
-* Allow to specify per node health check parameters.
-* Support AWS Aurora.
-* Import PostgreSQL 10 SQL parser.
-* Support logical replication.
-* etc.
 You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-=== pgpool-II 3.6 RC1 released (2016/11/16) ===
+Release notes:
+[https://www.pgpool.net/docs/43/en/html/release-4-3-0.html English]
-pgpool-II 3.6 RC1 is now released. This is not a stable version but just for developers.
+=== Pgpool-II 4.2 beta1 released (2020/10/27) ===
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+Pgpool-II 4.2 beta1 is now released.
-=== pgpool-II 3.6 beta2 released (2016/11/08) ===
+Note that this is not a stable version but just for developers.
-pgpool-II 3.6 beta2 is now released. This is not a stable version but just for developers.
+V4.2 contains new features and enhancements, including:
-Users are encouraged to take part in our beta test program. Please help us in testing and making pgpool-II 3.6 better!
+* Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Implement logging_collector for easier log management.
-=== pgpool-II 3.6 beta1 released (2016/11/02) ===
+* Implement log_disconnections to collect disconnection logs.
-pgpool-II 3.6 beta1 is now released. This is not a stable version but just for developers.
+* Implement pg_enc and pg_md5 to allow to register multiple passwords at once.
-Users are encouraged to take part in our beta test program. Please help us in testing and making pgpool-II 3.6 better!
+* Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* New PCP command pcp_reload_config is added.
-=== Pgpool-II 3.6 alpha1 released (2016/10/19) ===
+* Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.
-Pgpool-II 3.6 alpha1 is now released. This is not a stable version but just for developers.
+* Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.
-V3.6 has a new feature:
+* Support LDAP authentication between clients and Pgpool-II.
-* Improve the behavior of fail-over.
-* New PGPOOL SET command has been introduced.
-* Watchdog is significantly enhanced.
-* Handling of extended query protocol (e.g. used by Java applications) in streaming replication mode speeds up if many rows are returned in a result set.
-* Import parser of PostgreSQL 9.6.
-* In some cases pg_terminate_backend() now does not trigger a fail-over.
-* Change documentation format from raw HTML to SGML.
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
-=== pgpool-II 3.5 RC1 released (2016/1/14) ===
+* Import PostgreSQL 13's SQL parser.
-pgpool-II 3.5 RC1 and pgpoolAdmin 3.5 RC1 are now relased. This is not a stable version but just for developers.
 You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-=== pgpool-II 3.5 beta1 released (2015/12/14) ===
+Release notes:
+[https://www.pgpool.net/docs/42/en/html/release-4-2-0.html English]
-pgpool-II 3.5 beta1 and pgpoolAdmin 3.5 beta1 are now released. This is not a stable version but just for developers.
+=== Pgpool-II 4.2 alpha1 released (2020/10/06) ===
-Users are encouraged to take part in our beta test program. Please help us in testing and making pgpool-II 3.5 better!
+Pgpool-II 4.2 alpha1 is now released.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+Note that this is not a stable version but just for developers.
-=== pgpool-II 3.5 alpha1 released (2015/11/16) ===
+V4.2 contains new features and enhancements, including:
-Pgpool-II 3.5 alpha1 is now released. This is not a stable version but just for developers.
+* Some items in the configuration file pgpool.conf are vastly enhanced for easier configuration and administration.
-V3.5 has a new feature:
+* Implement logging_collector for easier log management.
-* Improved performance in extended query protocol
-* Overcoming the thundering herd problem
-* watchdog feature enhancements to be more robust and adaptable
-* PCP command enhancements
-* Import PostgreSQL 9.5 parser
-* etc.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Implement log_disconnections to collect disconnection logs.
-=== pgpool-II 3.3 RC1 released (2013/07/25) ===
+* Implement pg_enc and pg_md5 to allow to register multiple passwords at once.
-Pgpool-II 3.3 RC1 is now released. This is not a stable version but just for developers.
+* Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* New PCP command pcp_reload_config is added.
-=== pgpool-II 3.3 beta1 released (2013/06/12) ===
+* Now it is possible to omit write_function_list and read_only_function_list by looking at system catalog information.
-Pgpool-II 3.3 beta1 is now relased. This is not a stable version but just for developers.
+* Add new clustering mode snapshot_isolation_mode which guarantees not only data modifications to multiple PostgreSQL but read consistency.
-Users are encouraged to take part in our beta test program. Please help us in testing and making pgpool-II 3.3 better!
+* Support LDAP authentication between clients and Pgpool-II.
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
+* Add ssl_crl_file and ssl_passphrase_command to SSL configuration.
-=== pgpool-II 3.3 alpha1 released (2013/05/17) ===
+* Import PostgreSQL 13's SQL parser.
-Pgpool-II 3.3 alpha1 is now released. This is not a stable version but just for developers.
+You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
-V3.3 has a new feature:
+Release notes:
-* Enhancements for watchdog
+[https://www.pgpool.net/docs/42/en/html/release-4-2-0.html English]
-** New monitoring method of watchdog lifecheck using heartbeat signal
-** Interlocking of failover/failback script
-** Secure watchdog communication
-** etc.
-* Othres
-** Import PostgreSQL 9.2 raw parser
-** New pgpool_setup tool
-** Support for using CREATE EXTENSION to install pgpool specific extensions
-You can download it from [https://pgpool.net/mediawiki/index.php/Developer_releases here].
 == Old ==
 See [[Old news|this page]].
-= Where can I get commercial support for pgpool-II? =
+= Where can I get commercial support for Pgpool-II? =
-Some commercial packages include pgpool-II support. Consulting and annual support can be purchased from SRA OSS, Inc. Japan (https://www.sraoss.co.jp/index_en.php).
+Some commercial packages include Pgpool-II support. Consulting and annual support can be purchased from SRA OSS LLC (https://www.sraoss.co.jp/index_en.php).

Difference between revisions of "Main Page"

Latest revision as of 01:19, 28 February 2025

Contents

Welcome to Pgpool Wiki!

What is Pgpool-II?

Pgpool-II License

Stable versions

Contacts

What's new

News

Pgpool-II 4.6.0 officially released (2025/02/28)

Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released (2025/02/28)

Events

PGConf.ASIA 2019 in Bali

PGConf.ASIA 2018 in Tokyo

PGConf.ASIA 2017 in Tokyo

PostgreSQL Conference in Russia 2016

PostgreSQL Conference in China 2015

pgCon 2015 Cluster Hacker Summit

Pgpool-II Day 2015 in Tokyo

Stable

Pgpool-II 4.6.0 officially released (2025/02/28)

Pgpool-II 4.5.6, 4.4.11, 4.3.14 and 4.2.21 officially released (2025/02/28)

Pgpool-II 4.5.5, 4.4.10, 4.3.13, 4.2.20 and 4.1.23 officially released (2024/11/28)

Pgpool-II 4.5.4, 4.4.9, 4.3.12, 4.2.19 and 4.1.22 officially released (2024/09/09)

Pgpool-II 4.5.3, 4.4.8, 4.3.11, 4.2.18 and 4.1.21 officially released (2024/08/15)

Pgpool-II 4.5.2, 4.4.7, 4.3.10, 4.2.17 and 4.1.20 officially released (2024/05/16)

Pgpool-II 4.5.1, 4.4.6, 4.3.9, 4.2.16 and 4.1.19 officially released (2024/02/29)

Pgpool-II 4.5.0 released (2023/12/12)

Pgpool-II 4.4.5, 4.3.8, 4.2.15, 4.1.18 and 4.0.25 officially released (2023/11/30)

Pgpool-II 4.4.4, 4.3.7, 4.2.14, 4.1.17 and 4.0.24 officially released (2023/08/17)

Pgpool-II 4.4.3, 4.3.6, 4.2.13, 4.1.16 and 4.0.23 officially released (2023/05/18)

End-of-Life (EOL) Announcement for pgpoolAdmin (2023/02/17)

Pgpool-II 4.4.2, 4.3.5, 4.2.12, 4.1.15 and 4.0.22 officially released (2023/01/23)

Pgpool-II 4.4.1, 4.3.4, 4.2.11, 4.1.14, 4.0.21 and 3.7.26 officially released (2022/12/22)

Pgpool-II 4.4.0 released (2022/12/06)

Pgpool-II 4.3.3, 4.2.10, 4.1.13, 4.0.20 and 3.7.25 officially released (2022/08/18)

Pgpool-II 4.3.2, 4.2.9, 4.1.12, 4.0.19 and 3.7.24 officially released (2022/05/19)

Pgpool-II 4.3.1, 4.2.8, 4.1.11, 4.0.18 and 3.7.23 officially released (2022/02/17)

Pgpool-II 4.2.7, 4.1.10, 4.0.17 and 3.7.22 officially released (2021/12/23)

Pgpool-II 4.3.0 released (2021/12/07)

Pgpool-II 4.2.6, 4.1.9, 4.0.16, 3.7.21 and 3.6.28 officially released (2021/11/18)

Pgpool-II 4.2.5 released (2021/09/14)

Pgpool-II 4.2.4, 4.1.8, 4.0.15, 3.7.20 and 3.6.27 officially released (2021/08/05)

pgpoolAdmin 4.2.0 officially released (2021/06/17)

Pgpool-II 4.2.3, 4.1.7, 4.0.14, 3.7.19 and 3.6.26 officially released (2021/05/20)

Pgpool-II 4.2.2, 4.1.6, 4.0.13, 3.7.18 and 3.6.25 officially released (2021/02/18)

Pgpool-II 4.2.1 released (2020/12/23)

Pgpool-II 4.2.0 released (2020/11/26)

Development

Pgpool-II 4.6 RC1 released (2025/02/20)

Pgpool-II 4.6 beta1 released (2025/02/13)

Pgpool-II 4.5 RC1 released (2023/11/28)

Pgpool-II 4.5 beta1 released (2023/11/14)

Pgpool-II 4.4 RC1 released (2022/11/22)

Pgpool-II 4.4 beta1 released (2022/11/14)

Pgpool-II 4.3 RC1 released (2021/11/25)

Pgpool-II 4.3 beta2 released (2021/11/18)

Pgpool-II 4.3 beta1 released (2021/11/09)

Pgpool-II 4.2 beta1 released (2020/10/27)

Pgpool-II 4.2 alpha1 released (2020/10/06)

Old

Where can I get commercial support for Pgpool-II?

Navigation menu

Search