The PostgreSQL Global Development Group has released an update to all current versions of the PostgreSQL database system, including 9.2.1, 9.1.6, 9.0.10, 8.4.14 and 8.3.21. This update fixes critical issues for major versions 9.1 and 9.2, and users running those versions should apply it as soon as possible. Users of versions 8.3, 8.4 and 9.0 should plan to update at the next scheduled downtime.

The update fixes two potential data corruption issues present in the PostgreSQL 9.1 and 9.2 for any server which has crashed, been shutdown with "immediate", or was failed over to a standby. First, the PostgreSQL development team has discovered a chance of corruption of BTREE and GIN indexes for databases. Second, there is a significant chance of corruption of the visibility map. This update fixes both issues.

We strongly advise users of 9.1 and 9.2 to run VACUUM and/or index rebuilds after applying the update. Please see the 2012-09-24 Update wiki page for detailed instructions.

This update release also contains fixes for many minor issues discovered and patched by the PostgreSQL community in the last month, including many fixes for the newly released version 9.2. These include:

fix sorting issue with IN lists and indexes
fix planner failure when combining GROUP BY with window functions
improve selectivity of text searches using prefixes
prevent rescanning of WITH clauses from giving wrong answers
fix PL/Perl crashing issue
reduce bloat for multi-column GiST indexes
time zone data changes for Fiji
disallow Extensions from circular schema assignment
prevent crashes when default_transaction_isolation is set to "serializable"
several minor fixes to pg_upgrade

15 files changed, 36 insertions, 33 deletions

diff --git a/databases/postgresql83-plperl/Makefile b/databases/postgresql83-plperl/Makefile
index cbd99128efc..f68832d4af2 100644
--- a/databases/postgresql83-plperl/Makefile
+++ b/databases/postgresql83-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2012/10/03 21:54:25 wiz Exp $
+# $NetBSD: Makefile,v 1.19 2012/10/05 22:15:35 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/83-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql83-server>=${PKGVERSION_NOREV}:../../databases/postgresql83-server
diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index 8c12733a401..0e61e61706d 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.15 2012/08/23 16:56:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.16 2012/10/05 22:15:36 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1336,6 +1336,7 @@ share/doc/postgresql/html/release-8-3-18.html
 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-3.html
 share/doc/postgresql/html/release-8-3-4.html
 share/doc/postgresql/html/release-8-3-5.html
@@ -1349,6 +1350,7 @@ share/doc/postgresql/html/release-8-4-10.html
 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-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-plperl/Makefile b/databases/postgresql84-plperl/Makefile
index b642fd54e5d..8f4743d3e33 100644
--- a/databases/postgresql84-plperl/Makefile
+++ b/databases/postgresql84-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2012/10/03 21:54:25 wiz Exp $
+# $NetBSD: Makefile,v 1.15 2012/10/05 22:15:36 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-plperl-/}
-PKGREVISION=	2
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql84-server>=${PKGVERSION_NOREV}:../../databases/postgresql84-server
diff --git a/databases/postgresql84-plpython/Makefile b/databases/postgresql84-plpython/Makefile
index e620226c7ce..9a21c6373b6 100644
--- a/databases/postgresql84-plpython/Makefile
+++ b/databases/postgresql84-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2012/10/02 21:25:43 asau Exp $
+# $NetBSD: Makefile,v 1.12 2012/10/05 22:15:36 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-plpython-/}
-PKGREVISION=	1
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql84-server>=${PKGVERSION_NOREV}:../../databases/postgresql84-server
diff --git a/databases/postgresql84-pltcl/Makefile b/databases/postgresql84-pltcl/Makefile
index 8bb76c57dc6..67c27fdfd17 100644
--- a/databases/postgresql84-pltcl/Makefile
+++ b/databases/postgresql84-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2012/10/02 21:25:43 asau Exp $
+# $NetBSD: Makefile,v 1.10 2012/10/05 22:15:36 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql84-server>=${PKGVERSION_NOREV}:../../databases/postgresql84-server
diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index c9f35d9b2b0..8123868810a 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.21 2012/08/23 16:56:38 adam Exp $
+# $NetBSD: Makefile.common,v 1.22 2012/10/05 22:15:35 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.13
+DISTNAME=	postgresql-8.4.14
 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 6838bace2f8..feae6c64d53 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.21 2012/08/23 16:56:38 adam Exp $
+$NetBSD: distinfo,v 1.22 2012/10/05 22:15:35 adam Exp $
 
-SHA1 (postgresql-8.4.13.tar.bz2) = 3134d622a23a2b157d56d6c4c4547e133569d524
-RMD160 (postgresql-8.4.13.tar.bz2) = cd2bd8a0e24a0bda487afcecf4071b6a9f232b99
-Size (postgresql-8.4.13.tar.bz2) = 14666613 bytes
+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 (patch-aa) = 72437773d67939c8d8c8e9a99caf430590fd726f
 SHA1 (patch-ab) = aa46d88c8a72edaf95880de48474ea484d6d2bf5
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb
diff --git a/databases/postgresql90-docs/PLIST b/databases/postgresql90-docs/PLIST
index 2f9aba8ba81..30f79e95fad 100644
--- a/databases/postgresql90-docs/PLIST
+++ b/databases/postgresql90-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2012/08/23 16:42:39 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2012/10/05 22:15:36 adam Exp $
 ${PG_SUBPREFIX}man/man1/clusterdb.1
 ${PG_SUBPREFIX}man/man1/createdb.1
 ${PG_SUBPREFIX}man/man1/createlang.1
