postgresql: updated to 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21

This release fixes two security issues. This release also fixes issues with VACUUM, GIN indexes, and hash indexes that could lead to data corruption, as well as fixes for using parallel queries and logical replication.

Security Issues
* CVE-2018-1052: Fix the processing of partition keys containing multiple expressions
* CVE-2018-1053: Ensure that all temporary files made with "pg_upgrade" are non-world-readable

Bug Fixes and Improvements
* Fix crash and potential disclosure of backend memory when processing partition keys containing multiple expressions
* Fix potential disclosure of temporary files containing database passwords created by pg_upgrade by not allowing these files to be world-accessible
* Fix cases where VACUUM would not remove dead rows if they were updated while "key-share" locked, leading to potential data corruption
* Fix for GIN indexes to prevent bloat by ensuring the pending-insertions list is cleaned up by VACUUM
* Fix potential index corruption with hash indexes due to failure to mark metapages as dirty
* Fix several potential crash scenarios for parallel queries, including when a bitmap heap scan cannot allocate memory
* Fix several potential hang-ups in parallel queries, including when a parallel worker fails to start
* Fix collection of EXPLAIN statistics from parallel workers
* Prevent fake deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY
* Fix for trigger behavior when using logical replication
* Several fixes for "walsender" functionality to improve stability as well as visibility into the replication process
* Fix logical decoding to correctly clean up disk files for crashed transactions
* Several fixes for identity columns, including disallowing identity columns on tables derived from composite types and partitions
* Fix handling of list partitioning constraints for partition keys of boolean and array types
* Fix incorrectly generated plans for UPDATE and DELETE queries when a table has a mix of inherited regular and foreign child tables
* Fix incorrect query results from cases involving GROUPING SETS when used with flattened subqueries
* Fix UNION/INTERSECT/EXCEPT over zero columns, e.g. "SELECT UNION SELECT;"
* Several fixes for subqueries within a LATERAL subquery
* Several improvements for query planning estimation
* Allow a client that supports SCRAM channel binding, such as a future version of PostgreSQL or libpq, to connect to a PostgreSQL 10 server
* Fix sample INSTR() functions used to help transition from Oracle(r) PL/SQL to PostgreSQL PL/pgSQL to correctly match Oracle functional behavior
* Fix pg_dump to make permissions (ACL), security label, and comment entries reliably identifiable in archive outputs
* Modify behavior for contrib/cube's "cube ~> int" operator to make it compatible with KNN search. This is a backwards incompatible change and any expression indexes or materialized views using this operator will need to be reindexed and refreshed, respectively.
* Several fixes in contrib/postgres_fdw to prevent query planner errors
* Added modern examples of auto-start scripts for PostgreSQL on macOS in the contrib/start-scripts/macos directory
* Several fixes for Windows, including postmaster startup and compatibility with libperl
* Spinlock fixes and support for Motorola 68K and 88K architectures

5 files changed, 35 insertions, 35 deletions

diff --git a/databases/postgresql10/Makefile.common b/databases/postgresql10/Makefile.common
index 19d0dcab541..aedcdcb47c3 100644
--- a/databases/postgresql10/Makefile.common
+++ b/databases/postgresql10/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.5 2017/12/15 16:52:23 dholland Exp $
+# $NetBSD: Makefile.common,v 1.6 2018/02/08 20:53:56 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql10-pltcl/Makefile
 # used by databases/postgresql10-server/Makefile
 
-DISTNAME=	postgresql-10.1
+DISTNAME=	postgresql-10.2
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql10/distinfo b/databases/postgresql10/distinfo
index becc95dc256..8cc51f463d1 100644
--- a/databases/postgresql10/distinfo
+++ b/databases/postgresql10/distinfo
@@ -1,12 +1,12 @@
-$NetBSD: distinfo,v 1.3 2018/01/22 11:05:29 jperkin Exp $
+$NetBSD: distinfo,v 1.4 2018/02/08 20:53:56 adam Exp $
 
