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

1 files changed, 11 insertions, 1 deletions

diff --git a/databases/postgresql92-client/PLIST b/databases/postgresql92-client/PLIST
index ce72ca3a167..aaa3f16794c 100644
--- a/databases/postgresql92-client/PLIST
+++ b/databases/postgresql92-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:10 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2012/12/07 21:19:50 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -568,8 +568,11 @@ share/locale/cs/LC_MESSAGES/ecpg-9.2.mo
 share/locale/cs/LC_MESSAGES/ecpglib6-9.2.mo
 share/locale/cs/LC_MESSAGES/initdb-9.2.mo
 share/locale/cs/LC_MESSAGES/libpq5-9.2.mo
+share/locale/cs/LC_MESSAGES/pg_basebackup-9.2.mo
 share/locale/cs/LC_MESSAGES/pg_config-9.2.mo
+share/locale/cs/LC_MESSAGES/pg_controldata-9.2.mo
 share/locale/cs/LC_MESSAGES/pg_ctl-9.2.mo
+share/locale/cs/LC_MESSAGES/pg_dump-9.2.mo
 share/locale/cs/LC_MESSAGES/pg_resetxlog-9.2.mo
 share/locale/cs/LC_MESSAGES/pgscripts-9.2.mo
 share/locale/cs/LC_MESSAGES/psql-9.2.mo
@@ -638,9 +641,11 @@ share/locale/pl/LC_MESSAGES/ecpg-9.2.mo
 share/locale/pl/LC_MESSAGES/ecpglib6-9.2.mo
 share/locale/pl/LC_MESSAGES/initdb-9.2.mo
 share/locale/pl/LC_MESSAGES/libpq5-9.2.mo
+share/locale/pl/LC_MESSAGES/pg_basebackup-9.2.mo
 share/locale/pl/LC_MESSAGES/pg_config-9.2.mo
 share/locale/pl/LC_MESSAGES/pg_controldata-9.2.mo
 share/locale/pl/LC_MESSAGES/pg_ctl-9.2.mo
+share/locale/pl/LC_MESSAGES/pg_dump-9.2.mo
 share/locale/pl/LC_MESSAGES/pg_resetxlog-9.2.mo
 share/locale/pl/LC_MESSAGES/pgscripts-9.2.mo
 share/locale/pl/LC_MESSAGES/psql-9.2.mo
@@ -648,9 +653,11 @@ share/locale/pt_BR/LC_MESSAGES/ecpg-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/ecpglib6-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/initdb-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/libpq5-9.2.mo
+share/locale/pt_BR/LC_MESSAGES/pg_basebackup-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/pg_config-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/pg_controldata-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/pg_ctl-9.2.mo
+share/locale/pt_BR/LC_MESSAGES/pg_dump-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/pgscripts-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/psql-9.2.mo
@@ -687,8 +694,11 @@ share/locale/zh_CN/LC_MESSAGES/ecpg-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/ecpglib6-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/initdb-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/libpq5-9.2.mo
+share/locale/zh_CN/LC_MESSAGES/pg_basebackup-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/pg_config-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.2.mo
+share/locale/zh_CN/LC_MESSAGES/pg_ctl-9.2.mo
+share/locale/zh_CN/LC_MESSAGES/pg_dump-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/pgscripts-9.2.mo
 share/locale/zh_CN/LC_MESSAGES/psql-9.2.mo