Er zijn updates verschenen van PostgreSQL uit de 9.4-, 9.3-, 9.2-, 9.1- en 9.0-serie. Dit populaire 'opensource relational database management system' draait op een groot aantal besturingssystemen en is daardoor uitstekend inzetbaar in diverse omgevingen. Het is een afgeleide van Ingres, nadat de hoofdontwikkelaar daarvan voor zichzelf is begonnen en deze database van opensource closedsource werd. De release notes voor deze bugfix-uitgave kunnen hieronder worden gevonden.
Data Corruption Fix
For users of PostgreSQL versions 9.3 or 9.4, this release fixes a problem where the database will fail to protect against "multixact wraparound", resulting in data corruption or loss. Users with a high transaction rate (1 million or more per hour) in a database with many foreign keys are especially vulnerable. We strongly urge all users of 9.4 and 9.3 to update their installations in the next few days.
Users of versions 9.2 and earlier are not affected by this issue.
This update fixes three security vulnerabilities reported in PostgreSQL over the past few months. None of these issues are seen as particularly urgent. However, users should examine them in case their installations are vulnerable:
Additionally, we are recommending that all users who use Kerberos, GSSAPI, or SSPI authentication set include_realm to 1 in pg_hba.conf, which will become the default in future versions.
- CVE-2015-3165 Double "free" after authentication timeout.
- CVE-2015-3166 Unanticipated errors from the standard library.
- CVE-2015-3167 pgcrypto has multiple error messages for decryption with an incorrect key.
More information about these issues, as well as older patched issues, is available on the PostgreSQL Security Page.
Other Fixes and Improvements
A new, non-default version of the citext extension fixes its previously undocumented regexp_matches() functions to align with the ordinary text version of those functions. The fixed version has a different return type than the old version, so users of CIText should test their applications before updating the function by running "ALTER EXTENSION citext UPDATE".
In addition to the above, more than 50 reported issues have been fixed in this cumulative update release. Most of the issues named affect all supported versions. These fixes include:
- Render infinite dates and timestamps as infinity when converting to json
- Fix json/jsonb's populate_record() and to_record()
- Fix incorrect checking of deferred exclusion constraints
- Improve planning of star-schema-style queries
- Fix three issues with planning joins
- Ensure correct locking with security barrier views
- Fix deadlock at startup when max_prepared_transactions is too small
- Recursively fsync() the data directory after a crash
- Fix autovacuum launcher's possible failure to shut down
- Cope with unexpected signals in LockBufferForCleanup()
- Fix crash when doing COPY IN to a table with check constraints
- Avoid waiting for synchronous replication of read-only transactions
- Fix two issues with hash indexes
- Prevent memory leaks in GIN index vacuum
- Fix two issues with background workers
- Several fixes to Logical Decoding replication
- Fix several minor issues with pg_dump and pg_upgrade