CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Oct  5 22:15:37 UTC 2012

Modified Files:
        pkgsrc/databases/postgresql83-plperl: Makefile
        pkgsrc/databases/postgresql84: Makefile.common distinfo
        pkgsrc/databases/postgresql84-client: PLIST
        pkgsrc/databases/postgresql84-plperl: Makefile
        pkgsrc/databases/postgresql84-plpython: Makefile
        pkgsrc/databases/postgresql84-pltcl: Makefile
        pkgsrc/databases/postgresql90: Makefile.common distinfo
        pkgsrc/databases/postgresql90-docs: PLIST
        pkgsrc/databases/postgresql90-plperl: Makefile
        pkgsrc/databases/postgresql91: Makefile.common distinfo
        pkgsrc/databases/postgresql91-docs: PLIST
        pkgsrc/databases/postgresql91-plperl: Makefile

Log Message:
The PostgreSQL Global Development Group has released an update to all current 
versions of the PostgreSQL database system, including 9.2.1, 9.1.6, 9.0.10, 
8.4.14 and 8.3.21. This update fixes critical issues for major versions 9.1 and 
9.2, and users running those versions should apply it as soon as possible. 
Users of versions 8.3, 8.4 and 9.0 should plan to update at the next scheduled 
downtime.

The update fixes two potential data corruption issues present in the PostgreSQL 
9.1 and 9.2 for any server which has crashed, been shutdown with "immediate", 
or was failed over to a standby. First, the PostgreSQL development team has 
discovered a chance of corruption of BTREE and GIN indexes for databases. 
Second, there is a significant chance of corruption of the visibility map. This 
update fixes both issues.

We strongly advise users of 9.1 and 9.2 to run VACUUM and/or index rebuilds 
after applying the update. Please see the 2012-09-24 Update wiki page for 
detailed instructions.

This update release also contains fixes for many minor issues discovered and 
patched by the PostgreSQL community in the last month, including many fixes for 
the newly released version 9.2. These include:

fix sorting issue with IN lists and indexes
fix planner failure when combining GROUP BY with window functions
improve selectivity of text searches using prefixes
prevent rescanning of WITH clauses from giving wrong answers
fix PL/Perl crashing issue
reduce bloat for multi-column GiST indexes
time zone data changes for Fiji
disallow Extensions from circular schema assignment
prevent crashes when default_transaction_isolation is set to "serializable"
several minor fixes to pg_upgrade


To generate a diff of this commit:
cvs rdiff -u -r1.18 -r1.19 pkgsrc/databases/postgresql83-plperl/Makefile
cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/postgresql84/Makefile.common \
    pkgsrc/databases/postgresql84/distinfo
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/postgresql84-client/PLIST
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql84-plperl/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql84-plpython/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql84-pltcl/Makefile
cvs rdiff -u -r1.19 -r1.20 pkgsrc/databases/postgresql90/Makefile.common
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql90/distinfo
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql90-docs/PLIST
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql90-plperl/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql91/Makefile.common
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/postgresql91/distinfo
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql91-docs/PLIST
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql91-plperl/Makefile

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