Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2018-02-08 21:53:58
Message id: 20180208205358.F2F73FB40@cvs.NetBSD.org

Log Message:
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

Files:
RevisionActionfile
1.3modifypkgsrc/databases/postgresql96/patches/patch-src_pl_plperl_plperl.h
1.2modifypkgsrc/databases/postgresql96/patches/patch-configure
1.2modifypkgsrc/databases/postgresql96/patches/patch-config_perl.m4
1.5modifypkgsrc/databases/postgresql96-server/PLIST
1.7modifypkgsrc/databases/postgresql96-docs/PLIST
1.9modifypkgsrc/databases/postgresql96/distinfo
1.12modifypkgsrc/databases/postgresql96/Makefile.common
1.3modifypkgsrc/databases/postgresql95/patches/patch-src_pl_plperl_plperl.h
1.2modifypkgsrc/databases/postgresql95/patches/patch-configure
1.2modifypkgsrc/databases/postgresql95/patches/patch-config_perl.m4
1.8modifypkgsrc/databases/postgresql95-server/PLIST
1.11modifypkgsrc/databases/postgresql95-docs/PLIST
1.13modifypkgsrc/databases/postgresql95/distinfo
1.18modifypkgsrc/databases/postgresql95/Makefile.common
1.3modifypkgsrc/databases/postgresql94/patches/patch-src_pl_plperl_plperl.h
1.2modifypkgsrc/databases/postgresql94/patches/patch-configure
1.2modifypkgsrc/databases/postgresql94/patches/patch-config_perl.m4
1.10modifypkgsrc/databases/postgresql94-server/PLIST
1.18modifypkgsrc/databases/postgresql94-docs/PLIST
1.20modifypkgsrc/databases/postgresql94/distinfo
1.24modifypkgsrc/databases/postgresql94/Makefile.common
1.3modifypkgsrc/databases/postgresql93/patches/patch-src_pl_plperl_plperl.h
1.3modifypkgsrc/databases/postgresql93/patches/patch-configure
1.2modifypkgsrc/databases/postgresql93/patches/patch-config_perl.m4
1.13modifypkgsrc/databases/postgresql93-server/PLIST
1.12modifypkgsrc/databases/postgresql93-server/Makefile
1.8modifypkgsrc/databases/postgresql93-pltcl/Makefile
1.9modifypkgsrc/databases/postgresql93-plpython/Makefile
1.14modifypkgsrc/databases/postgresql93-plperl/Makefile
1.23modifypkgsrc/databases/postgresql93-docs/PLIST
1.9modifypkgsrc/databases/postgresql93-docs/Makefile
1.3modifypkgsrc/databases/postgresql93-contrib/Makefile
1.15modifypkgsrc/databases/postgresql93-client/Makefile
1.28modifypkgsrc/databases/postgresql93/distinfo
1.32modifypkgsrc/databases/postgresql93/Makefile.common
1.2modifypkgsrc/databases/postgresql10/patches/patch-src_pl_plperl_plperl.h
1.2modifypkgsrc/databases/postgresql10/patches/patch-configure
1.2modifypkgsrc/databases/postgresql10/patches/patch-config_perl.m4
1.3modifypkgsrc/databases/postgresql10-server/PLIST
1.3modifypkgsrc/databases/postgresql10-docs/PLIST
1.2modifypkgsrc/databases/postgresql10-client/PLIST
1.4modifypkgsrc/databases/postgresql10/distinfo
1.6modifypkgsrc/databases/postgresql10/Makefile.common