From f17d7f2051a9e288d043107bec7d55bd6d9e4a47 Mon Sep 17 00:00:00 2001 From: Palle Girgensohn Date: Thu, 9 Feb 2017 15:22:44 +0000 Subject: PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.2, 9.5.6, 9.4.11, 9.3.16, and 9.2.20. This release includes fixes that prevent data corruption issues in index builds and in certain write-ahead-log replay situations, which are detailed below. It also patches over 75 other bugs reported over the last three months. Users should plan to apply this update at the next scheduled downtime. Build corruption with CREATE INDEX CONCURRENTLY There existed a race condition if CREATE INDEX CONCURRENTLY was called on a column that had not been indexed before, then rows that were updated by transactions running at the same time as the CREATE INDEX CONCURRENTLY command could have been indexed incorrectly. If you suspect this may have happened, the most reliable solution is to rebuild affected indexes after installing this update. This issue is present in the 9.2, 9.3, 9.4, 9.5, and 9.6 series of PostgreSQL. URL https://www.postgresql.org/about/news/1733/ --- databases/postgresql92-server/Makefile | 4 ++-- databases/postgresql92-server/distinfo | 6 +++--- databases/postgresql92-server/pkg-plist-server | 3 +++ 3 files changed, 8 insertions(+), 5 deletions(-) (limited to 'databases/postgresql92-server') diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile index 69037fe7d34b..4ebe8333bf56 100644 --- a/databases/postgresql92-server/Makefile +++ b/databases/postgresql92-server/Makefile @@ -2,8 +2,8 @@ # $FreeBSD$ PORTNAME?= postgresql -DISTVERSION?= 9.2.19 -PORTREVISION?= 1 +DISTVERSION?= 9.2.20 +PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= PGSQL/source/v${DISTVERSION} PKGNAMESUFFIX?= ${PORTVERSION:R:S/.//}${COMPONENT} diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo index 2d4a634bd899..c7a5c08faf43 100644 --- a/databases/postgresql92-server/distinfo +++ b/databases/postgresql92-server/distinfo @@ -1,5 +1,5 @@ -TIMESTAMP = 1477347738 -SHA256 (postgresql/postgresql-9.2.19.tar.bz2) = 1d29d73a4f590fcc348280f13ac2ff6a0f72c94908c54e3c20b7ab1560e8dbad -SIZE (postgresql/postgresql-9.2.19.tar.bz2) = 16466698 +TIMESTAMP = 1486640625 +SHA256 (postgresql/postgresql-9.2.20.tar.bz2) = 0b8abdae8400cabea5587a726003c9dd71c73c049bdae523abc35f9312dd8f26 +SIZE (postgresql/postgresql-9.2.20.tar.bz2) = 16480653 SHA256 (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 2f9c831b3dff866f0b2f6f2a9ef771a4045486bc252a851aadc73c50d376319d SIZE (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 5587 diff --git a/databases/postgresql92-server/pkg-plist-server b/databases/postgresql92-server/pkg-plist-server index d0199b45d231..dd879aa2dc23 100644 --- a/databases/postgresql92-server/pkg-plist-server +++ b/databases/postgresql92-server/pkg-plist-server @@ -379,6 +379,7 @@ lib/postgresql/utf8_and_win.so %%TZDATA%%%%DATADIR%%/timezone/Asia/Aqtobe %%TZDATA%%%%DATADIR%%/timezone/Asia/Ashgabat %%TZDATA%%%%DATADIR%%/timezone/Asia/Ashkhabad +%%TZDATA%%%%DATADIR%%/timezone/Asia/Atyrau %%TZDATA%%%%DATADIR%%/timezone/Asia/Baghdad %%TZDATA%%%%DATADIR%%/timezone/Asia/Bahrain %%TZDATA%%%%DATADIR%%/timezone/Asia/Baku @@ -399,6 +400,7 @@ lib/postgresql/utf8_and_win.so %%TZDATA%%%%DATADIR%%/timezone/Asia/Dili %%TZDATA%%%%DATADIR%%/timezone/Asia/Dubai %%TZDATA%%%%DATADIR%%/timezone/Asia/Dushanbe +%%TZDATA%%%%DATADIR%%/timezone/Asia/Famagusta %%TZDATA%%%%DATADIR%%/timezone/Asia/Gaza %%TZDATA%%%%DATADIR%%/timezone/Asia/Harbin %%TZDATA%%%%DATADIR%%/timezone/Asia/Hebron @@ -604,6 +606,7 @@ lib/postgresql/utf8_and_win.so %%TZDATA%%%%DATADIR%%/timezone/Europe/Samara %%TZDATA%%%%DATADIR%%/timezone/Europe/San_Marino %%TZDATA%%%%DATADIR%%/timezone/Europe/Sarajevo +%%TZDATA%%%%DATADIR%%/timezone/Europe/Saratov %%TZDATA%%%%DATADIR%%/timezone/Europe/Simferopol %%TZDATA%%%%DATADIR%%/timezone/Europe/Skopje %%TZDATA%%%%DATADIR%%/timezone/Europe/Sofia -- cgit v1.2.3