This minor release fixes a data corruption issue with replication and crash recovery in version 9.3, as well as several other minor issues in all versions. All users of version 9.3 are urged to update their installations at the next possible downtime. Users of older versions should update at their convenience.

The data corruption issue in PostgreSQL 9.3 affects binary replication standbys, servers being recovered from point-in-time-recovery backup, and standalone servers which recover from a system crash. The bug causes unrecoverable index corruption during recovery due to incorrect replay of row locking operations. This can then cause query results to be inconsistent depending on whether or not an index is used, and eventually lead to primary key violations and similar issues. For this reason, users are encouraged to replace each of their standby databases with a new base backup after applying the update.

Other PostgreSQL 9.3-only fixes in this update include:

Make sure that statistics files for dropped databases get deleted
Allow materialized views to be referenced in UPDATE and DELETE queries
Add read-only data_checksum parameter
Prevent erroneous operator push-down in postgres_fdw

This release resolves some other issues in all versions of PostgreSQL, including:
Fix timing consistency issue with NOTIFY
Allow regular expression execution to be cancelled
Improve performance of index checks for newly added rows
Prevent premature walsender disconnection
Prevent memory errors on newer Windows versions
Update timezone files

16 files changed, 51 insertions, 37 deletions

diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index f479b8b4be6..ba9e2184dad 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.22 2014/02/23 11:25:50 adam Exp $
+@comment $NetBSD: PLIST,v 1.23 2014/03/27 20:57:54 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1360,6 +1360,7 @@ share/doc/postgresql/html/release-8-4-18.html
 share/doc/postgresql/html/release-8-4-19.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-20.html
+share/doc/postgresql/html/release-8-4-21.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
 share/doc/postgresql/html/release-8-4-5.html
diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index a504c1eb5e5..6d830e19441 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.31 2014/03/13 11:08:50 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.32 2014/03/27 20:57:54 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.20
+DISTNAME=	postgresql-8.4.21
 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 fcde216121d..7cb8248771c 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.28 2014/02/23 11:25:50 adam Exp $
+$NetBSD: distinfo,v 1.29 2014/03/27 20:57:54 adam Exp $
 
-SHA1 (postgresql-8.4.20.tar.bz2) = bad68fc70f90a28212459e5347c32ebbdfcf2c8e
-RMD160 (postgresql-8.4.20.tar.bz2) = 974a4ccf2170ef8f42bbf639c1a74d3100ffa727
-Size (postgresql-8.4.20.tar.bz2) = 14642312 bytes
+SHA1 (postgresql-8.4.21.tar.bz2) = 2669ace05665cf3f7234fdfd8c3e8bf225cbd4af
+RMD160 (postgresql-8.4.21.tar.bz2) = 5bb580b8b8aa20c463c99c3e699c3bc87e4eecc8
+Size (postgresql-8.4.21.tar.bz2) = 14645050 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 86dfd3367e8..fb396b4bf25 100644
--- a/databases/postgresql90-docs/PLIST
+++ b/databases/postgresql90-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2014/02/23 11:25:51 adam Exp $
+@comment $NetBSD: PLIST,v 1.19 2014/03/27 20:57:54 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -930,6 +930,7 @@ share/doc/postgresql/html/release-8-4-18.html
 share/doc/postgresql/html/release-8-4-19.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-20.html
+share/doc/postgresql/html/release-8-4-21.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
 share/doc/postgresql/html/release-8-4-5.html
@@ -946,6 +947,7 @@ share/doc/postgresql/html/release-9-0-13.html
 share/doc/postgresql/html/release-9-0-14.html
 share/doc/postgresql/html/release-9-0-15.html
 share/doc/postgresql/html/release-9-0-16.html
+share/doc/postgresql/html/release-9-0-17.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
diff --git a/databases/postgresql90/Makefile.common b/databases/postgresql90/Makefile.common
index 54355d8786f..71ad2a2aca1 100644
--- a/databases/postgresql90/Makefile.common
+++ b/databases/postgresql90/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.29 2014/03/13 11:08:50 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.30 2014/03/27 20:57:54 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.16
+DISTNAME=	postgresql-9.0.17
 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 201b4f48567..a3b8d2e8fc4 100644
--- a/databases/postgresql90/distinfo
+++ b/databases/postgresql90/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.20 2014/02/23 11:25:51 adam Exp $
+$NetBSD: distinfo,v 1.21 2014/03/27 20:57:54 adam Exp $
 
-SHA1 (postgresql-9.0.16.tar.bz2) = f1a43f182f8727b7d91c612d4169e01ab2a2bcb0
-RMD160 (postgresql-9.0.16.tar.bz2) = b86d79c3f7acfd00c2cb9e3dc79c106b4dfd253b
-Size (postgresql-9.0.16.tar.bz2) = 14956681 bytes
+SHA1 (postgresql-9.0.17.tar.bz2) = 585198b90b2e86b1e2e8e33ff28d7161af20156d
+RMD160 (postgresql-9.0.17.tar.bz2) = 36d1f5e7d4cf9f5703f01b35c507814fd73384a3
+Size (postgresql-9.0.17.tar.bz2) = 14961682 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 d461d6abc2d..6cb58dcd0f3 100644
--- a/databases/postgresql91-docs/PLIST
+++ b/databases/postgresql91-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.14 2014/02/23 11:25:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.15 2014/03/27 20:57:54 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -976,6 +976,7 @@ share/doc/postgresql/html/release-8-4-18.html
 share/doc/postgresql/html/release-8-4-19.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-20.html
