Date: Thu, 9 Feb 2017 15:22:44 +0000 (UTC) From: Palle Girgensohn <girgen@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r433738 - in head/databases: postgresql92-server postgresql93-server postgresql94-server postgresql95-server postgresql96-server Message-ID: <201702091522.v19FMi7i020751@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
Author: girgen Date: Thu Feb 9 15:22:44 2017 New Revision: 433738 URL: https://svnweb.freebsd.org/changeset/ports/433738 Log: 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/ Modified: head/databases/postgresql92-server/Makefile head/databases/postgresql92-server/distinfo head/databases/postgresql92-server/pkg-plist-server head/databases/postgresql93-server/Makefile head/databases/postgresql93-server/distinfo head/databases/postgresql93-server/pkg-plist-server head/databases/postgresql94-server/Makefile head/databases/postgresql94-server/distinfo head/databases/postgresql94-server/pkg-plist-server head/databases/postgresql95-server/Makefile head/databases/postgresql95-server/distinfo head/databases/postgresql95-server/pkg-plist-server head/databases/postgresql96-server/Makefile head/databases/postgresql96-server/distinfo head/databases/postgresql96-server/pkg-plist-server Modified: head/databases/postgresql92-server/Makefile ============================================================================== --- head/databases/postgresql92-server/Makefile Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql92-server/Makefile Thu Feb 9 15:22:44 2017 (r433738) @@ -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} Modified: head/databases/postgresql92-server/distinfo ============================================================================== --- head/databases/postgresql92-server/distinfo Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql92-server/distinfo Thu Feb 9 15:22:44 2017 (r433738) @@ -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 Modified: head/databases/postgresql92-server/pkg-plist-server ============================================================================== --- head/databases/postgresql92-server/pkg-plist-server Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql92-server/pkg-plist-server Thu Feb 9 15:22:44 2017 (r433738) @@ -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 Modified: head/databases/postgresql93-server/Makefile ============================================================================== --- head/databases/postgresql93-server/Makefile Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql93-server/Makefile Thu Feb 9 15:22:44 2017 (r433738) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.3.15 +DISTVERSION?= 9.3.16 PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql93-server/distinfo ============================================================================== --- head/databases/postgresql93-server/distinfo Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql93-server/distinfo Thu Feb 9 15:22:44 2017 (r433738) @@ -1,5 +1,5 @@ -TIMESTAMP = 1477347757 -SHA256 (postgresql/postgresql-9.3.15.tar.bz2) = a9fcba1446a93aa95e3e1b6535756f0472d10b0f267a0845f8b2b29f89de5c4f -SIZE (postgresql/postgresql-9.3.15.tar.bz2) = 17059932 +TIMESTAMP = 1486640625 +SHA256 (postgresql/postgresql-9.3.16.tar.bz2) = 845f5e4ac8cf026b6a77c5a180a2fe869f51e9d06acf8d0365b05505a2c66873 +SIZE (postgresql/postgresql-9.3.16.tar.bz2) = 17108969 SHA256 (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 4be31ad9899d5caf9f57ad7ebfc0d14f0fcf58ad539c82fb353b016fb76c0c30 SIZE (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 5583 Modified: head/databases/postgresql93-server/pkg-plist-server ============================================================================== --- head/databases/postgresql93-server/pkg-plist-server Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql93-server/pkg-plist-server Thu Feb 9 15:22:44 2017 (r433738) @@ -368,6 +368,7 @@ lib/libpgcommon.a %%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 @@ -388,6 +389,7 @@ lib/libpgcommon.a %%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 @@ -593,6 +595,7 @@ lib/libpgcommon.a %%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 Modified: head/databases/postgresql94-server/Makefile ============================================================================== --- head/databases/postgresql94-server/Makefile Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql94-server/Makefile Thu Feb 9 15:22:44 2017 (r433738) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.4.10 +DISTVERSION?= 9.4.11 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql94-server/distinfo ============================================================================== --- head/databases/postgresql94-server/distinfo Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql94-server/distinfo Thu Feb 9 15:22:44 2017 (r433738) @@ -1,5 +1,5 @@ -TIMESTAMP = 1477347764 -SHA256 (postgresql/postgresql-9.4.10.tar.bz2) = 7061678bed1981c681ce54c76b98b6ec17743f090a9775104a45e7e1a8826ecf -SIZE (postgresql/postgresql-9.4.10.tar.bz2) = 17802812 +TIMESTAMP = 1486640625 +SHA256 (postgresql/postgresql-9.4.11.tar.bz2) = e3eb51d045c180b03d2de1f0c3af9356e10be49448e966ca01dfc2c6d1cc9d23 +SIZE (postgresql/postgresql-9.4.11.tar.bz2) = 17832915 SHA256 (postgresql/pg-949-icu-2016-10-02.diff.gz) = 34612e685a79874db04bc6b66c700bfc6412042840c532eef0da7832d1f70d43 SIZE (postgresql/pg-949-icu-2016-10-02.diff.gz) = 5289 Modified: head/databases/postgresql94-server/pkg-plist-server ============================================================================== --- head/databases/postgresql94-server/pkg-plist-server Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql94-server/pkg-plist-server Thu Feb 9 15:22:44 2017 (r433738) @@ -369,6 +369,7 @@ lib/libpgcommon.a %%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 @@ -389,6 +390,7 @@ lib/libpgcommon.a %%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 @@ -453,8 +455,8 @@ lib/libpgcommon.a %%TZDATA%%%%DATADIR%%/timezone/Asia/Ust-Nera %%TZDATA%%%%DATADIR%%/timezone/Asia/Vientiane %%TZDATA%%%%DATADIR%%/timezone/Asia/Vladivostok -%%TZDATA%%%%DATADIR%%/timezone/Asia/Yangon %%TZDATA%%%%DATADIR%%/timezone/Asia/Yakutsk +%%TZDATA%%%%DATADIR%%/timezone/Asia/Yangon %%TZDATA%%%%DATADIR%%/timezone/Asia/Yekaterinburg %%TZDATA%%%%DATADIR%%/timezone/Asia/Yerevan %%TZDATA%%%%DATADIR%%/timezone/Atlantic/Azores @@ -594,6 +596,7 @@ lib/libpgcommon.a %%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 Modified: head/databases/postgresql95-server/Makefile ============================================================================== --- head/databases/postgresql95-server/Makefile Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql95-server/Makefile Thu Feb 9 15:22:44 2017 (r433738) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.5.5 +DISTVERSION?= 9.5.6 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql95-server/distinfo ============================================================================== --- head/databases/postgresql95-server/distinfo Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql95-server/distinfo Thu Feb 9 15:22:44 2017 (r433738) @@ -1,5 +1,5 @@ -TIMESTAMP = 1477347770 -SHA256 (postgresql/postgresql-9.5.5.tar.bz2) = 02c65290be74de6604c3fed87c9fd3e6b32e949f0ab8105a75bd7ed5aa71f394 -SIZE (postgresql/postgresql-9.5.5.tar.bz2) = 18525082 +TIMESTAMP = 1486640626 +SHA256 (postgresql/postgresql-9.5.6.tar.bz2) = bb9e5f6d34e20783e96e10c1d6c0c09c31749e802aaa46b793ce2522725ae12f +SIZE (postgresql/postgresql-9.5.6.tar.bz2) = 18598551 SHA256 (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5fa083ec38087d6a0961642208f012e902221270708b919b92e9eedaa755e365 SIZE (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5952 Modified: head/databases/postgresql95-server/pkg-plist-server ============================================================================== --- head/databases/postgresql95-server/pkg-plist-server Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql95-server/pkg-plist-server Thu Feb 9 15:22:44 2017 (r433738) @@ -390,6 +390,7 @@ lib/libpgcommon.a %%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 @@ -410,6 +411,7 @@ lib/libpgcommon.a %%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 @@ -615,6 +617,7 @@ lib/libpgcommon.a %%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 Modified: head/databases/postgresql96-server/Makefile ============================================================================== --- head/databases/postgresql96-server/Makefile Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql96-server/Makefile Thu Feb 9 15:22:44 2017 (r433738) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.6.1 +DISTVERSION?= 9.6.2 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql96-server/distinfo ============================================================================== --- head/databases/postgresql96-server/distinfo Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql96-server/distinfo Thu Feb 9 15:22:44 2017 (r433738) @@ -1,5 +1,5 @@ -TIMESTAMP = 1477347775 -SHA256 (postgresql/postgresql-9.6.1.tar.bz2) = e5101e0a49141fc12a7018c6dad594694d3a3325f5ab71e93e0e51bd94e51fcd -SIZE (postgresql/postgresql-9.6.1.tar.bz2) = 19260568 +TIMESTAMP = 1486640626 +SHA256 (postgresql/postgresql-9.6.2.tar.bz2) = 0187b5184be1c09034e74e44761505e52357248451b0c854dddec6c231fe50c9 +SIZE (postgresql/postgresql-9.6.2.tar.bz2) = 19478040 SHA256 (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 85f81baa0fc8f692bcf802c8645196d9e3afdef4f760cef712d940b87655486e SIZE (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 5998 Modified: head/databases/postgresql96-server/pkg-plist-server ============================================================================== --- head/databases/postgresql96-server/pkg-plist-server Thu Feb 9 15:00:42 2017 (r433737) +++ head/databases/postgresql96-server/pkg-plist-server Thu Feb 9 15:22:44 2017 (r433738) @@ -392,6 +392,7 @@ lib/libpgcommon.a %%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 @@ -412,6 +413,7 @@ lib/libpgcommon.a %%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 @@ -617,6 +619,7 @@ lib/libpgcommon.a %%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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201702091522.v19FMi7i020751>