Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2023-11-13 21:22:09
Message id: 20231113202210.492B4FA3D@cvs.NetBSD.org

Log Message:
postgresql: updated to 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22

Security Issues

CVE-2023-5868: Memory disclosure in aggregate function calls
CVE-2023-5869: Buffer overrun from integer overflow in array modification
CVE-2023-5870: Role pg_signal_backend can signal certain superuser processes

Bug Fixes and Improvements

This update fixes over 55 bugs that were reported in the last several months. \ 
The issues listed below affect PostgreSQL 16. Some of these issues may also \ 
affect other supported versions of PostgreSQL.

Fix issue where GiST indexes had an incorrect behavior during a "page \ 
split" operation that could lead to incorrect results in subsequent index \ 
searches. Please reindex GiST indexes after installing this update.
Fix issue where B-tree indexes would incorrectly de-duplicate interval columns. \ 
Please reindex any B-tree index that includes an interval column after \ 
installing this update.
Provide more efficient indexing of date, timestamptz, and timestamp values in \ 
BRIN indexes when using a minmax_multi opsclass. While not required, we \ 
recommend reindexing BRIN indexes that include these data types after installing \ 
this update.
Fix for bulk table insertion into partitioned tables.
Fix for hash-partitioned tables with multiple partition keys during step \ 
generation and runtime pruning that could lead to crashes in some cases.
Throw the correct error if pgrowlocks() is applied to a partitioned table

Fix inconsistent rechecking of concurrently-updated rows during MERGE when using \ 
READ COMMITTED mode.

Correctly identify the target table in an inherited UPDATE/DELETE/MERGE even \ 
when the parent table is excluded by constraints.
Fix over-allocation of a constructed tsvector.
Fix ALTER SUBSCRIPTION to apply changes in the run_as_owner option.
Several fixes for COPY FROM,
Several fixes for handling torn reads with pg_control.
Fix "could not find pathkey item to sort" errors occurring while \ 
planning aggregate functions with ORDER BY or DISTINCT options.
When track_io_timing is enabled, include the time taken by relation extension \ 
operations as write time.
Track the dependencies of cached CALL statements, and re-plan them when needed.
Treat out-of-memory failures as FATAL while reading WAL.
Fix pg_dump to dump the new run_as_owner option of subscriptions.
Fix pg_restore so that selective restores will include both table-level and \ 
column-level ACLs for selected tables.
Add logic to pg_upgrade to check for use of obsolete data types abstime, \ 
reltime, and tinterval.
Fix vacuumdb to have multiple -N switches actually exclude tables in multiple \ 
schemas.
amcheck will no longer report interrupted page deletion as corruption.
Fix btree_gin indexes on interval columns to properly return data when using the \ 
< and <= operators.

