Software Update: PostgreSQL 9.5.3 / 9.4.8 / 9.3.13 / 9.2.17 / 9.1.22

Updates have been released to PostgreSQL from the 9.5, 9.4, 9.3, 9.2, and 9.1 series. In addition, the first beta release of version 9.6 released. This popular ‘open source relational database management system’ runs on a large number of operating systems and can therefore be used in various environments. It is a derivative of Ingres, after its lead developer started his own business and this open source database became closed source. The release notes for this bugfix release can be found below.

This update fixes several problems which caused downtime for users, including:

• Clearing the OpenSSL error queue before OpenSSL calls, preventing errors in SSL connections, particularly when using the Python, Ruby or PHP OpenSSL wrappers
• Fixed the “failed to build N-way joins” planner error
• Fixed incorrect handling of equivalence in multilevel nestloop query plans, which could emit rows which didn’t match the WHERE clause.
• Prevented two memory leaks with using GIN indexes, including a potential index corruption risk.

The release also includes many other bug fixes for reported issues, many of which affect all supported versions:

• Fix corner-case parser failures occurring when operator_precedence_warning is turned on
• Prevent possible misbehavior of TH, th, and Y,YYY format codes in to_timestamp()
• Correct dumping of VIEWs and RULEs which use ANY (array) in a subselect
• Disallow newlines in ALTER SYSTEM parameter values
• Avoid possible misbehavior after failing to remove a tablespace symlink
• Fix crash in logical decoding on alignment-picky platforms
• Avoid repeated requests for feedback from receiver while shutting down walsender
• Multiple fixes for pg_upgrade
• Support building with Visual Studio 2015