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

17 files changed, 63 insertions, 37 deletions

diff --git a/databases/postgresql83-client/PLIST b/databases/postgresql83-client/PLIST
index 53e66c762c0..bf62715d383 100644
--- a/databases/postgresql83-client/PLIST
+++ b/databases/postgresql83-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.23 2012/10/05 22:28:47 adam Exp $
+@comment $NetBSD: PLIST,v 1.24 2012/12/07 21:19:51 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1306,6 +1306,7 @@ share/doc/postgresql/html/release-8-3-19.html
 share/doc/postgresql/html/release-8-3-2.html
 share/doc/postgresql/html/release-8-3-20.html
 share/doc/postgresql/html/release-8-3-21.html
+share/doc/postgresql/html/release-8-3-22.html
 share/doc/postgresql/html/release-8-3-3.html
 share/doc/postgresql/html/release-8-3-4.html
 share/doc/postgresql/html/release-8-3-5.html
diff --git a/databases/postgresql83/Makefile.common b/databases/postgresql83/Makefile.common
index 718f28828dd..cc780b5658a 100644
--- a/databases/postgresql83/Makefile.common
+++ b/databases/postgresql83/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.27 2012/10/21 13:52:15 cheusov Exp $
+# $NetBSD: Makefile.common,v 1.28 2012/12/07 21:19:51 adam Exp $
 #
 # used by databases/postgresql83-adminpack/Makefile
 # used by databases/postgresql83-client/Makefile
@@ -15,7 +15,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-8.3.21
+DISTNAME=	postgresql-8.3.22
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql83/distinfo b/databases/postgresql83/distinfo
index a7fe1122f91..aa3eee813a3 100644
--- a/databases/postgresql83/distinfo
+++ b/databases/postgresql83/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.26 2012/10/05 22:28:47 adam Exp $
+$NetBSD: distinfo,v 1.27 2012/12/07 21:19:51 adam Exp $
 
-SHA1 (postgresql-8.3.21.tar.bz2) = 5d068a897b914f42759aabd9683e800e7e27b218
-RMD160 (postgresql-8.3.21.tar.bz2) = c29cd507033043b214cb519f913d085f1573d03e
-Size (postgresql-8.3.21.tar.bz2) = 14626010 bytes
+SHA1 (postgresql-8.3.22.tar.bz2) = 43047b64a3977ad18aa6352bc3688585af570712
+RMD160 (postgresql-8.3.22.tar.bz2) = bf75a3ae29d5bcdb09493902dbc0e6144b87be77
+Size (postgresql-8.3.22.tar.bz2) = 14630723 bytes
 SHA1 (patch-aa) = 6d5e9aa58975181d189060f8523c022aa6c82277
 SHA1 (patch-ab) = 1ba1bb53ca5a74d09fc2b7d07d98b0a0ffd57202
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279
diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index 0e61e61706d..dda3ebca292 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.16 2012/10/05 22:15:36 adam Exp $
+@comment $NetBSD: PLIST,v 1.17 2012/12/07 21:19:51 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1337,6 +1337,7 @@ share/doc/postgresql/html/release-8-3-19.html
 share/doc/postgresql/html/release-8-3-2.html
 share/doc/postgresql/html/release-8-3-20.html
 share/doc/postgresql/html/release-8-3-21.html
+share/doc/postgresql/html/release-8-3-22.html
 share/doc/postgresql/html/release-8-3-3.html
 share/doc/postgresql/html/release-8-3-4.html
 share/doc/postgresql/html/release-8-3-5.html
@@ -1351,6 +1352,7 @@ share/doc/postgresql/html/release-8-4-11.html
 share/doc/postgresql/html/release-8-4-12.html
 share/doc/postgresql/html/release-8-4-13.html
 share/doc/postgresql/html/release-8-4-14.html
+share/doc/postgresql/html/release-8-4-15.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index 10336a6168a..9e18c70fd2d 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.23 2012/10/21 13:52:15 cheusov Exp $
+# $NetBSD: Makefile.common,v 1.24 2012/12/07 21:19:51 adam Exp $
 #
 # used by databases/postgresql84-adminpack/Makefile
 # used by databases/postgresql84-client/Makefile
