svn commit: r442755 - in branches/2017Q2/databases: postgresql92-server postgresql92-server/files postgresql93-server postgresql93-server/files postgresql94-server postgresql94-server/files postgre...

Tue Jun 6 10:59:51 UTC 2017

Author: tz
Date: Tue Jun  6 10:59:48 2017
New Revision: 442755
URL: https://svnweb.freebsd.org/changeset/ports/442755

Log:
  MFH: r440628
  
  PostgreSQL security updates
  
  The PostgreSQL Global Development Group has released an update to all supported
  versions of our database system, including 9.6.3, 9.5.7, 9.4.12, 9.3.17, and
  9.2.21. This release fixes three security issues. It also patches a number of
  other bugs reported over the last three months. Users who use the PGREQUIRESSL
  environment variable to control connections, and users who rely on security
  isolation between database users when using foreign servers, should update as
  soon as possible. Other users should plan to update at the next convenient
  downtime.
  
  URL:    https://www.postgresql.org/about/news/1746/
  Security:       CVE-2017-7484, CVE-2017-7485, CVE-2017-7486
  
  Also modify rcorder and let sshd start before PostgreSQL, so any problems
  during startup can be reviewed promplty from an ssh login.
  
  Approved by: ports-secteam (miwi)

Modified:
  branches/2017Q2/databases/postgresql92-server/Makefile
  branches/2017Q2/databases/postgresql92-server/distinfo
  branches/2017Q2/databases/postgresql92-server/files/postgresql.in
  branches/2017Q2/databases/postgresql92-server/pkg-plist-server
  branches/2017Q2/databases/postgresql93-server/Makefile
  branches/2017Q2/databases/postgresql93-server/distinfo
  branches/2017Q2/databases/postgresql93-server/files/postgresql.in
  branches/2017Q2/databases/postgresql93-server/pkg-plist-server
  branches/2017Q2/databases/postgresql94-server/Makefile
  branches/2017Q2/databases/postgresql94-server/distinfo
  branches/2017Q2/databases/postgresql94-server/files/postgresql.in
  branches/2017Q2/databases/postgresql94-server/pkg-plist-client
  branches/2017Q2/databases/postgresql94-server/pkg-plist-server
  branches/2017Q2/databases/postgresql95-server/Makefile
  branches/2017Q2/databases/postgresql95-server/distinfo
  branches/2017Q2/databases/postgresql95-server/files/postgresql.in
  branches/2017Q2/databases/postgresql95-server/pkg-plist-client
  branches/2017Q2/databases/postgresql95-server/pkg-plist-server
  branches/2017Q2/databases/postgresql96-server/Makefile
  branches/2017Q2/databases/postgresql96-server/distinfo
  branches/2017Q2/databases/postgresql96-server/files/postgresql.in
  branches/2017Q2/databases/postgresql96-server/pkg-plist-client
  branches/2017Q2/databases/postgresql96-server/pkg-plist-server
Directory Properties:
  branches/2017Q2/   (props changed)

Modified: branches/2017Q2/databases/postgresql92-server/Makefile
==============================================================================

--- branches/2017Q2/databases/postgresql92-server/Makefile	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql92-server/Makefile	Tue Jun  6 10:59:48 2017	(r442755)
@@ -2,7 +2,7 @@
 # $FreeBSD$
 
 PORTNAME?=	postgresql
-DISTVERSION?=	9.2.20
+DISTVERSION?=	9.2.21
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	PGSQL/source/v${DISTVERSION}

