Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2012-12-07 22:19:51
Message id: 20121207211951.8F508175DD@cvs.netbsd.org

Log Message:
This release fixes a significant page ordering issue with Hot Standby which \ 
could cause index corruption on the standby under some circumstances. In \ 
addition, this update patches timing issues with checkpoint and transaction ID \ 
wraparound which could cause data corruption in some cases. Today's update also \ 
fixes multiple issues with CREATE INDEX CONCURRENTLY and DROP INDEX \ 
CONCURRENTLY, which can cause those commands to fail or produce corrupt indexes. \ 
Users who use this feature may want to REINDEX or recreate affected indexes (see \ 
below).

This update release also contains fixes for many minor issues discovered and \ 
patched by the PostgreSQL community in the last month, including several fixes \ 
which are specific to version 9.2. These include:

* Prevent psql crash due to incorrectly encoded input data
* Fix pg_regress gmake build issues
* Make sure correct directory is created for extensions
* Fix some issues with buffer locks and VACUUM
* Multiple fixes and improvements for pg_upgrade
* Fix bugs with end-of-recovery when failing over to a standby
* Avoid bogus "out-of-sequence timeline ID" errors in standby-mode
* Don't launch new child processes during shutdown
* Improve the ability of JOINs to use partial indexes
* Fix assorted integer overflow errors
* Eliminate memory leaks in record_out() and record_send()
* Skip searching for subtransaction logs at COMMIT
* Fix WaitLatch() timing issues
* Fix handling of inherited check constraints in ALTER COLUMN TYPE
* Make ALTER EXTENSION SET SCHEMA behave as documented
* Have SEQUENCE SET statements in the "data" section of sectional dumps
* Prevent parser from believing that VIEWs have system columns
* Fix --clean mode for pg_dump
* Prevent hash table corruption on out-of-memory
* Various query planner and executor fixes and improvements
* Multiple documentation updates
* DST updates for seven timezones

Files:
RevisionActionfile
1.28modifypkgsrc/databases/postgresql83/Makefile.common
1.27modifypkgsrc/databases/postgresql83/distinfo
1.24modifypkgsrc/databases/postgresql83-client/PLIST
1.24modifypkgsrc/databases/postgresql84/Makefile.common
1.23modifypkgsrc/databases/postgresql84/distinfo
1.17modifypkgsrc/databases/postgresql84-client/PLIST
1.22modifypkgsrc/databases/postgresql90/Makefile.common
1.15modifypkgsrc/databases/postgresql90/distinfo
1.13modifypkgsrc/databases/postgresql90-docs/PLIST
1.12modifypkgsrc/databases/postgresql91/Makefile.common
1.12modifypkgsrc/databases/postgresql91/distinfo
1.9modifypkgsrc/databases/postgresql91-docs/PLIST
1.3modifypkgsrc/databases/postgresql92/Makefile.common
1.2modifypkgsrc/databases/postgresql92/distinfo
1.2modifypkgsrc/databases/postgresql92-client/PLIST
1.2modifypkgsrc/databases/postgresql92-docs/PLIST
1.2modifypkgsrc/databases/postgresql92-plpython/PLIST