![[BACK]](/icons/back.gif){kind=icon}
Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql93-docs
Request diff between arbitrary revisions
Default branch: MAIN
Current tag: pkgsrc-2014Q1-base
Revision 1.5 / (download) - annotate - [select for diffs], Thu Mar 27 20:57:55 2014 UTC (10 years ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2014Q2-base,
pkgsrc-2014Q2,
pkgsrc-2014Q1-base,
pkgsrc-2014Q1
Changes since 1.4: +6 -1
lines
Diff to previous 1.4 (colored)
This minor release fixes a data corruption issue with replication and crash recovery in version 9.3, as well as several other minor issues in all versions. All users of version 9.3 are urged to update their installations at the next possible downtime. Users of older versions should update at their convenience. 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 unrecoverable index corruption during recovery due to incorrect replay of row locking operations. 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 replace each of their standby databases with a new base backup after applying the update. Other PostgreSQL 9.3-only fixes in this update include: Make sure that statistics files for dropped databases get deleted Allow materialized views to be referenced in UPDATE and DELETE queries Add read-only data_checksum parameter Prevent erroneous operator push-down in postgres_fdw This release resolves some other issues in all versions of PostgreSQL, including: Fix timing consistency issue with NOTIFY Allow regular expression execution to be cancelled Improve performance of index checks for newly added rows Prevent premature walsender disconnection Prevent memory errors on newer Windows versions Update timezone files