@@ -17,7 +17,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-8.4.14
+DISTNAME=	postgresql-8.4.15
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql84/distinfo b/databases/postgresql84/distinfo
index feae6c64d53..e97a7851b94 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.22 2012/10/05 22:15:35 adam Exp $
+$NetBSD: distinfo,v 1.23 2012/12/07 21:19:51 adam Exp $
 
-SHA1 (postgresql-8.4.14.tar.bz2) = d82817a28c7b645e989b48e59d40a5045d37408a
-RMD160 (postgresql-8.4.14.tar.bz2) = 119c50a260a95a8c0798016e6615ffa084cc5a33
-Size (postgresql-8.4.14.tar.bz2) = 14679559 bytes
+SHA1 (postgresql-8.4.15.tar.bz2) = ba422537cd877153d251498fe8090ea5cfdafe72
+RMD160 (postgresql-8.4.15.tar.bz2) = 309bfc4bbb7af065de068006867b79e16189ecd2
+Size (postgresql-8.4.15.tar.bz2) = 14701182 bytes
 SHA1 (patch-aa) = 72437773d67939c8d8c8e9a99caf430590fd726f
 SHA1 (patch-ab) = aa46d88c8a72edaf95880de48474ea484d6d2bf5
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb
diff --git a/databases/postgresql90-docs/PLIST b/databases/postgresql90-docs/PLIST
index 30f79e95fad..3adc6d808ca 100644
--- a/databases/postgresql90-docs/PLIST
+++ b/databases/postgresql90-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.12 2012/10/05 22:15:36 adam Exp $
+@comment $NetBSD: PLIST,v 1.13 2012/12/07 21:19:50 adam Exp $
 ${PG_SUBPREFIX}man/man1/clusterdb.1
 ${PG_SUBPREFIX}man/man1/createdb.1
 ${PG_SUBPREFIX}man/man1/createlang.1
@@ -907,6 +907,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-21.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-22.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-5.html
@@ -921,6 +922,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-14.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-4.html
@@ -932,6 +934,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-9.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-10.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-4.html
diff --git a/databases/postgresql90/Makefile.common b/databases/postgresql90/Makefile.common
index 60296eaf41e..0cf419bc640 100644
--- a/databases/postgresql90/Makefile.common
+++ b/databases/postgresql90/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.21 2012/10/21 13:52:15 cheusov Exp $
+# $NetBSD: Makefile.common,v 1.22 2012/12/07 21:19:50 adam Exp $
 #
 # used by databases/postgresql90-adminpack/Makefile
 # used by databases/postgresql90-client/Makefile
@@ -21,7 +21,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-9.0.10
+DISTNAME=	postgresql-9.0.11
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql90/distinfo b/databases/postgresql90/distinfo
index 9b6e9a0edb3..7d40f6687a3 100644
--- a/databases/postgresql90/distinfo
+++ b/databases/postgresql90/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.14 2012/10/05 22:15:36 adam Exp $
+$NetBSD: distinfo,v 1.15 2012/12/07 21:19:50 adam Exp $
 
-SHA1 (postgresql-9.0.10.tar.bz2) = 316592e6fb1ab36e01543b8f926ded2bb7e34f01
-RMD160 (postgresql-9.0.10.tar.bz2) = a09abf74cde58417a69d4dea777d6af4680a096c
-Size (postgresql-9.0.10.tar.bz2) = 15015826 bytes
+SHA1 (postgresql-9.0.11.tar.bz2) = 44768193206cbf803cfa00ecd778abb967192452
+RMD160 (postgresql-9.0.11.tar.bz2) = 15f32dc908ceb8c6ad77849510f4a2ca92d193e1
+Size (postgresql-9.0.11.tar.bz2) = 15044657 bytes
 SHA1 (patch-aa) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-ab) = 6adfc53e325abe69582f1c7971f56144c697e9c1
 SHA1 (patch-ac) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5
diff --git a/databases/postgresql91-docs/PLIST b/databases/postgresql91-docs/PLIST
index 49ccf97e21d..febae6805d5 100644
--- a/databases/postgresql91-docs/PLIST
+++ b/databases/postgresql91-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2012/10/05 22:15:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.9 2012/12/07 21:19:50 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -953,6 +953,7 @@ share/doc/postgresql/html/release-8-3-19.html
 share/doc/postgresql/html/release-8-3-2.html
 share/doc/postgresql/html/release-8-3-20.html
 share/doc/postgresql/html/release-8-3-21.html
