CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Dec 10 22:32:57 UTC 2013

Modified Files:
        pkgsrc/databases/postgresql84: Makefile.common distinfo
        pkgsrc/databases/postgresql84-client: PLIST
        pkgsrc/databases/postgresql90: Makefile.common distinfo
        pkgsrc/databases/postgresql90-datatypes: Makefile PLIST
        pkgsrc/databases/postgresql90-docs: PLIST
        pkgsrc/databases/postgresql90-server: Makefile
        pkgsrc/databases/postgresql91: Makefile.common distinfo
        pkgsrc/databases/postgresql91-datatypes: DESCR Makefile PLIST
        pkgsrc/databases/postgresql91-docs: PLIST
        pkgsrc/databases/postgresql92: Makefile.common distinfo
        pkgsrc/databases/postgresql92-datatypes: DESCR Makefile PLIST
        pkgsrc/databases/postgresql92-docs: PLIST
        pkgsrc/databases/postgresql92-server: Makefile
        pkgsrc/databases/postgresql93: Makefile.common distinfo
        pkgsrc/databases/postgresql93-datatypes: DESCR Makefile PLIST
        pkgsrc/databases/postgresql93-docs: PLIST
        pkgsrc/databases/postgresql93-server: Makefile
Added Files:
        pkgsrc/databases/postgresql84/patches: patch-src_pl_plpython_Makefile
        pkgsrc/databases/postgresql90/patches: patch-src_pl_plpython_Makefile
        pkgsrc/databases/postgresql91/patches: patch-src_pl_plpython_Makefile
        pkgsrc/databases/postgresql92/patches: patch-src_pl_plpython_Makefile

Log Message:
The PostgreSQL Global Development Group has released a critical update to all 
supported versions of the PostgreSQL database system, which includes minor 
versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This update fixes three 
serious data-loss bugs affecting replication and database maintenance. All 
users are urged to update their installations at the earliest opportunity.

The replication issue affects some users of PostgreSQL binary replication, and 
can cause minor data loss between the master and the standby. While not all 
users are affected, it is difficult to predict when the bug will occur, so we 
urge all users of replication and continuous backup (PITR) to update 
immediately. Additionally, users who had replication running under PostgreSQL 
minor versions 9.3.0, 9.3.1, 9.2.5, 9.1.10, or 9.0.14 should plan to take a 
fresh base backup of each standby after update, in order to ensure no prior 
data corruption already exists.

This release also fixes two timing issues with VACUUM, which can cause old, 
overwritten or deleted rows to re-appear at a later date under some 
circumstances. Users with very high transaction rates, particularly those who 
experience "transaction ID wraparound" every few weeks or less, are the most at 
risk for this issue. Those users should set vacuum_freeze_table_age to 0, and 
run a database-wide VACUUM after the update. The second of the two VACUUM 
issues affects only 9.3, making it expecially important for 9.3 users to update.


To generate a diff of this commit:
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/postgresql84/Makefile.common
cvs rdiff -u -r1.26 -r1.27 pkgsrc/databases/postgresql84/distinfo
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql84-client/PLIST
cvs rdiff -u -r0 -r1.1 \
    pkgsrc/databases/postgresql84/patches/patch-src_pl_plpython_Makefile
cvs rdiff -u -r1.26 -r1.27 pkgsrc/databases/postgresql90/Makefile.common
cvs rdiff -u -r1.18 -r1.19 pkgsrc/databases/postgresql90/distinfo
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql90-datatypes/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql90-datatypes/PLIST
cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/postgresql90-docs/PLIST
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql90-server/Makefile
cvs rdiff -u -r0 -r1.1 \
    pkgsrc/databases/postgresql90/patches/patch-src_pl_plpython_Makefile
cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/postgresql91/Makefile.common
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/postgresql91/distinfo
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql91-datatypes/DESCR
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql91-datatypes/Makefile
cvs rdiff -u -r1.1.1.1 -r1.2 pkgsrc/databases/postgresql91-datatypes/PLIST
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/postgresql91-docs/PLIST
cvs rdiff -u -r0 -r1.1 \
    pkgsrc/databases/postgresql91/patches/patch-src_pl_plpython_Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql92/Makefile.common
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql92/distinfo
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql92-datatypes/DESCR
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql92-datatypes/Makefile
cvs rdiff -u -r1.1 -r1.2 pkgsrc/databases/postgresql92-datatypes/PLIST
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql92-docs/PLIST
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql92-server/Makefile
cvs rdiff -u -r0 -r1.1 \
    pkgsrc/databases/postgresql92/patches/patch-src_pl_plpython_Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql93/Makefile.common
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql93/distinfo
cvs rdiff -u -r1.1 -r1.2 pkgsrc/databases/postgresql93-datatypes/DESCR \
    pkgsrc/databases/postgresql93-datatypes/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql93-datatypes/PLIST
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql93-docs/PLIST
cvs rdiff -u -r1.1 -r1.2 pkgsrc/databases/postgresql93-server/Makefile

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