This article was originally published on October 06, 2021
WHAT’S NEW
This update is notifying you of the new release of EDB Pgpool-II 4.2.5. Pgpool-II acts as a middleman between client applications and a PostgreSQL database server. Using Pgpool-II can add the following benefits to your application connection infrastructure:
- Reroute and load balance Read-Only transactions to Standby database servers
- Reuse connections to prevent reconnects
- Reduce Postgres connections by queuing stale connections
EDB Pgpool-II is enhanced to support extra EDB Postgres Advanced capabilities and can be used with PostgreSQL or EDB Postgres Advanced.
Highlights of this release
This release contains a merge with upstream, which includes the following bug fixes:
|
Highlights |
Type |
|
Fixed maximum length of hostnames, including domain name. Now the correct value is 256 instead of 128. |
Bug Fix |
|
Fixed query cache so that it does not cache SQLValueFunctions. |
Bug Fix |
|
Implemented follow_primary command-locking over the watchdog channel. This is a supplementary fix for a race condition between detach_false_primary and follow_primary_command. |
Bug Fix |
|
Fixed the issue wherein the client-side hangs when a NoData response follows a Describe statement. |
Bug Fix |
|
Fixed an issue that sent an incorrect length error query (to abort transactions running on the non-main nodes), throwing an “invalid string in message” error at the backend in SI mode. |
|
|
Fixed an issue wherein child processes created by follow_primary command were orphaned when pgpool was shut down. |
Bug Fix |
|
Fixed an issue wherein, after executing the follow_primary command, the status of a standby node was set as down using the pcp_detach_node. |
Bug Fix |
|
Fixed an issue wherein the backend application name was not updated even though the pgpool configuration file was reloaded. |
Bug Fix |
|
Fixed the watchdog communication race condition wherein the watchdog notified the new message to the main process, which took significant time to process the message. |
Bug Fix |
|
Fixed an issue wherein the watchdog node status was not updating after rebooting one of the cluster nodes. |
Bug Fix |
|
Fixed an issue wherein the follow_primary_command failed when watchdog was enabled. |
Bug Fix |
|
Fixed a bug related to PGPOOL SHOW heartbeat and PGPOOL SHOW ALL commands where the last entry of command result was not shown. |
Bug Fix |
|
Fixed an issue to allow the value of the parameter log_rotation_age to be set to 0 to disable it. |
Bug Fix |
|
Fixed an incorrect display of the load balancing node status in raw clustering mode. |
Bug Fix |
|
Fixed the pgpool logger process, which was utilizing 100% CPU. |
Bug Fix |
|
Fixed the SI mode to acquire a snapshot with an internal transaction. |
Bug Fix |
|
Fixed the backend_flag* parameter, which was shown twice while executing the PGPOOL SHOW ALL command. |
Bug Fix |
|
Updated the other_pgpool parameter (removed in the 4.2 release) to watchdog in the SHOW ALL command. |
Bug Fix |
For more information, please refer to the Upstream 4.2.4 and 4.2.5 release notes.
TELL ME MORE
For more details, please review the EDB Pgpool-II 4.2.5 documentation:
https://www.enterprisedb.com/docs/pgpool/latest/
IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Pgpool-II 4.2.5 and have a subscription purchased for:
- Standard Subscription
- Enterprise Subscription
HOW TO GET THE SOFTWARE
EDB Pgpool-II 4.2 is available from the EDB website https://www.enterprisedb.com/downloads/pgpool.
To request the credentials required to access EDB repositories, please visit https://www.enterprisedb.com/repository-access-request
TROUBLESHOOTING
If you experience any problems around the installation, migration, upgrade or general use of your EDB software please contact our Technical Support teams.
We can be reached at https://support.enterprisedb.com, and we are also available 24 x 7 via email or phone at the details below:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612