Path to this page:
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: