CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Mar 27 20:57:55 UTC 2014

Modified Files:
        pkgsrc/databases/postgresql84: Makefile.common distinfo
        pkgsrc/databases/postgresql84-client: PLIST
        pkgsrc/databases/postgresql90: Makefile.common distinfo
        pkgsrc/databases/postgresql90-docs: PLIST
        pkgsrc/databases/postgresql91: Makefile.common distinfo
        pkgsrc/databases/postgresql91-docs: PLIST
        pkgsrc/databases/postgresql92: Makefile.common distinfo
        pkgsrc/databases/postgresql92-docs: PLIST
        pkgsrc/databases/postgresql93: Makefile.common distinfo
        pkgsrc/databases/postgresql93-docs: PLIST
        pkgsrc/databases/postgresql93-monitoring: Makefile

Log Message:
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


To generate a diff of this commit:
cvs rdiff -u -r1.31 -r1.32 pkgsrc/databases/postgresql84/Makefile.common
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/postgresql84/distinfo
cvs rdiff -u -r1.22 -r1.23 pkgsrc/databases/postgresql84-client/PLIST
cvs rdiff -u -r1.29 -r1.30 pkgsrc/databases/postgresql90/Makefile.common
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql90/distinfo
cvs rdiff -u -r1.18 -r1.19 pkgsrc/databases/postgresql90-docs/PLIST
cvs rdiff -u -r1.19 -r1.20 pkgsrc/databases/postgresql91/Makefile.common
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql91/distinfo
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql91-docs/PLIST
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql92/Makefile.common
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql92/distinfo
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql92-docs/PLIST
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql93/Makefile.common
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql93/distinfo
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql93-docs/PLIST
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql93-monitoring/Makefile

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.