... attached. Please correct! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
The PostgreSQL Global Development Group has released a critical update to version 9.3 of the database system. This minor release, PostgreSQL 9.3.4, fixes a data corruption issue with replication and crash recovery, as well as several other minor issues. All users of version 9.3 are urged to update their installations at the next opportunity.
The data corruption issue in PostgreSQL 9.3 affects binary replication standbys, servers being recovered from point-in-time-recovery backup, and standalone servers which recover from a system crash. The bug causes rows to vanish from indexes during recovery due to simultaneous updates of rows on both sides of a foreign key. This can then cause query results to be inconsistent depending on whether or not an index is used, and eventually lead to primary key violations and similar issues. For this reason, users are encouraged to take a new base backup of each of their standy databases after applying the update. This release resolves some other issues which affect PostgreSQL 9.3, including: * Make sure that statistics files for dropped databases get deleted * Fix timing consistency issue with NOTIFY * Allow materialized views to be referenced in UPDATE and DELETE queries * Allow regular expression execution to be cancelled * Remove ability to execute OVERLAPs with a single argument * Improve performance of index checks for newly added rows * Prevent premature walsender disconnection * Add read-only data_checksum parameter * Prevent memory errors on newer Windows versions * Prevent erroneous operator push-down in pgsql_fdw * Update timezone files Additional changes and details of some of the above issues can be found in the Release Notes. As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details. Links: * [Download](http://postgresql.org/download) * [Release Notes](http://www.postgresql.org/docs/current/static/release.html)
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
