The PostgreSQL Global Development Group has released a critical update to all supported versions of the PostgreSQL database system, which includes minor versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This update fixes three serious data-loss bugs affecting replication and database maintenance. All users are urged to update their installations at the earliest opportunity.

The replication issue affects some users of PostgreSQL binary replication, and can cause minor data loss between the master and the standby. While not all users are affected, it is difficult to predict when the bug will occur, so we urge all users of replication and continuous backup (PITR) to update immediately. Additionally, users who had replication running under PostgreSQL minor versions 9.3.0, 9.3.1, 9.2.5, 9.1.10, or 9.0.14 should plan to take a fresh base backup of each standby after update, in order to ensure no prior data corruption already exists.

This release also fixes two timing issues with VACUUM, which can cause old, overwritten or deleted rows to re-appear at a later date under some circumstances. Users with very high transaction rates, particularly those who experience "transaction ID wraparound" every few weeks or less, are the most at risk for this issue. Those users should set vacuum_freeze_table_age to 0, and run a database-wide VACUUM after the update. The second of the two VACUUM issues affects only 9.3, making it expecially important for 9.3 users to update.

3 files changed, 15 insertions, 17 deletions

diff --git a/databases/postgresql92-datatypes/DESCR b/databases/postgresql92-datatypes/DESCR
index 0fd1fb2d6cd..81d686b929f 100644
--- a/databases/postgresql92-datatypes/DESCR
+++ b/databases/postgresql92-datatypes/DESCR
@@ -1,12 +1,5 @@
-This package provides the following PostgreSQL modules:
-  - citext
-  - hstore
-  - intarray
-  - isn
-  - ltree
-  - lo
-  - uuid-ossp
-  - unaccent
+This package provides the following PostgreSQL modules: citext, hstore,
+intarray, isn, ltree, lo, uuid-ossp, unaccent.
 
 The "citext" module provides a case-insensitive character string type,
 citext. Essentially, it internally calls lower when comparing values.
diff --git a/databases/postgresql92-datatypes/Makefile b/databases/postgresql92-datatypes/Makefile
index 9607e87aced..491ddae00ab 100644
--- a/databases/postgresql92-datatypes/Makefile
+++ b/databases/postgresql92-datatypes/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.4 2013/02/09 11:19:17 adam Exp $
+# $NetBSD: Makefile,v 1.5 2013/12/10 22:32:57 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/92-datatypes-/}
 COMMENT=	PostgreSQL data types support modules
@@ -7,9 +7,16 @@ DEPENDS+=	postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-
 
 .include "../../databases/postgresql92/Makefile.common"
 
+PLIST_VARS+=		uuid
+
+.if ${OPSYS} != "Darwin"
+PLIST.uuid=		yes
 CONFIGURE_ARGS+=	--with-ossp-uuid
 # because global pg_config.h is included, we have to define this
 CPPFLAGS+=		-DHAVE_UUID_H
+BUILD_DIRS+=		contrib/uuid-ossp
+.  include "../../devel/ossp-uuid/buildlink3.mk"
+.endif
 
 BUILD_DIRS+=		contrib/citext
 BUILD_DIRS+=		contrib/hstore
@@ -17,10 +24,8 @@ BUILD_DIRS+=		contrib/intarray
 BUILD_DIRS+=		contrib/isn
 BUILD_DIRS+=		contrib/ltree
 BUILD_DIRS+=		contrib/lo
-BUILD_DIRS+=		contrib/uuid-ossp
 BUILD_DIRS+=		contrib/unaccent
 BUILD_MAKE_FLAGS=	PGXS=1
 
 .include "../../databases/postgresql92-client/buildlink3.mk"
-.include "../../devel/ossp-uuid/buildlink3.mk"
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql92-datatypes/PLIST b/databases/postgresql92-datatypes/PLIST
index 98515c8cfda..5e46c7f651e 100644
--- a/databases/postgresql92-datatypes/PLIST
+++ b/databases/postgresql92-datatypes/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 2013/12/10 22:32:57 adam Exp $
 lib/postgresql/_int.so
 lib/postgresql/citext.so
 lib/postgresql/hstore.so
@@ -6,7 +6,7 @@ lib/postgresql/isn.so
 lib/postgresql/lo.so
 lib/postgresql/ltree.so
 lib/postgresql/unaccent.so
-lib/postgresql/uuid-ossp.so
+${PLIST.uuid}lib/postgresql/uuid-ossp.so
 share/postgresql/extension/citext--1.0.sql
 share/postgresql/extension/citext--unpackaged--1.0.sql
 share/postgresql/extension/citext.control
@@ -29,7 +29,7 @@ share/postgresql/extension/ltree.control
 share/postgresql/extension/unaccent--1.0.sql
 share/postgresql/extension/unaccent--unpackaged--1.0.sql
 share/postgresql/extension/unaccent.control
-share/postgresql/extension/uuid-ossp--1.0.sql
-share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql
-share/postgresql/extension/uuid-ossp.control
+${PLIST.uuid}share/postgresql/extension/uuid-ossp--1.0.sql
+${PLIST.uuid}share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql
+${PLIST.uuid}share/postgresql/extension/uuid-ossp.control
 share/postgresql/tsearch_data/unaccent.rules