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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/38d43393723c
branches:  trunk
changeset: 609536:38d43393723c
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Oct 05 22:28:47 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-client/PLIST    |  3 ++-
 databases/postgresql83/Makefile.common |  4 ++--
 databases/postgresql83/distinfo        |  8 ++++----
 3 files changed, 8 insertions(+), 7 deletions(-)

diffs (51 lines):

diff -r 9ea7ae11cf49 -r 38d43393723c databases/postgresql83-client/PLIST
--- a/databases/postgresql83-client/PLIST       Fri Oct 05 22:15:35 2012 +0000
+++ b/databases/postgresql83-client/PLIST       Fri Oct 05 22:28:47 2012 +0000
@@ -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-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 -r 9ea7ae11cf49 -r 38d43393723c databases/postgresql83/Makefile.common
--- a/databases/postgresql83/Makefile.common    Fri Oct 05 22:15:35 2012 +0000
+++ b/databases/postgresql83/Makefile.common    Fri Oct 05 22:28:47 2012 +0000
@@ -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 -r 9ea7ae11cf49 -r 38d43393723c databases/postgresql83/distinfo
--- a/databases/postgresql83/distinfo   Fri Oct 05 22:15:35 2012 +0000
+++ b/databases/postgresql83/distinfo   Fri Oct 05 22:28:47 2012 +0000
@@ -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