Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2013-12-10 23:32:57
Message id: 20131210223257.D3AEC96@cvs.netbsd.org

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.

Files:
RevisionActionfile
1.29modifypkgsrc/databases/postgresql84/Makefile.common
1.27modifypkgsrc/databases/postgresql84/distinfo
1.21modifypkgsrc/databases/postgresql84-client/PLIST
1.27modifypkgsrc/databases/postgresql90/Makefile.common
1.19modifypkgsrc/databases/postgresql90/distinfo
1.11modifypkgsrc/databases/postgresql90-datatypes/Makefile
1.6modifypkgsrc/databases/postgresql90-datatypes/PLIST
1.17modifypkgsrc/databases/postgresql90-docs/PLIST
1.18modifypkgsrc/databases/postgresql90-server/Makefile
1.17modifypkgsrc/databases/postgresql91/Makefile.common
1.16modifypkgsrc/databases/postgresql91/distinfo
1.4modifypkgsrc/databases/postgresql91-datatypes/DESCR
1.8modifypkgsrc/databases/postgresql91-datatypes/Makefile
1.2modifypkgsrc/databases/postgresql91-datatypes/PLIST
1.13modifypkgsrc/databases/postgresql91-docs/PLIST
1.8modifypkgsrc/databases/postgresql92/Makefile.common
1.6modifypkgsrc/databases/postgresql92/distinfo
1.4modifypkgsrc/databases/postgresql92-datatypes/DESCR
1.5modifypkgsrc/databases/postgresql92-datatypes/Makefile
1.2modifypkgsrc/databases/postgresql92-datatypes/PLIST
1.6modifypkgsrc/databases/postgresql92-docs/PLIST
1.7modifypkgsrc/databases/postgresql92-server/Makefile
1.4modifypkgsrc/databases/postgresql93/Makefile.common
1.5modifypkgsrc/databases/postgresql93/distinfo
1.2modifypkgsrc/databases/postgresql93-datatypes/DESCR
1.2modifypkgsrc/databases/postgresql93-datatypes/Makefile
1.3modifypkgsrc/databases/postgresql93-datatypes/PLIST
1.3modifypkgsrc/databases/postgresql93-docs/PLIST
1.2modifypkgsrc/databases/postgresql93-server/Makefile
1.1addpkgsrc/databases/postgresql84/patches/patch-src_pl_plpython_Makefile
1.1addpkgsrc/databases/postgresql90/patches/patch-src_pl_plpython_Makefile
1.1addpkgsrc/databases/postgresql91/patches/patch-src_pl_plpython_Makefile
1.1addpkgsrc/databases/postgresql92/patches/patch-src_pl_plpython_Makefile