+share/doc/postgresql/html/release-8-4-21.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
 share/doc/postgresql/html/release-8-4-5.html
@@ -992,6 +993,7 @@ share/doc/postgresql/html/release-9-0-13.html
 share/doc/postgresql/html/release-9-0-14.html
 share/doc/postgresql/html/release-9-0-15.html
 share/doc/postgresql/html/release-9-0-16.html
+share/doc/postgresql/html/release-9-0-17.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
@@ -1005,6 +1007,7 @@ share/doc/postgresql/html/release-9-1-1.html
 share/doc/postgresql/html/release-9-1-10.html
 share/doc/postgresql/html/release-9-1-11.html
 share/doc/postgresql/html/release-9-1-12.html
+share/doc/postgresql/html/release-9-1-13.html
 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
diff --git a/databases/postgresql91/Makefile.common b/databases/postgresql91/Makefile.common
index 4fa075b516b..9d4edddb8b7 100644
--- a/databases/postgresql91/Makefile.common
+++ b/databases/postgresql91/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.19 2014/03/13 11:08:50 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.20 2014/03/27 20:57:54 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.12
+DISTNAME=	postgresql-9.1.13
 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 7aaee849247..c47eac997db 100644
--- a/databases/postgresql91/distinfo
+++ b/databases/postgresql91/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.17 2014/02/23 11:25:52 adam Exp $
+$NetBSD: distinfo,v 1.18 2014/03/27 20:57:54 adam Exp $
 
-SHA1 (postgresql-9.1.12.tar.bz2) = aaf9097de94a03a4136d36704c48be539c5734ac
-RMD160 (postgresql-9.1.12.tar.bz2) = 124902b260b32311550696858ff437eaddcd46ab
-Size (postgresql-9.1.12.tar.bz2) = 15638909 bytes
+SHA1 (postgresql-9.1.13.tar.bz2) = 89a66350a20dfafbe3f169e29f1a06a80c46f862
+RMD160 (postgresql-9.1.13.tar.bz2) = 1380aead164062393fe758d323e1d9d22118155a
+Size (postgresql-9.1.13.tar.bz2) = 15652239 bytes
 SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = dab79533dac06a79a5aa8439d6b15830d8d2fba7
 SHA1 (patch-contrib_dblink_Makefile) = 4960ad57d42465fae203870548e4c53f8a32ce04
diff --git a/databases/postgresql92-docs/PLIST b/databases/postgresql92-docs/PLIST
index 7486acf13fb..3cd1e329b8b 100644
--- a/databases/postgresql92-docs/PLIST
+++ b/databases/postgresql92-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2014/02/23 11:25:53 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2014/03/27 20:57:55 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -1005,6 +1005,7 @@ share/doc/postgresql/html/release-8-4-18.html
 share/doc/postgresql/html/release-8-4-19.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-20.html
+share/doc/postgresql/html/release-8-4-21.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
 share/doc/postgresql/html/release-8-4-5.html
@@ -1021,6 +1022,7 @@ share/doc/postgresql/html/release-9-0-13.html
 share/doc/postgresql/html/release-9-0-14.html
 share/doc/postgresql/html/release-9-0-15.html
 share/doc/postgresql/html/release-9-0-16.html
+share/doc/postgresql/html/release-9-0-17.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
@@ -1034,6 +1036,7 @@ share/doc/postgresql/html/release-9-1-1.html
 share/doc/postgresql/html/release-9-1-10.html
 share/doc/postgresql/html/release-9-1-11.html
 share/doc/postgresql/html/release-9-1-12.html
+share/doc/postgresql/html/release-9-1-13.html
 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
@@ -1050,6 +1053,7 @@ share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
 share/doc/postgresql/html/release-9-2-6.html
 share/doc/postgresql/html/release-9-2-7.html
+share/doc/postgresql/html/release-9-2-8.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/Makefile.common b/databases/postgresql92/Makefile.common
index 131eb936ae3..9f4c658f424 100644
--- a/databases/postgresql92/Makefile.common
+++ b/databases/postgresql92/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2014/03/13 11:08:50 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.11 2014/03/27 20:57:54 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.7
+DISTNAME=	postgresql-9.2.8
 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 511d3a5c03d..0db416c8265 100644
--- a/databases/postgresql92/distinfo
+++ b/databases/postgresql92/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.7 2014/02/23 11:25:53 adam Exp $
+$NetBSD: distinfo,v 1.8 2014/03/27 20:57:54 adam Exp $
 
