[pkgsrc/trunk]: pkgsrc/databases The PostgreSQL Global Development Group has ...

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/9ea7ae11cf49
branches:  trunk
changeset: 609535:9ea7ae11cf49
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Oct 05 22:15:35 2012 +0000

description:
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

diffstat:

 databases/postgresql83-plperl/Makefile   |  3 +--
 databases/postgresql84-client/PLIST      |  4 +++-
 databases/postgresql84-plperl/Makefile   |  3 +--
 databases/postgresql84-plpython/Makefile |  3 +--
 databases/postgresql84-pltcl/Makefile    |  3 +--
 databases/postgresql84/Makefile.common   |  4 ++--
 databases/postgresql84/distinfo          |  8 ++++----
 databases/postgresql90-docs/PLIST        |  5 ++++-
 databases/postgresql90-plperl/Makefile   |  3 +--
 databases/postgresql90/Makefile.common   |  4 ++--
 databases/postgresql90/distinfo          |  8 ++++----
 databases/postgresql91-docs/PLIST        |  6 +++++-
 databases/postgresql91-plperl/Makefile   |  3 +--
 databases/postgresql91/Makefile.common   |  4 ++--
 databases/postgresql91/distinfo          |  8 ++++----
 15 files changed, 36 insertions(+), 33 deletions(-)

diffs (273 lines):

diff -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql83-plperl/Makefile
--- a/databases/postgresql83-plperl/Makefile    Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql83-plperl/Makefile    Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql84-client/PLIST
--- a/databases/postgresql84-client/PLIST       Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql84-client/PLIST       Fri Oct 05 22:15:35 2012 +0000
@@ -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-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-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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql84-plperl/Makefile
--- a/databases/postgresql84-plperl/Makefile    Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql84-plperl/Makefile    Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql84-plpython/Makefile
--- a/databases/postgresql84-plpython/Makefile  Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql84-plpython/Makefile  Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql84-pltcl/Makefile
--- a/databases/postgresql84-pltcl/Makefile     Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql84-pltcl/Makefile     Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql84/Makefile.common
--- a/databases/postgresql84/Makefile.common    Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql84/Makefile.common    Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql84/distinfo
--- a/databases/postgresql84/distinfo   Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql84/distinfo   Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql90-docs/PLIST
--- a/databases/postgresql90-docs/PLIST Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql90-docs/PLIST Fri Oct 05 22:15:35 2012 +0000
@@ -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-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-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-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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql90-plperl/Makefile
--- a/databases/postgresql90-plperl/Makefile    Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql90-plperl/Makefile    Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql90/Makefile.common
--- a/databases/postgresql90/Makefile.common    Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql90/Makefile.common    Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql90/distinfo
--- a/databases/postgresql90/distinfo   Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql90/distinfo   Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql91-docs/PLIST
--- a/databases/postgresql91-docs/PLIST Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql91-docs/PLIST Fri Oct 05 22:15:35 2012 +0000
@@ -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-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-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-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-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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql91-plperl/Makefile
--- a/databases/postgresql91-plperl/Makefile    Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql91-plperl/Makefile    Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql91/Makefile.common
--- a/databases/postgresql91/Makefile.common    Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql91/Makefile.common    Fri Oct 05 22:15:35 2012 +0000
@@ -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 -r 0d973b340fab -r 9ea7ae11cf49 databases/postgresql91/distinfo
--- a/databases/postgresql91/distinfo   Fri Oct 05 21:09:02 2012 +0000
+++ b/databases/postgresql91/distinfo   Fri Oct 05 22:15:35 2012 +0000
@@ -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