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, 22 insertions, 6 deletions

diff --git a/databases/postgresql90/Makefile.common b/databases/postgresql90/Makefile.common
index b9dbf182385..7df01e2c068 100644
--- a/databases/postgresql90/Makefile.common
+++ b/databases/postgresql90/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.26 2013/12/02 23:08:54 bsiegert Exp $
+# $NetBSD: Makefile.common,v 1.27 2013/12/10 22:32:56 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.14
+DISTNAME=	postgresql-9.0.15
 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 14a63e8132d..994aea4a10c 100644
--- a/databases/postgresql90/distinfo
+++ b/databases/postgresql90/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.18 2013/10/12 20:39:42 adam Exp $
+$NetBSD: distinfo,v 1.19 2013/12/10 22:32:56 adam Exp $
 
-SHA1 (postgresql-9.0.14.tar.bz2) = f6d59d6fddbecc16d8f4d3ccbb70d62f77d56564
-RMD160 (postgresql-9.0.14.tar.bz2) = 17e5f49bb8497a92f641b2bc607cbd5aa6848104
-Size (postgresql-9.0.14.tar.bz2) = 15154015 bytes
+SHA1 (postgresql-9.0.15.tar.bz2) = 1e12b52c1989f9e2770898ea44c26b83a8dcc09e
+RMD160 (postgresql-9.0.15.tar.bz2) = a951bffd112017f3169ba3c8b6961243501b45ec
+Size (postgresql-9.0.15.tar.bz2) = 15169745 bytes
 SHA1 (patch-aa) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-ab) = 6adfc53e325abe69582f1c7971f56144c697e9c1
 SHA1 (patch-ac) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5
@@ -15,3 +15,4 @@ SHA1 (patch-ao) = 4d7c40d107d4c13c63ef2908d9a02be319863657
 SHA1 (patch-src_Makefile.shlib) = 72d6db917b7d6ba1dbf8037e03f83a7ce7c4d6c9
 SHA1 (patch-src_makefiles_Makefile.solaris) = 0168f5bc105ffc89d5db40907a08966d8465f5a0
 SHA1 (patch-src_pl_plperl_plperl.h) = 8e2d954642cb68dc6c6fd08debd058d053566826
+SHA1 (patch-src_pl_plpython_Makefile) = d70e0cf5e20479851df3ededa50776fd04846d49
diff --git a/databases/postgresql90/patches/patch-src_pl_plpython_Makefile b/databases/postgresql90/patches/patch-src_pl_plpython_Makefile
new file mode 100644
index 00000000000..520f81fba49
--- /dev/null
+++ b/databases/postgresql90/patches/patch-src_pl_plpython_Makefile
@@ -0,0 +1,15 @@
+$NetBSD: patch-src_pl_plpython_Makefile,v 1.1 2013/12/10 22:32:56 adam Exp $
+
+Don't try to use Python framework.
+
+--- src/pl/plpython/Makefile.orig	2013-12-10 21:48:07.000000000 +0000
++++ src/pl/plpython/Makefile
+@@ -24,8 +24,6 @@ endif
+ # Darwin (OS X) has its own ideas about how to do this.
+ ifeq ($(PORTNAME), darwin)
+ shared_libpython = yes
+-override python_libspec = -framework Python
+-override python_additional_libs =
+ endif
+ 
+ # If we don't have a shared library and the platform doesn't allow it