diff options
author | adam <adam@pkgsrc.org> | 2014-03-27 20:57:54 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2014-03-27 20:57:54 +0000 |
commit | 9f4a59211f56b7d676ad14a45c68fc7e3f79b6b4 (patch) | |
tree | 7d26296d31211971f03818989d656d22615ca6a8 /databases/postgresql90 | |
parent | f8d4c02bf5364bf12c7686f3be22ec31314f9933 (diff) | |
download | pkgsrc-9f4a59211f56b7d676ad14a45c68fc7e3f79b6b4.tar.gz |
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
Diffstat (limited to 'databases/postgresql90')
-rw-r--r-- | databases/postgresql90/Makefile.common | 4 | ||||
-rw-r--r-- | databases/postgresql90/distinfo | 8 |
2 files changed, 6 insertions, 6 deletions
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 |