@@ -906,6 +906,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-18.html
 ${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-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-5.html
@@ -919,6 +920,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-10.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-4.html
@@ -929,6 +931,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-8.html
 ${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-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-plperl/Makefile b/databases/postgresql90-plperl/Makefile
index 0838d679cb3..4690b8beae7 100644
--- a/databases/postgresql90-plperl/Makefile
+++ b/databases/postgresql90-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2012/10/03 21:54:25 wiz Exp $
+# $NetBSD: Makefile,v 1.11 2012/10/05 22:15:36 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql90-server>=${PKGVERSION_NOREV}:../../databases/postgresql90-server
diff --git a/databases/postgresql90/Makefile.common b/databases/postgresql90/Makefile.common
index 683ef0bebf8..f8f1570d931 100644
--- a/databases/postgresql90/Makefile.common
+++ b/databases/postgresql90/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.19 2012/08/23 16:42:39 adam Exp $
+# $NetBSD: Makefile.common,v 1.20 2012/10/05 22:15:36 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.9
+DISTNAME=	postgresql-9.0.10
 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 f1db5d839f5..9b6e9a0edb3 100644
--- a/databases/postgresql90/distinfo
+++ b/databases/postgresql90/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.13 2012/08/23 16:42:39 adam Exp $
+$NetBSD: distinfo,v 1.14 2012/10/05 22:15:36 adam Exp $
 
-SHA1 (postgresql-9.0.9.tar.bz2) = ff9907d0941578f15a6eda52a60982d9ecafbcf1
-RMD160 (postgresql-9.0.9.tar.bz2) = 03cd901956c09e50e3d91f69962301d31e361391
-Size (postgresql-9.0.9.tar.bz2) = 15008401 bytes
+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 (patch-aa) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-ab) = 6adfc53e325abe69582f1c7971f56144c697e9c1
 SHA1 (patch-ac) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5
diff --git a/databases/postgresql91-docs/PLIST b/databases/postgresql91-docs/PLIST
index ffe8adc24fa..49ccf97e21d 100644
--- a/databases/postgresql91-docs/PLIST
+++ b/databases/postgresql91-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2012/08/23 16:30:34 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2012/10/05 22:15:37 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -952,6 +952,7 @@ share/doc/postgresql/html/release-8-3-18.html
 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-3.html
 share/doc/postgresql/html/release-8-3-4.html
 share/doc/postgresql/html/release-8-3-5.html
@@ -965,6 +966,7 @@ share/doc/postgresql/html/release-8-4-10.html
 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-2.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
@@ -975,6 +977,7 @@ share/doc/postgresql/html/release-8-4-8.html
 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-2.html
 share/doc/postgresql/html/release-9-0-3.html
 share/doc/postgresql/html/release-9-0-4.html
@@ -989,6 +992,7 @@ share/doc/postgresql/html/release-9-1-2.html
 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.html
 share/doc/postgresql/html/release.html
 share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql91-plperl/Makefile b/databases/postgresql91-plperl/Makefile
index 495854e925a..aa860c599aa 100644
--- a/databases/postgresql91-plperl/Makefile
+++ b/databases/postgresql91-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2012/10/03 21:54:26 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2012/10/05 22:15:37 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/91-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server
diff --git a/databases/postgresql91/Makefile.common b/databases/postgresql91/Makefile.common
index a46af1295b1..70587783c17 100644
--- a/databases/postgresql91/Makefile.common
+++ b/databases/postgresql91/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.9 2012/08/23 16:30:34 adam Exp $
+# $NetBSD: Makefile.common,v 1.10 2012/10/05 22:15:36 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.5
+DISTNAME=	postgresql-9.1.6
 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 fc77c521779..58b3c16af78 100644
--- a/databases/postgresql91/distinfo
+++ b/databases/postgresql91/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.8 2012/08/23 16:30:34 adam Exp $
+$NetBSD: distinfo,v 1.9 2012/10/05 22:15:36 adam Exp $
 
-SHA1 (postgresql-9.1.5.tar.bz2) = 8411f39e7cff8d691d908de7823b72426433faa2
-RMD160 (postgresql-9.1.5.tar.bz2) = c6f1e4da05d7c325acc1321f94da654a52fc2c1a
-Size (postgresql-9.1.5.tar.bz2) = 15602594 bytes
+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 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = dab79533dac06a79a5aa8439d6b15830d8d2fba7
 SHA1 (patch-contrib_dblink_Makefile) = 4960ad57d42465fae203870548e4c53f8a32ce04