Modified: branches/2017Q2/databases/postgresql92-server/distinfo
==============================================================================
--- branches/2017Q2/databases/postgresql92-server/distinfo	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql92-server/distinfo	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,5 +1,5 @@
-TIMESTAMP = 1486640625
-SHA256 (postgresql/postgresql-9.2.20.tar.bz2) = 0b8abdae8400cabea5587a726003c9dd71c73c049bdae523abc35f9312dd8f26
-SIZE (postgresql/postgresql-9.2.20.tar.bz2) = 16480653
+TIMESTAMP = 1494282359
+SHA256 (postgresql/postgresql-9.2.21.tar.bz2) = 0697e843523ee60c563f987f9c65bc4201294b18525d6e5e4b2c50c6d4058ef9
+SIZE (postgresql/postgresql-9.2.21.tar.bz2) = 16508040
 SHA256 (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 2f9c831b3dff866f0b2f6f2a9ef771a4045486bc252a851aadc73c50d376319d
 SIZE (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 5587

Modified: branches/2017Q2/databases/postgresql92-server/files/postgresql.in
==============================================================================
--- branches/2017Q2/databases/postgresql92-server/files/postgresql.in	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql92-server/files/postgresql.in	Tue Jun  6 10:59:48 2017	(r442755)
@@ -3,7 +3,7 @@
 # $FreeBSD$
 #
 # PROVIDE: postgresql
-# REQUIRE: LOGIN
+# REQUIRE: sshd
 # KEYWORD: shutdown
 #
 # Add the following line to /etc/rc.conf to enable PostgreSQL:

Modified: branches/2017Q2/databases/postgresql92-server/pkg-plist-server
==============================================================================
--- branches/2017Q2/databases/postgresql92-server/pkg-plist-server	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql92-server/pkg-plist-server	Tue Jun  6 10:59:48 2017	(r442755)
@@ -324,6 +324,7 @@ lib/postgresql/utf8_and_win.so
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Acre
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Velho
 %%TZDATA%%%%DATADIR%%/timezone/America/Puerto_Rico
+%%TZDATA%%%%DATADIR%%/timezone/America/Punta_Arenas
 %%TZDATA%%%%DATADIR%%/timezone/America/Rainy_River
 %%TZDATA%%%%DATADIR%%/timezone/America/Rankin_Inlet
 %%TZDATA%%%%DATADIR%%/timezone/America/Recife

Modified: branches/2017Q2/databases/postgresql93-server/Makefile
==============================================================================
--- branches/2017Q2/databases/postgresql93-server/Makefile	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql93-server/Makefile	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,7 +1,7 @@
 # Created by: Marc G. Fournier <scrappy at FreeBSD.org>
 # $FreeBSD$
 
-DISTVERSION?=	9.3.16
+DISTVERSION?=	9.3.17
 PKGNAMESUFFIX?=	${DISTVERSION:R:S/.//}${COMPONENT}
 
 MAINTAINER?=	pgsql at FreeBSD.org

Modified: branches/2017Q2/databases/postgresql93-server/distinfo
==============================================================================
--- branches/2017Q2/databases/postgresql93-server/distinfo	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql93-server/distinfo	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,5 +1,5 @@
-TIMESTAMP = 1486640625
-SHA256 (postgresql/postgresql-9.3.16.tar.bz2) = 845f5e4ac8cf026b6a77c5a180a2fe869f51e9d06acf8d0365b05505a2c66873
-SIZE (postgresql/postgresql-9.3.16.tar.bz2) = 17108969
+TIMESTAMP = 1494282359
+SHA256 (postgresql/postgresql-9.3.17.tar.bz2) = 9c03e5f280cfe9bd202fa01af773eb146abd8ab3065f7279d574c568f6948dbe
+SIZE (postgresql/postgresql-9.3.17.tar.bz2) = 17158802
 SHA256 (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 4be31ad9899d5caf9f57ad7ebfc0d14f0fcf58ad539c82fb353b016fb76c0c30
 SIZE (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 5583

Modified: branches/2017Q2/databases/postgresql93-server/files/postgresql.in
==============================================================================
--- branches/2017Q2/databases/postgresql93-server/files/postgresql.in	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql93-server/files/postgresql.in	Tue Jun  6 10:59:48 2017	(r442755)
@@ -3,7 +3,7 @@
 # $FreeBSD$
 #
 # PROVIDE: postgresql
-# REQUIRE: LOGIN
+# REQUIRE: sshd
 # KEYWORD: shutdown
 #
 # Add the following line to /etc/rc.conf to enable PostgreSQL:

Modified: branches/2017Q2/databases/postgresql93-server/pkg-plist-server
==============================================================================
--- branches/2017Q2/databases/postgresql93-server/pkg-plist-server	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql93-server/pkg-plist-server	Tue Jun  6 10:59:48 2017	(r442755)
@@ -313,6 +313,7 @@ lib/libpgcommon.a
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Acre
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Velho
 %%TZDATA%%%%DATADIR%%/timezone/America/Puerto_Rico
+%%TZDATA%%%%DATADIR%%/timezone/America/Punta_Arenas
 %%TZDATA%%%%DATADIR%%/timezone/America/Rainy_River
 %%TZDATA%%%%DATADIR%%/timezone/America/Rankin_Inlet
 %%TZDATA%%%%DATADIR%%/timezone/America/Recife

Modified: branches/2017Q2/databases/postgresql94-server/Makefile
==============================================================================
--- branches/2017Q2/databases/postgresql94-server/Makefile	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql94-server/Makefile	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,7 +1,7 @@
 # Created by: Marc G. Fournier <scrappy at FreeBSD.org>
 # $FreeBSD$
 
-DISTVERSION?=	9.4.11
+DISTVERSION?=	9.4.12
 
 MAINTAINER?=	pgsql at FreeBSD.org
 

Modified: branches/2017Q2/databases/postgresql94-server/distinfo
==============================================================================
--- branches/2017Q2/databases/postgresql94-server/distinfo	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql94-server/distinfo	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,5 +1,5 @@
-TIMESTAMP = 1486640625
-SHA256 (postgresql/postgresql-9.4.11.tar.bz2) = e3eb51d045c180b03d2de1f0c3af9356e10be49448e966ca01dfc2c6d1cc9d23
-SIZE (postgresql/postgresql-9.4.11.tar.bz2) = 17832915
+TIMESTAMP = 1494282360
+SHA256 (postgresql/postgresql-9.4.12.tar.bz2) = fca055481875d1c49e31c28443f56472a1474b3fbe25b7ae64440c6118f82e64
+SIZE (postgresql/postgresql-9.4.12.tar.bz2) = 17833119
 SHA256 (postgresql/pg-949-icu-2016-10-02.diff.gz) = 34612e685a79874db04bc6b66c700bfc6412042840c532eef0da7832d1f70d43
 SIZE (postgresql/pg-949-icu-2016-10-02.diff.gz) = 5289

Modified: branches/2017Q2/databases/postgresql94-server/files/postgresql.in
==============================================================================
--- branches/2017Q2/databases/postgresql94-server/files/postgresql.in	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql94-server/files/postgresql.in	Tue Jun  6 10:59:48 2017	(r442755)
@@ -3,7 +3,7 @@
 # $FreeBSD$
 #
 # PROVIDE: postgresql
-# REQUIRE: LOGIN
+# REQUIRE: sshd
 # KEYWORD: shutdown
 #
 # Add the following line to /etc/rc.conf to enable PostgreSQL:

Modified: branches/2017Q2/databases/postgresql94-server/pkg-plist-client
==============================================================================
--- branches/2017Q2/databases/postgresql94-server/pkg-plist-client	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql94-server/pkg-plist-client	Tue Jun  6 10:59:48 2017	(r442755)
@@ -192,6 +192,7 @@ include/postgresql/server/commands/vacuum.h
 include/postgresql/server/commands/variable.h
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/fe_memutils.h
+include/postgresql/server/common/int128.h
 include/postgresql/server/common/relpath.h
 include/postgresql/server/common/string.h
 include/postgresql/server/common/username.h

Modified: branches/2017Q2/databases/postgresql94-server/pkg-plist-server
==============================================================================
--- branches/2017Q2/databases/postgresql94-server/pkg-plist-server	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql94-server/pkg-plist-server	Tue Jun  6 10:59:48 2017	(r442755)
@@ -314,6 +314,7 @@ lib/libpgcommon.a
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Acre
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Velho
 %%TZDATA%%%%DATADIR%%/timezone/America/Puerto_Rico
+%%TZDATA%%%%DATADIR%%/timezone/America/Punta_Arenas
 %%TZDATA%%%%DATADIR%%/timezone/America/Rainy_River
 %%TZDATA%%%%DATADIR%%/timezone/America/Rankin_Inlet
 %%TZDATA%%%%DATADIR%%/timezone/America/Recife

Modified: branches/2017Q2/databases/postgresql95-server/Makefile
==============================================================================
--- branches/2017Q2/databases/postgresql95-server/Makefile	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql95-server/Makefile	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,7 +1,7 @@
 # Created by: Marc G. Fournier <scrappy at FreeBSD.org>
 # $FreeBSD$
 
-DISTVERSION?=	9.5.6
+DISTVERSION?=	9.5.7
 
 MAINTAINER?=	pgsql at FreeBSD.org
 

Modified: branches/2017Q2/databases/postgresql95-server/distinfo
==============================================================================
--- branches/2017Q2/databases/postgresql95-server/distinfo	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql95-server/distinfo	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,5 +1,5 @@
-TIMESTAMP = 1486640626
-SHA256 (postgresql/postgresql-9.5.6.tar.bz2) = bb9e5f6d34e20783e96e10c1d6c0c09c31749e802aaa46b793ce2522725ae12f
-SIZE (postgresql/postgresql-9.5.6.tar.bz2) = 18598551
+TIMESTAMP = 1494282360
+SHA256 (postgresql/postgresql-9.5.7.tar.bz2) = 8b1e936f82109325decc0f5575e846b93fb4fd384e8c4bde83ff5e7f87fc6cad
+SIZE (postgresql/postgresql-9.5.7.tar.bz2) = 18639775
 SHA256 (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5fa083ec38087d6a0961642208f012e902221270708b919b92e9eedaa755e365
 SIZE (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5952

Modified: branches/2017Q2/databases/postgresql95-server/files/postgresql.in
==============================================================================
--- branches/2017Q2/databases/postgresql95-server/files/postgresql.in	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql95-server/files/postgresql.in	Tue Jun  6 10:59:48 2017	(r442755)
@@ -3,7 +3,7 @@
 # $FreeBSD$
 #
 # PROVIDE: postgresql
-# REQUIRE: LOGIN
+# REQUIRE: sshd
 # KEYWORD: shutdown
 #
 # Add the following line to /etc/rc.conf to enable PostgreSQL:

Modified: branches/2017Q2/databases/postgresql95-server/pkg-plist-client
==============================================================================
--- branches/2017Q2/databases/postgresql95-server/pkg-plist-client	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql95-server/pkg-plist-client	Tue Jun  6 10:59:48 2017	(r442755)
@@ -213,6 +213,7 @@ include/postgresql/server/commands/vacuum.h
 include/postgresql/server/commands/variable.h
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/fe_memutils.h
+include/postgresql/server/common/int128.h
 include/postgresql/server/common/pg_lzcompress.h
 include/postgresql/server/common/relpath.h
 include/postgresql/server/common/restricted_token.h

Modified: branches/2017Q2/databases/postgresql95-server/pkg-plist-server
==============================================================================
--- branches/2017Q2/databases/postgresql95-server/pkg-plist-server	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql95-server/pkg-plist-server	Tue Jun  6 10:59:48 2017	(r442755)
@@ -335,6 +335,7 @@ lib/libpgcommon.a
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Acre
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Velho
 %%TZDATA%%%%DATADIR%%/timezone/America/Puerto_Rico
+%%TZDATA%%%%DATADIR%%/timezone/America/Punta_Arenas
 %%TZDATA%%%%DATADIR%%/timezone/America/Rainy_River
 %%TZDATA%%%%DATADIR%%/timezone/America/Rankin_Inlet
 %%TZDATA%%%%DATADIR%%/timezone/America/Recife

Modified: branches/2017Q2/databases/postgresql96-server/Makefile
==============================================================================
--- branches/2017Q2/databases/postgresql96-server/Makefile	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql96-server/Makefile	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,7 +1,7 @@
 # Created by: Marc G. Fournier <scrappy at FreeBSD.org>
 # $FreeBSD$
 
-DISTVERSION?=	9.6.2
+DISTVERSION?=	9.6.3
 
 MAINTAINER?=	pgsql at FreeBSD.org
 

Modified: branches/2017Q2/databases/postgresql96-server/distinfo
==============================================================================
--- branches/2017Q2/databases/postgresql96-server/distinfo	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql96-server/distinfo	Tue Jun  6 10:59:48 2017	(r442755)
@@ -1,5 +1,5 @@
-TIMESTAMP = 1486640626
-SHA256 (postgresql/postgresql-9.6.2.tar.bz2) = 0187b5184be1c09034e74e44761505e52357248451b0c854dddec6c231fe50c9
-SIZE (postgresql/postgresql-9.6.2.tar.bz2) = 19478040
+TIMESTAMP = 1494282361
+SHA256 (postgresql/postgresql-9.6.3.tar.bz2) = 1645b3736901f6d854e695a937389e68ff2066ce0cde9d73919d6ab7c995b9c6
+SIZE (postgresql/postgresql-9.6.3.tar.bz2) = 19534323
 SHA256 (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 85f81baa0fc8f692bcf802c8645196d9e3afdef4f760cef712d940b87655486e
 SIZE (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 5998

Modified: branches/2017Q2/databases/postgresql96-server/files/postgresql.in
==============================================================================
--- branches/2017Q2/databases/postgresql96-server/files/postgresql.in	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql96-server/files/postgresql.in	Tue Jun  6 10:59:48 2017	(r442755)
@@ -3,7 +3,7 @@
 # $FreeBSD$
 #
 # PROVIDE: postgresql
-# REQUIRE: LOGIN
+# REQUIRE: sshd
 # KEYWORD: shutdown
 #
 # Add the following line to /etc/rc.conf to enable PostgreSQL:

Modified: branches/2017Q2/databases/postgresql96-server/pkg-plist-client
==============================================================================
--- branches/2017Q2/databases/postgresql96-server/pkg-plist-client	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql96-server/pkg-plist-client	Tue Jun  6 10:59:48 2017	(r442755)
@@ -221,6 +221,7 @@ include/postgresql/server/commands/view.h
 include/postgresql/server/common/config_info.h
 include/postgresql/server/common/controldata_utils.h
 include/postgresql/server/common/fe_memutils.h
+include/postgresql/server/common/int128.h
 include/postgresql/server/common/keywords.h
 include/postgresql/server/common/pg_lzcompress.h
 include/postgresql/server/common/relpath.h

Modified: branches/2017Q2/databases/postgresql96-server/pkg-plist-server
==============================================================================
--- branches/2017Q2/databases/postgresql96-server/pkg-plist-server	Tue Jun  6 09:56:50 2017	(r442754)
+++ branches/2017Q2/databases/postgresql96-server/pkg-plist-server	Tue Jun  6 10:59:48 2017	(r442755)
@@ -337,6 +337,7 @@ lib/libpgcommon.a
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Acre
 %%TZDATA%%%%DATADIR%%/timezone/America/Porto_Velho
 %%TZDATA%%%%DATADIR%%/timezone/America/Puerto_Rico
+%%TZDATA%%%%DATADIR%%/timezone/America/Punta_Arenas
 %%TZDATA%%%%DATADIR%%/timezone/America/Rainy_River
 %%TZDATA%%%%DATADIR%%/timezone/America/Rankin_Inlet
 %%TZDATA%%%%DATADIR%%/timezone/America/Recife