-SHA1 (postgresql-10.1.tar.bz2) = 4adcfd527ec1652ecd7a22eb71541928d3d37277
-RMD160 (postgresql-10.1.tar.bz2) = 4238ae067e5e282ee36302d596ea0654dd9e96b8
-SHA512 (postgresql-10.1.tar.bz2) = 06050d353aa43f32e0de0199d833d8a4652aff893b718b1c40ed31837838f73fe4d977ac0f2164ab97b3eeff4aae3409f440601740898a893877d96bc0ed1882
-Size (postgresql-10.1.tar.bz2) = 19669989 bytes
+SHA1 (postgresql-10.2.tar.bz2) = b0597de368dac410cfb65ce92f89e324bbdc1ea1
+RMD160 (postgresql-10.2.tar.bz2) = fb755e381c32452959a9351570c1917b6fe596ba
+SHA512 (postgresql-10.2.tar.bz2) = bac61644c12c31e2dce97ec0134902a2a7141e922619015425961b963961b21210ca840f59ba585d3d75c7e34cb640f2ebeaa2b25c4a866db68f5e73a8f8a448
+Size (postgresql-10.2.tar.bz2) = 19901836 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
-SHA1 (patch-config_perl.m4) = e035132b1c281a75752d570ac5e29a11176c25c5
-SHA1 (patch-configure) = 59fe9a768caf8a5d308acac60c28bc6bb2c40632
+SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
+SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
 SHA1 (patch-contrib_dblink_dblink.c) = a6f87ab9f2c28a72608d70267b71bd77437b0921
 SHA1 (patch-src_Makefile.global.in) = 335b57afff23a9684ab0a09257665810c1ba2d1e
 SHA1 (patch-src_Makefile.shlib) = 6363b3c7c6887c7b23295da7ebf0371e1be2d93d
@@ -16,4 +16,4 @@ SHA1 (patch-src_interfaces_ecpg_pgtypeslib_interval.c) = a15012ae34d4ecd1eb2bc29
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 0168f5bc105ffc89d5db40907a08966d8465f5a0
 SHA1 (patch-src_pl_plperl_GNUmakefile) = 6ee3e431f46ce5c2a94df499504b2b8bd458bbef
-SHA1 (patch-src_pl_plperl_plperl.h) = 0e7daec79a00d7378326e56525e50cfe61cfc174
+SHA1 (patch-src_pl_plperl_plperl.h) = 64d5b891362c114bde5ec48e48bc4855b56ab516
diff --git a/databases/postgresql10/patches/patch-config_perl.m4 b/databases/postgresql10/patches/patch-config_perl.m4
index 6662d1036f2..7ed640fde4d 100644
--- a/databases/postgresql10/patches/patch-config_perl.m4
+++ b/databases/postgresql10/patches/patch-config_perl.m4
@@ -1,15 +1,15 @@
-$NetBSD: patch-config_perl.m4,v 1.1 2017/10/23 20:33:49 adam Exp $
+$NetBSD: patch-config_perl.m4,v 1.2 2018/02/08 20:53:56 adam Exp $
 
---- config/perl.m4.orig	2013-09-02 20:53:17.000000000 +0000
+--- config/perl.m4.orig	2018-02-05 21:01:02.000000000 +0000
 +++ config/perl.m4
-@@ -62,9 +62,7 @@ if test "$PORTNAME" = "win32" ; then
- perl_lib=`basename $perl_archlibexp/CORE/perl[[5-9]]*.lib .lib`
- test -e "$perl_archlibexp/CORE/$perl_lib.lib" && perl_embed_ldflags="-L$perl_archlibexp/CORE -l$perl_lib"
+@@ -97,9 +97,7 @@ if test "$PORTNAME" = "win32" ; then
+ 		fi
+ 	fi
  else
--pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
--pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
--perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e ["s/ -arch [-a-zA-Z0-9_]*//g"]`
-+perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
+-	pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
+-	pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
+-	perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e ["s/ -arch [-a-zA-Z0-9_]*//g"]`
++	perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
  fi
  AC_SUBST(perl_embed_ldflags)dnl
  if test -z "$perl_embed_ldflags" ; then
diff --git a/databases/postgresql10/patches/patch-configure b/databases/postgresql10/patches/patch-configure
index cc8fadae207..f407620a943 100644
--- a/databases/postgresql10/patches/patch-configure
+++ b/databases/postgresql10/patches/patch-configure
@@ -1,10 +1,10 @@
-$NetBSD: patch-configure,v 1.1 2017/10/23 20:33:49 adam Exp $
+$NetBSD: patch-configure,v 1.2 2018/02/08 20:53:56 adam Exp $
 
 Finally, native solaris uses -lgss for gssapi on mit-krb5.
 
---- configure.orig	2014-12-16 01:07:34.000000000 +0000
+--- configure.orig	2018-02-05 21:01:02.000000000 +0000
 +++ configure
-@@ -2852,6 +2852,7 @@ case $host_os in
+@@ -2879,6 +2879,7 @@ case $host_os in
    darwin*) template=darwin ;;
  dragonfly*) template=netbsd ;;
   freebsd*) template=freebsd ;;
@@ -12,18 +12,18 @@ Finally, native solaris uses -lgss for gssapi on mit-krb5.
      hpux*) template=hpux ;;
   linux*|gnu*|k*bsd*-gnu)
             template=linux ;;
-@@ -7310,9 +7311,7 @@ if test "$PORTNAME" = "win32" ; then
- perl_lib=`basename $perl_archlibexp/CORE/perl[5-9]*.lib .lib`
- test -e "$perl_archlibexp/CORE/$perl_lib.lib" && perl_embed_ldflags="-L$perl_archlibexp/CORE -l$perl_lib"
+@@ -7884,9 +7885,7 @@ if test "$PORTNAME" = "win32" ; then
+ 		fi
+ 	fi
  else
--pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
--pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
--perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e "s/ -arch [-a-zA-Z0-9_]*//g"`
-+perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
+-	pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
+-	pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
+-	perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e "s/ -arch [-a-zA-Z0-9_]*//g"`
++	perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
  fi
  if test -z "$perl_embed_ldflags" ; then
  	{ $as_echo "$as_me:${as_lineno-$LINENO}: result: no" >&5
-@@ -8407,7 +8406,7 @@ return gss_init_sec_context ();
+@@ -9928,7 +9927,7 @@ return gss_init_sec_context ();
    return 0;
  }
  _ACEOF
diff --git a/databases/postgresql10/patches/patch-src_pl_plperl_plperl.h b/databases/postgresql10/patches/patch-src_pl_plperl_plperl.h
index b10cbb5d60f..c4cd04a47fc 100644
--- a/databases/postgresql10/patches/patch-src_pl_plperl_plperl.h
+++ b/databases/postgresql10/patches/patch-src_pl_plperl_plperl.h
@@ -1,9 +1,9 @@
-$NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2017/10/23 20:33:49 adam Exp $
+$NetBSD: patch-src_pl_plperl_plperl.h,v 1.2 2018/02/08 20:53:56 adam Exp $
 
---- src/pl/plperl/plperl.h.orig	2017-08-07 21:19:50.000000000 +0000
+--- src/pl/plperl/plperl.h.orig	2018-02-05 21:01:02.000000000 +0000
 +++ src/pl/plperl/plperl.h
-@@ -44,6 +44,10 @@
- #undef vsnprintf
+@@ -50,6 +50,10 @@
+ #define __inline__ inline
  #endif
  
 +#ifdef __sun
@@ -13,7 +13,7 @@ $NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2017/10/23 20:33:49 adam Exp $
  
  /*
   * Get the basic Perl API.  We use PERL_NO_GET_CONTEXT mode so that our code
-@@ -62,6 +66,11 @@
+@@ -68,6 +72,11 @@
  #include "XSUB.h"
  #endif