-SHA1 (postgresql-9.2.7.tar.bz2) = 20b6a83e7ba4bbaa1544bfdf4622ccd205bfc509
-RMD160 (postgresql-9.2.7.tar.bz2) = a7dca6b283a74764402f215085d01892dff02980
-Size (postgresql-9.2.7.tar.bz2) = 16248445 bytes
+SHA1 (postgresql-9.2.8.tar.bz2) = 228cb1f1af47fd073d578eaad794e7ff6615812a
+RMD160 (postgresql-9.2.8.tar.bz2) = ac9fac285e6488f1b4635650e34e8eac49b5eddd
+Size (postgresql-9.2.8.tar.bz2) = 16263345 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = 21b27add570cff1a24c440201eb1ed49f8223747
diff --git a/databases/postgresql93-docs/PLIST b/databases/postgresql93-docs/PLIST
index d9cbca581c4..34e15ca0155 100644
--- a/databases/postgresql93-docs/PLIST
+++ b/databases/postgresql93-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2014/02/23 11:25:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2014/03/27 20:57:55 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -1026,6 +1026,7 @@ share/doc/postgresql/html/release-8-4-18.html
 share/doc/postgresql/html/release-8-4-19.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-20.html
+share/doc/postgresql/html/release-8-4-21.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
 share/doc/postgresql/html/release-8-4-5.html
@@ -1042,6 +1043,7 @@ share/doc/postgresql/html/release-9-0-13.html
 share/doc/postgresql/html/release-9-0-14.html
 share/doc/postgresql/html/release-9-0-15.html
 share/doc/postgresql/html/release-9-0-16.html
+share/doc/postgresql/html/release-9-0-17.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
@@ -1055,6 +1057,7 @@ share/doc/postgresql/html/release-9-1-1.html
 share/doc/postgresql/html/release-9-1-10.html
 share/doc/postgresql/html/release-9-1-11.html
 share/doc/postgresql/html/release-9-1-12.html
+share/doc/postgresql/html/release-9-1-13.html
 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
@@ -1071,10 +1074,12 @@ share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
 share/doc/postgresql/html/release-9-2-6.html
 share/doc/postgresql/html/release-9-2-7.html
+share/doc/postgresql/html/release-9-2-8.html
 share/doc/postgresql/html/release-9-2.html
 share/doc/postgresql/html/release-9-3-1.html
 share/doc/postgresql/html/release-9-3-2.html
 share/doc/postgresql/html/release-9-3-3.html
+share/doc/postgresql/html/release-9-3-4.html
 share/doc/postgresql/html/release-9-3.html
 share/doc/postgresql/html/release.html
 share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql93-monitoring/Makefile b/databases/postgresql93-monitoring/Makefile
index 68ec33f04b1..4feb414bb9a 100644
--- a/databases/postgresql93-monitoring/Makefile
+++ b/databases/postgresql93-monitoring/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.4 2014/03/13 14:57:20 jperkin Exp $
+# $NetBSD: Makefile,v 1.5 2014/03/27 20:57:55 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/93-monitoring-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL monitoring tools
 
 DEPENDS+=	postgresql93-server>=${PKGVERSION_NOREV}:../../databases/postgresql93-server
diff --git a/databases/postgresql93/Makefile.common b/databases/postgresql93/Makefile.common
index 7a722a84488..8032656484f 100644
--- a/databases/postgresql93/Makefile.common
+++ b/databases/postgresql93/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.5 2014/02/23 11:25:54 adam Exp $
+# $NetBSD: Makefile.common,v 1.6 2014/03/27 20:57:55 adam Exp $
 #
 # used by databases/postgresql93-adminpack/Makefile
 # used by databases/postgresql93-client/Makefile
@@ -21,7 +21,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-9.3.3
+DISTNAME=	postgresql-9.3.4
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql93/distinfo b/databases/postgresql93/distinfo
index 5df28d7363c..2dc89ab6d96 100644
--- a/databases/postgresql93/distinfo
+++ b/databases/postgresql93/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.6 2014/02/23 11:25:54 adam Exp $
+$NetBSD: distinfo,v 1.7 2014/03/27 20:57:55 adam Exp $
 
-SHA1 (postgresql-9.3.3.tar.bz2) = 66d07c89f6a00468d27d3bafb7fc0eb040355a99
-RMD160 (postgresql-9.3.3.tar.bz2) = d97011af9c9583d2fca7613aeedaba765f071518
-Size (postgresql-9.3.3.tar.bz2) = 16665845 bytes
+SHA1 (postgresql-9.3.4.tar.bz2) = a5b4a63339c26849e8e9b7645436c976e4b40f50
+RMD160 (postgresql-9.3.4.tar.bz2) = 126df8cb07a28e5d58ca2d1b9fc1d20e4f7a8cf1
+Size (postgresql-9.3.4.tar.bz2) = 16691447 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = e035132b1c281a75752d570ac5e29a11176c25c5
 SHA1 (patch-configure) = 3de7635fe18532a05a619941fecad7bcda6c51b9