Files:
RevisionActionfile
1.33modifypkgsrc/databases/postgresql11/Makefile
1.35modifypkgsrc/databases/postgresql11/Makefile.common
1.29modifypkgsrc/databases/postgresql11/distinfo
1.33modifypkgsrc/databases/postgresql11-client/Makefile
1.30modifypkgsrc/databases/postgresql11-contrib/Makefile
1.24modifypkgsrc/databases/postgresql11-docs/Makefile
1.23modifypkgsrc/databases/postgresql11-docs/PLIST
1.30modifypkgsrc/databases/postgresql11-plperl/Makefile
1.33modifypkgsrc/databases/postgresql11-plpython/Makefile
1.28modifypkgsrc/databases/postgresql11-pltcl/Makefile
1.31modifypkgsrc/databases/postgresql11-server/Makefile
1.32modifypkgsrc/databases/postgresql12/Makefile
1.28modifypkgsrc/databases/postgresql12/Makefile.common
1.22modifypkgsrc/databases/postgresql12/distinfo
1.35modifypkgsrc/databases/postgresql12-client/Makefile
1.30modifypkgsrc/databases/postgresql12-contrib/Makefile
1.24modifypkgsrc/databases/postgresql12-docs/Makefile
1.18modifypkgsrc/databases/postgresql12-docs/PLIST
1.30modifypkgsrc/databases/postgresql12-plperl/Makefile
1.31modifypkgsrc/databases/postgresql12-plpython/Makefile
1.28modifypkgsrc/databases/postgresql12-pltcl/Makefile
1.30modifypkgsrc/databases/postgresql12-server/Makefile
1.23modifypkgsrc/databases/postgresql13/Makefile
1.21modifypkgsrc/databases/postgresql13/Makefile.common
1.20modifypkgsrc/databases/postgresql13/distinfo
1.29modifypkgsrc/databases/postgresql13-client/Makefile
1.23modifypkgsrc/databases/postgresql13-contrib/Makefile
1.20modifypkgsrc/databases/postgresql13-docs/Makefile
1.14modifypkgsrc/databases/postgresql13-docs/PLIST
1.25modifypkgsrc/databases/postgresql13-plperl/Makefile
1.25modifypkgsrc/databases/postgresql13-plpython/Makefile
1.22modifypkgsrc/databases/postgresql13-pltcl/Makefile
1.22modifypkgsrc/databases/postgresql13-server/Makefile
1.18modifypkgsrc/databases/postgresql14/Makefile
1.13modifypkgsrc/databases/postgresql14/Makefile.common
1.13modifypkgsrc/databases/postgresql14/distinfo
1.19modifypkgsrc/databases/postgresql14-client/Makefile
1.15modifypkgsrc/databases/postgresql14-contrib/Makefile
1.15modifypkgsrc/databases/postgresql14-docs/Makefile
1.11modifypkgsrc/databases/postgresql14-docs/PLIST
1.18modifypkgsrc/databases/postgresql14-plperl/Makefile
1.17modifypkgsrc/databases/postgresql14-plpython/Makefile
1.15modifypkgsrc/databases/postgresql14-pltcl/Makefile
1.15modifypkgsrc/databases/postgresql14-server/Makefile
1.9modifypkgsrc/databases/postgresql15/Makefile
1.7modifypkgsrc/databases/postgresql15/Makefile.common
1.6modifypkgsrc/databases/postgresql15/distinfo
1.2modifypkgsrc/databases/postgresql15/options.mk
1.8modifypkgsrc/databases/postgresql15-client/Makefile
1.8modifypkgsrc/databases/postgresql15-contrib/Makefile
1.8modifypkgsrc/databases/postgresql15-docs/Makefile
1.6modifypkgsrc/databases/postgresql15-docs/PLIST
1.10modifypkgsrc/databases/postgresql15-plperl/Makefile
1.9modifypkgsrc/databases/postgresql15-plpython/Makefile
1.8modifypkgsrc/databases/postgresql15-pltcl/Makefile
1.8modifypkgsrc/databases/postgresql15-server/Makefile
1.5modifypkgsrc/databases/postgresql15-server/PLIST
1.4modifypkgsrc/databases/postgresql16/Makefile
1.3modifypkgsrc/databases/postgresql16/Makefile.common
1.2modifypkgsrc/databases/postgresql16/distinfo
1.4modifypkgsrc/databases/postgresql16-client/Makefile
1.2modifypkgsrc/databases/postgresql16-client/PLIST
1.4modifypkgsrc/databases/postgresql16-contrib/Makefile
1.3modifypkgsrc/databases/postgresql16-docs/Makefile
1.2modifypkgsrc/databases/postgresql16-docs/PLIST
1.4modifypkgsrc/databases/postgresql16-plperl/Makefile
1.4modifypkgsrc/databases/postgresql16-plpython/Makefile
1.2modifypkgsrc/databases/postgresql16-plpython/PLIST
1.4modifypkgsrc/databases/postgresql16-pltcl/Makefile
1.4modifypkgsrc/databases/postgresql16-server/Makefile