+share/doc/postgresql/html/release-8-3-22.html
 share/doc/postgresql/html/release-8-3-3.html
 share/doc/postgresql/html/release-8-3-4.html
 share/doc/postgresql/html/release-8-3-5.html
@@ -967,6 +968,7 @@ share/doc/postgresql/html/release-8-4-11.html
 share/doc/postgresql/html/release-8-4-12.html
 share/doc/postgresql/html/release-8-4-13.html
 share/doc/postgresql/html/release-8-4-14.html
+share/doc/postgresql/html/release-8-4-15.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
@@ -978,6 +980,7 @@ share/doc/postgresql/html/release-8-4-9.html
 share/doc/postgresql/html/release-8-4.html
 share/doc/postgresql/html/release-9-0-1.html
 share/doc/postgresql/html/release-9-0-10.html
+share/doc/postgresql/html/release-9-0-11.html
 share/doc/postgresql/html/release-9-0-2.html
 share/doc/postgresql/html/release-9-0-3.html
 share/doc/postgresql/html/release-9-0-4.html
@@ -993,6 +996,7 @@ share/doc/postgresql/html/release-9-1-3.html
 share/doc/postgresql/html/release-9-1-4.html
 share/doc/postgresql/html/release-9-1-5.html
 share/doc/postgresql/html/release-9-1-6.html
+share/doc/postgresql/html/release-9-1-7.html
 share/doc/postgresql/html/release-9-1.html
 share/doc/postgresql/html/release.html
 share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql91/Makefile.common b/databases/postgresql91/Makefile.common
index b3ac4ccb808..7d260565d78 100644
--- a/databases/postgresql91/Makefile.common
+++ b/databases/postgresql91/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.11 2012/10/21 13:52:15 cheusov Exp $
+# $NetBSD: Makefile.common,v 1.12 2012/12/07 21:19:50 adam Exp $
 #
 # used by databases/postgresql91-adminpack/Makefile
 # used by databases/postgresql91-client/Makefile
@@ -21,7 +21,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-9.1.6
+DISTNAME=	postgresql-9.1.7
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql91/distinfo b/databases/postgresql91/distinfo
index 49900c14f52..cf909f6651c 100644
--- a/databases/postgresql91/distinfo
+++ b/databases/postgresql91/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.11 2012/10/07 22:15:26 marino Exp $
+$NetBSD: distinfo,v 1.12 2012/12/07 21:19:50 adam Exp $
 
-SHA1 (postgresql-9.1.6.tar.bz2) = a24b7c002463572ee7371f055e566b69e39cda3e
-RMD160 (postgresql-9.1.6.tar.bz2) = 83ef4c516658c18c1e2937eee89b05a938aa8620
-Size (postgresql-9.1.6.tar.bz2) = 15621370 bytes
+SHA1 (postgresql-9.1.7.tar.bz2) = a1936b5ba69aa63aae1971459d3b5bb036fea428
+RMD160 (postgresql-9.1.7.tar.bz2) = c1a9ba97bcfc62075be89c40fe1b9ddf925dd652
+Size (postgresql-9.1.7.tar.bz2) = 15688516 bytes
 SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = dab79533dac06a79a5aa8439d6b15830d8d2fba7
 SHA1 (patch-contrib_dblink_Makefile) = 4960ad57d42465fae203870548e4c53f8a32ce04
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
diff --git a/databases/postgresql92-docs/PLIST b/databases/postgresql92-docs/PLIST
index 7dcc90ef284..2967b196c56 100644
--- a/databases/postgresql92-docs/PLIST
+++ b/databases/postgresql92-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2012/12/07 21:19:50 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -982,6 +982,7 @@ share/doc/postgresql/html/release-8-3-19.html
 share/doc/postgresql/html/release-8-3-2.html
 share/doc/postgresql/html/release-8-3-20.html
 share/doc/postgresql/html/release-8-3-21.html
+share/doc/postgresql/html/release-8-3-22.html
 share/doc/postgresql/html/release-8-3-3.html
 share/doc/postgresql/html/release-8-3-4.html
 share/doc/postgresql/html/release-8-3-5.html
