The latest updates address several critical issues, particularly those related to unstable DNS lookups and backend failures in specific environments. Notably, the tool now implements a retry mechanism that attempts up to five times when the getaddrinfo() function encounters an EAI_AGAIN error. Additionally, health check calls have been improved by using connect_inet_domain_socket_by_port() with a retry flag set to false.
The updates also fix an issue that led to incorrect notice messages being printed when commands were sent to the IPC socket and address a resource leak within the pool_push_pending_data function. Furthermore, a malfunction in scram-sha-256 authentication on big-endian machines has been resolved, along with correcting a typographical error in the comments of the pgpool.conf file.
For users interested in the latest features and fixes, the Pgpool Global Development Group has made these versions available for download, including source code and RPM packages. Users are encouraged to review the release notes for detailed information on the enhancements and bug fixes implemented in these minor releases.
In summary, these updates to Pgpool-II not only enhance its stability and functionality but also reflect the continuous efforts of the development team to address user feedback and improve performance. As PostgreSQL continues to evolve, tools like Pgpool-II remain essential for database administrators looking to optimize their database environments
Pgpool-II 4.6.3, 4.5.8, 4.4.13, 4.3.16 and 4.2.23 released
Pgpool-II is a tool designed to enhance the capabilities of PostgreSQL, offering features such as connection pooling, load balancing, and automatic failover. The enhancements have been implemented to resolve issues related to unstable DNS lookups and backend failures in specific environments. The tool now attempts to retry up to five times in the event that getaddrinfo() encounters an EAI_AGAIN error. The health check calls connect_inet_domain_socket_by_port() with the retry flag configured to false. The tool addresses an issue that resulted in an inappropriate notice message being printed when commands were written to the IPC socket. Additional enhancements comprise a resolution for a resource leak in pool_push_pending_data, a correction for the malfunctioning scram-sha-256 authentication on big-endian machines, and an amendment for a typographical error in the comments of pgpool.conf.
Pgpool-II 4.6.3, 4.5.8, 4.4.13, 4.3.16 and 4.2.23 released @ Linux Compatible
