diff options
author | girgen <girgen@FreeBSD.org> | 2017-02-09 23:22:44 +0800 |
---|---|---|
committer | girgen <girgen@FreeBSD.org> | 2017-02-09 23:22:44 +0800 |
commit | b7d7e7021bf2836bdf0b5cc4a16e89346cf4f4d7 (patch) | |
tree | 743aa914c29fdb325d251d9a5e26c464263d9526 /databases | |
parent | 04e71b51671ea2d9881132e817985528edbbcf57 (diff) | |
download | freebsd-ports-gnome-b7d7e7021bf2836bdf0b5cc4a16e89346cf4f4d7.tar.gz freebsd-ports-gnome-b7d7e7021bf2836bdf0b5cc4a16e89346cf4f4d7.tar.zst freebsd-ports-gnome-b7d7e7021bf2836bdf0b5cc4a16e89346cf4f4d7.zip |
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/
Diffstat (limited to 'databases')
-rw-r--r-- | databases/postgresql92-server/Makefile | 4 | ||||
-rw-r--r-- | databases/postgresql92-server/distinfo | 6 | ||||
-rw-r--r-- | databases/postgresql92-server/pkg-plist-server | 3 | ||||
-rw-r--r-- | databases/postgresql93-server/Makefile | 2 | ||||
-rw-r--r-- | databases/postgresql93-server/distinfo | 6 | ||||
-rw-r--r-- | databases/postgresql93-server/pkg-plist-server | 3 | ||||
-rw-r--r-- | databases/postgresql94-server/Makefile | 2 | ||||
-rw-r--r-- | databases/postgresql94-server/distinfo | 6 | ||||
-rw-r--r-- | databases/postgresql94-server/pkg-plist-server | 5 | ||||
-rw-r--r-- | databases/postgresql95-server/Makefile | 2 | ||||
-rw-r--r-- | databases/postgresql95-server/distinfo | 6 | ||||
-rw-r--r-- | databases/postgresql95-server/pkg-plist-server | 3 | ||||
-rw-r--r-- | databases/postgresql96-server/Makefile | 2 | ||||
-rw-r--r-- | databases/postgresql96-server/distinfo | 6 | ||||
-rw-r--r-- | databases/postgresql96-server/pkg-plist-server | 3 |
15 files changed, 37 insertions, 22 deletions
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 diff --git a/databases/postgresql93-server/Makefile b/databases/postgresql93-server/Makefile index ce5b13682e76..a290e42a666b 100644 --- a/databases/postgresql93-server/Makefile +++ b/databases/postgresql93-server/Makefile @@ -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 diff --git a/databases/postgresql93-server/distinfo b/databases/postgresql93-server/distinfo index e2f99d2cfc2f..ed9f9121fdd0 100644 --- a/databases/postgresql93-server/distinfo +++ b/databases/postgresql93-server/distinfo @@ -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 diff --git a/databases/postgresql93-server/pkg-plist-server b/databases/postgresql93-server/pkg-plist-server index 809dc4d90a26..8112f5975630 100644 --- a/databases/postgresql93-server/pkg-plist-server +++ b/databases/postgresql93-server/pkg-plist-server @@ -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 diff --git a/databases/postgresql94-server/Makefile b/databases/postgresql94-server/Makefile index 7031794a7bc0..311780aa7030 100644 --- a/databases/postgresql94-server/Makefile +++ b/databases/postgresql94-server/Makefile @@ -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 diff --git a/databases/postgresql94-server/distinfo b/databases/postgresql94-server/distinfo index ef44eb94aef3..0966335e0536 100644 --- a/databases/postgresql94-server/distinfo +++ b/databases/postgresql94-server/distinfo @@ -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 diff --git a/databases/postgresql94-server/pkg-plist-server b/databases/postgresql94-server/pkg-plist-server index 572e7c029ad8..217898fa8474 100644 --- a/databases/postgresql94-server/pkg-plist-server +++ b/databases/postgresql94-server/pkg-plist-server @@ -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 diff --git a/databases/postgresql95-server/Makefile b/databases/postgresql95-server/Makefile index 4c85fcb26ade..6b0509b0a989 100644 --- a/databases/postgresql95-server/Makefile +++ b/databases/postgresql95-server/Makefile @@ -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 diff --git a/databases/postgresql95-server/distinfo b/databases/postgresql95-server/distinfo index d90c62a7e15d..2330a71bd3ed 100644 --- a/databases/postgresql95-server/distinfo +++ b/databases/postgresql95-server/distinfo @@ -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 diff --git a/databases/postgresql95-server/pkg-plist-server b/databases/postgresql95-server/pkg-plist-server index e6d0241845ce..cc194304b094 100644 --- a/databases/postgresql95-server/pkg-plist-server +++ b/databases/postgresql95-server/pkg-plist-server @@ -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 diff --git a/databases/postgresql96-server/Makefile b/databases/postgresql96-server/Makefile index a8a85e6a86de..5a54d08eb3b4 100644 --- a/databases/postgresql96-server/Makefile +++ b/databases/postgresql96-server/Makefile @@ -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 diff --git a/databases/postgresql96-server/distinfo b/databases/postgresql96-server/distinfo index ad55855c9589..2141849a33de 100644 --- a/databases/postgresql96-server/distinfo +++ b/databases/postgresql96-server/distinfo @@ -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 diff --git a/databases/postgresql96-server/pkg-plist-server b/databases/postgresql96-server/pkg-plist-server index e260dbb72409..941c7df7920a 100644 --- a/databases/postgresql96-server/pkg-plist-server +++ b/databases/postgresql96-server/pkg-plist-server @@ -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 |