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

3 files changed, 8 insertions, 7 deletions

diff --git a/databases/postgresql83-client/PLIST b/databases/postgresql83-client/PLIST
index 41d06682911..53e66c762c0 100644
--- a/databases/postgresql83-client/PLIST
+++ b/databases/postgresql83-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.22 2012/08/23 16:56:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.23 2012/10/05 22:28:47 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1305,6 +1305,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
diff --git a/databases/postgresql83/Makefile.common b/databases/postgresql83/Makefile.common
index 97da5935f7b..c49693e585b 100644
--- a/databases/postgresql83/Makefile.common
+++ b/databases/postgresql83/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.25 2012/08/23 16:56:38 adam Exp $
+# $NetBSD: Makefile.common,v 1.26 2012/10/05 22:28:47 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.20
+DISTNAME=	postgresql-8.3.21
 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 2e447beb33e..a7fe1122f91 100644
--- a/databases/postgresql83/distinfo
+++ b/databases/postgresql83/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.25 2012/08/23 16:56:38 adam Exp $
+$NetBSD: distinfo,v 1.26 2012/10/05 22:28:47 adam Exp $
 
-SHA1 (postgresql-8.3.20.tar.bz2) = 5bfe481645418d99c6b5e95c4e7336360995d7f4
-RMD160 (postgresql-8.3.20.tar.bz2) = bb94bcf21752577f5dd1f5fbf6ec6e88ea1fc420
-Size (postgresql-8.3.20.tar.bz2) = 14624435 bytes
+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 (patch-aa) = 6d5e9aa58975181d189060f8523c022aa6c82277
 SHA1 (patch-ab) = 1ba1bb53ca5a74d09fc2b7d07d98b0a0ffd57202
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279