@@ -996,6 +997,7 @@ share/doc/postgresql/html/release-8-4-11.html
 share/doc/postgresql/html/release-8-4-12.html
 share/doc/postgresql/html/release-8-4-13.html
 share/doc/postgresql/html/release-8-4-14.html
+share/doc/postgresql/html/release-8-4-15.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
@@ -1007,6 +1009,7 @@ share/doc/postgresql/html/release-8-4-9.html
 share/doc/postgresql/html/release-8-4.html
 share/doc/postgresql/html/release-9-0-1.html
 share/doc/postgresql/html/release-9-0-10.html
+share/doc/postgresql/html/release-9-0-11.html
 share/doc/postgresql/html/release-9-0-2.html
 share/doc/postgresql/html/release-9-0-3.html
 share/doc/postgresql/html/release-9-0-4.html
@@ -1022,8 +1025,10 @@ share/doc/postgresql/html/release-9-1-3.html
 share/doc/postgresql/html/release-9-1-4.html
 share/doc/postgresql/html/release-9-1-5.html
 share/doc/postgresql/html/release-9-1-6.html
+share/doc/postgresql/html/release-9-1-7.html
 share/doc/postgresql/html/release-9-1.html
 share/doc/postgresql/html/release-9-2-1.html
+share/doc/postgresql/html/release-9-2-2.html
 share/doc/postgresql/html/release-9-2.html
 share/doc/postgresql/html/release.html
 share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql92-plpython/PLIST b/databases/postgresql92-plpython/PLIST
index 5d9ae5e5518..66f570115f0 100644
--- a/databases/postgresql92-plpython/PLIST
+++ b/databases/postgresql92-plpython/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2012/12/07 21:19:50 adam Exp $
 lib/postgresql/plpython2.so
 share/locale/cs/LC_MESSAGES/plpython-9.2.mo
 share/locale/de/LC_MESSAGES/plpython-9.2.mo
@@ -9,6 +9,7 @@ share/locale/pl/LC_MESSAGES/plpython-9.2.mo
 share/locale/pt_BR/LC_MESSAGES/plpython-9.2.mo
 share/locale/ro/LC_MESSAGES/plpython-9.2.mo
 share/locale/ru/LC_MESSAGES/plpython-9.2.mo
+share/locale/zh_CN/LC_MESSAGES/plpython-9.2.mo
 share/postgresql/extension/plpython2u--1.0.sql
 share/postgresql/extension/plpython2u--unpackaged--1.0.sql
 share/postgresql/extension/plpython2u.control
diff --git a/databases/postgresql92/Makefile.common b/databases/postgresql92/Makefile.common
index 63ec70ae4ae..9ed2741adea 100644
--- a/databases/postgresql92/Makefile.common
+++ b/databases/postgresql92/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.2 2012/10/21 13:52:15 cheusov Exp $
+# $NetBSD: Makefile.common,v 1.3 2012/12/07 21:19:50 adam Exp $
 #
 # used by databases/postgresql92-adminpack/Makefile
 # used by databases/postgresql92-client/Makefile
@@ -21,7 +21,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-9.2.1
+DISTNAME=	postgresql-9.2.2
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql92/distinfo b/databases/postgresql92/distinfo
index 4e6168a4a9e..d8ce6791aa6 100644
--- a/databases/postgresql92/distinfo
+++ b/databases/postgresql92/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.1 2012/10/05 21:03:10 adam Exp $
+$NetBSD: distinfo,v 1.2 2012/12/07 21:19:50 adam Exp $
 
-SHA1 (postgresql-9.2.1.tar.bz2) = cea9601b3acd1484fd98441b49a15ea1c42057ec
-RMD160 (postgresql-9.2.1.tar.bz2) = 8d80ca9dbf142f8f3b08d1c3a4cb03dd238fd9b3
-Size (postgresql-9.2.1.tar.bz2) = 16113737 bytes
+SHA1 (postgresql-9.2.2.tar.bz2) = edadf238bcf51bd6e92dfe2f8afb3665510297a6
+RMD160 (postgresql-9.2.2.tar.bz2) = cf6fe7f0278933046b8aa76254fa270da56db67a
+Size (postgresql-9.2.2.tar.bz2) = 16222148 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = 21b27add570cff1a24c440201eb1ed49f8223747