From owner-svn-ports-head@freebsd.org Tue Sep 5 09:27:15 2017 Return-Path: Delivered-To: svn-ports-head@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 0298CE228D3; Tue, 5 Sep 2017 09:27:14 +0000 (UTC) (envelope-from girgen@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id BA98766747; Tue, 5 Sep 2017 09:27:14 +0000 (UTC) (envelope-from girgen@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id v859RDdY073556; Tue, 5 Sep 2017 09:27:13 GMT (envelope-from girgen@FreeBSD.org) Received: (from girgen@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id v859RBcN073537; Tue, 5 Sep 2017 09:27:11 GMT (envelope-from girgen@FreeBSD.org) Message-Id: <201709050927.v859RBcN073537@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: girgen set sender to girgen@FreeBSD.org using -f From: Palle Girgensohn Date: Tue, 5 Sep 2017 09:27:11 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r449278 - in head/databases: postgresql92-client postgresql92-contrib postgresql92-server postgresql93-client postgresql93-contrib postgresql93-server postgresql94-client postgresql94-c... X-SVN-Group: ports-head X-SVN-Commit-Author: girgen X-SVN-Commit-Paths: in head/databases: postgresql92-client postgresql92-contrib postgresql92-server postgresql93-client postgresql93-contrib postgresql93-server postgresql94-client postgresql94-contrib postgresql94-serve... X-SVN-Commit-Revision: 449278 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-head@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: SVN commit messages for the ports tree for head List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 05 Sep 2017 09:27:15 -0000 Author: girgen Date: Tue Sep 5 09:27:11 2017 New Revision: 449278 URL: https://svnweb.freebsd.org/changeset/ports/449278 Log: The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.5, 9.5.9, 9.4.14, 9.3.19, and 9.2.23. This release includes fixes that prevent a crash in pg_restore when using parallel mode. It also patches over a few other bugs reported since the last releases in August. Additionally, in 9.4.14 only, there is a fix to an issue with walsenders preventing primary-server shutdown unless immediate shutdown mode is used. Users should plan to update at the next convenient downtime. Bug Fixes and Improvements This update also fixes a number of bugs reported in the last few weeks. Some of these issues affect only version 9.6, but many affect all supported versions: * Show foreign tables in information_schema.table_privileges view. This fix applies to new databases, see the release notes for the procedure to apply the fix to an existing database. * Correctly identify columns that are of a range type or domain type over a composite type or domain type being searched for * Prevent crash when passing fixed-length pass-by-reference data types to parallel worker processes * Change ecpg’s parser to allow RETURNING clauses without attached C variables * Change ecpg’s parser to recognize backslash continuation of C preprocessor command lines * Improve selection of compiler flags for PL/Perl on Windows Modified: head/databases/postgresql92-client/Makefile head/databases/postgresql92-contrib/Makefile head/databases/postgresql92-server/Makefile head/databases/postgresql92-server/distinfo head/databases/postgresql93-client/Makefile head/databases/postgresql93-contrib/Makefile head/databases/postgresql93-server/Makefile head/databases/postgresql93-server/distinfo head/databases/postgresql94-client/Makefile head/databases/postgresql94-contrib/Makefile head/databases/postgresql94-server/Makefile head/databases/postgresql94-server/distinfo head/databases/postgresql95-client/Makefile head/databases/postgresql95-plperl/Makefile head/databases/postgresql95-server/Makefile head/databases/postgresql95-server/distinfo head/databases/postgresql96-client/Makefile head/databases/postgresql96-server/Makefile head/databases/postgresql96-server/distinfo Modified: head/databases/postgresql92-client/Makefile ============================================================================== --- head/databases/postgresql92-client/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql92-client/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME= postgresql -PORTREVISION= 2 +PORTREVISION= 0 COMMENT= PostgreSQL database (client) Modified: head/databases/postgresql92-contrib/Makefile ============================================================================== --- head/databases/postgresql92-contrib/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql92-contrib/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,6 +2,8 @@ # $FreeBSD$ PORTNAME= postgresql +PORTREVISION= 0 + CATEGORIES= databases PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} Modified: head/databases/postgresql92-server/Makefile ============================================================================== --- head/databases/postgresql92-server/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql92-server/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,8 +2,8 @@ # $FreeBSD$ PORTNAME?= postgresql -DISTVERSION?= 9.2.22 -PORTREVISION?= 1 +DISTVERSION?= 9.2.23 +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 Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql92-server/distinfo Tue Sep 5 09:27:11 2017 (r449278) @@ -1,5 +1,5 @@ -TIMESTAMP = 1502191515 -SHA256 (postgresql/postgresql-9.2.22.tar.bz2) = a70e94fa58776b559a8f7b5301371ac4922c9e3ed313ccbef20862514de7c192 -SIZE (postgresql/postgresql-9.2.22.tar.bz2) = 16531224 +TIMESTAMP = 1503997923 +SHA256 (postgresql/postgresql-9.2.23.tar.bz2) = 0e6ecdfeed69030dac8d219ecd4c350ce45e9f2caa9d73e166e407e87afec450 +SIZE (postgresql/postgresql-9.2.23.tar.bz2) = 16531436 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/postgresql93-client/Makefile ============================================================================== --- head/databases/postgresql93-client/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql93-client/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME= postgresql -PORTREVISION= 2 +PORTREVISION= 0 COMMENT= PostgreSQL database (client) Modified: head/databases/postgresql93-contrib/Makefile ============================================================================== --- head/databases/postgresql93-contrib/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql93-contrib/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,6 +2,8 @@ # $FreeBSD$ PORTNAME= postgresql +PORTREVISION= 0 + CATEGORIES= databases PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} Modified: head/databases/postgresql93-server/Makefile ============================================================================== --- head/databases/postgresql93-server/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql93-server/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -1,7 +1,8 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.3.18 +DISTVERSION?= 9.3.19 +PORTREVISION= 0 PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql93-server/distinfo ============================================================================== --- head/databases/postgresql93-server/distinfo Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql93-server/distinfo Tue Sep 5 09:27:11 2017 (r449278) @@ -1,5 +1,5 @@ -TIMESTAMP = 1502191516 -SHA256 (postgresql/postgresql-9.3.18.tar.bz2) = ad60d12a5a3dd0f6f5904c41b87e43eff49d3f74e45129fe52c5744366ff2fe0 -SIZE (postgresql/postgresql-9.3.18.tar.bz2) = 17194269 +TIMESTAMP = 1503959749 +SHA256 (postgresql/postgresql-9.3.19.tar.bz2) = fb9e872cd9e927ba331690d86bc63dcb5a596acb7a536fa0518a3c7d43ac2fb5 +SIZE (postgresql/postgresql-9.3.19.tar.bz2) = 17190203 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/postgresql94-client/Makefile ============================================================================== --- head/databases/postgresql94-client/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql94-client/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME= postgresql -PORTREVISION= 2 +PORTREVISION= 0 COMMENT= PostgreSQL database (client) Modified: head/databases/postgresql94-contrib/Makefile ============================================================================== --- head/databases/postgresql94-contrib/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql94-contrib/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,6 +2,7 @@ # $FreeBSD$ PORTNAME= postgresql +PORTREVISION= 0 CATEGORIES= databases MAINTAINER= pgsql@FreeBSD.org Modified: head/databases/postgresql94-server/Makefile ============================================================================== --- head/databases/postgresql94-server/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql94-server/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -1,7 +1,8 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.4.13 +DISTVERSION?= 9.4.14 +PORTREVISION= 0 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql94-server/distinfo ============================================================================== --- head/databases/postgresql94-server/distinfo Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql94-server/distinfo Tue Sep 5 09:27:11 2017 (r449278) @@ -1,5 +1,5 @@ -TIMESTAMP = 1502191519 -SHA256 (postgresql/postgresql-9.4.13.tar.bz2) = 0080f55d65194de8b96a2dab153443f8248ff2b2b10e6ab4cda2dcadcac7f2ab -SIZE (postgresql/postgresql-9.4.13.tar.bz2) = 17867502 +TIMESTAMP = 1503960043 +SHA256 (postgresql/postgresql-9.4.14.tar.bz2) = 8e7df23a104b057b360d03180ebcb67f645e198a4a0bee94bf56b2bc9505ec6b +SIZE (postgresql/postgresql-9.4.14.tar.bz2) = 17873740 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/postgresql95-client/Makefile ============================================================================== --- head/databases/postgresql95-client/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql95-client/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME= postgresql -PORTREVISION= 2 +PORTREVISION= 0 COMMENT= PostgreSQL database (client) Modified: head/databases/postgresql95-plperl/Makefile ============================================================================== --- head/databases/postgresql95-plperl/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql95-plperl/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME= postgresql -PORTREVISION= 1 +PORTREVIOSION= 0 CATEGORIES= databases perl5 PKGNAMESUFFIX?= ${WANT_PGSQL_VER:S/.//}${COMPONENT} Modified: head/databases/postgresql95-server/Makefile ============================================================================== --- head/databases/postgresql95-server/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql95-server/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -1,7 +1,8 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.5.8 +DISTVERSION?= 9.5.9 +PORTREVISION= 0 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql95-server/distinfo ============================================================================== --- head/databases/postgresql95-server/distinfo Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql95-server/distinfo Tue Sep 5 09:27:11 2017 (r449278) @@ -1,5 +1,5 @@ -TIMESTAMP = 1502191520 -SHA256 (postgresql/postgresql-9.5.8.tar.bz2) = ade57068f134f36710fa953e1ef79185abd96572f8098741413132f79ed37202 -SIZE (postgresql/postgresql-9.5.8.tar.bz2) = 18670910 +TIMESTAMP = 1503960043 +SHA256 (postgresql/postgresql-9.5.9.tar.bz2) = e98cd5c664ab5a05cb83618ba8078647815cb71f7a60437f0322c7518727cdd4 +SIZE (postgresql/postgresql-9.5.9.tar.bz2) = 18677113 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/postgresql96-client/Makefile ============================================================================== --- head/databases/postgresql96-client/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql96-client/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME= postgresql -PORTREVISION= 2 +PORTREVISION= 0 COMMENT= PostgreSQL database (client) Modified: head/databases/postgresql96-server/Makefile ============================================================================== --- head/databases/postgresql96-server/Makefile Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql96-server/Makefile Tue Sep 5 09:27:11 2017 (r449278) @@ -1,8 +1,8 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.6.4 -PORTREVISION?= 3 +DISTVERSION?= 9.6.5 +PORTREVISION?= 0 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql96-server/distinfo ============================================================================== --- head/databases/postgresql96-server/distinfo Tue Sep 5 09:19:57 2017 (r449277) +++ head/databases/postgresql96-server/distinfo Tue Sep 5 09:27:11 2017 (r449278) @@ -1,5 +1,5 @@ -TIMESTAMP = 1502191482 -SHA256 (postgresql/postgresql-9.6.4.tar.bz2) = 2b3ab16d82e21cead54c08b95ce3ac480696944a68603b6c11b3205b7376ce13 -SIZE (postgresql/postgresql-9.6.4.tar.bz2) = 19566875 +TIMESTAMP = 1503960044 +SHA256 (postgresql/postgresql-9.6.5.tar.bz2) = 06da12a7e3dddeb803962af8309fa06da9d6989f49e22865335f0a14bad0744c +SIZE (postgresql/postgresql-9.6.5.tar.bz2) = 19576132 SHA256 (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 85f81baa0fc8f692bcf802c8645196d9e3afdef4f760cef712d940b87655486e SIZE (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 5998