--- - branch: MAIN date: Mon Nov 13 20:22:09 UTC 2023 files: - new: '1.33' old: '1.32' path: pkgsrc/databases/postgresql11/Makefile pathrev: pkgsrc/databases/postgresql11/Makefile@1.33 type: modified - new: '1.35' old: '1.34' path: pkgsrc/databases/postgresql11/Makefile.common pathrev: pkgsrc/databases/postgresql11/Makefile.common@1.35 type: modified - new: '1.29' old: '1.28' path: pkgsrc/databases/postgresql11/distinfo pathrev: pkgsrc/databases/postgresql11/distinfo@1.29 type: modified - new: '1.33' old: '1.32' path: pkgsrc/databases/postgresql11-client/Makefile pathrev: pkgsrc/databases/postgresql11-client/Makefile@1.33 type: modified - new: '1.30' old: '1.29' path: pkgsrc/databases/postgresql11-contrib/Makefile pathrev: pkgsrc/databases/postgresql11-contrib/Makefile@1.30 type: modified - new: '1.24' old: '1.23' path: pkgsrc/databases/postgresql11-docs/Makefile pathrev: pkgsrc/databases/postgresql11-docs/Makefile@1.24 type: modified - new: '1.23' old: '1.22' path: pkgsrc/databases/postgresql11-docs/PLIST pathrev: pkgsrc/databases/postgresql11-docs/PLIST@1.23 type: modified - new: '1.30' old: '1.29' path: pkgsrc/databases/postgresql11-plperl/Makefile pathrev: pkgsrc/databases/postgresql11-plperl/Makefile@1.30 type: modified - new: '1.33' old: '1.32' path: pkgsrc/databases/postgresql11-plpython/Makefile pathrev: pkgsrc/databases/postgresql11-plpython/Makefile@1.33 type: modified - new: '1.28' old: '1.27' path: pkgsrc/databases/postgresql11-pltcl/Makefile pathrev: pkgsrc/databases/postgresql11-pltcl/Makefile@1.28 type: modified - new: '1.31' old: '1.30' path: pkgsrc/databases/postgresql11-server/Makefile pathrev: pkgsrc/databases/postgresql11-server/Makefile@1.31 type: modified - new: '1.32' old: '1.31' path: pkgsrc/databases/postgresql12/Makefile pathrev: pkgsrc/databases/postgresql12/Makefile@1.32 type: modified - new: '1.28' old: '1.27' path: pkgsrc/databases/postgresql12/Makefile.common pathrev: pkgsrc/databases/postgresql12/Makefile.common@1.28 type: modified - new: '1.22' old: '1.21' path: pkgsrc/databases/postgresql12/distinfo pathrev: pkgsrc/databases/postgresql12/distinfo@1.22 type: modified - new: '1.35' old: '1.34' path: pkgsrc/databases/postgresql12-client/Makefile pathrev: pkgsrc/databases/postgresql12-client/Makefile@1.35 type: modified - new: '1.30' old: '1.29' path: pkgsrc/databases/postgresql12-contrib/Makefile pathrev: pkgsrc/databases/postgresql12-contrib/Makefile@1.30 type: modified - new: '1.24' old: '1.23' path: pkgsrc/databases/postgresql12-docs/Makefile pathrev: pkgsrc/databases/postgresql12-docs/Makefile@1.24 type: modified - new: '1.18' old: '1.17' path: pkgsrc/databases/postgresql12-docs/PLIST pathrev: pkgsrc/databases/postgresql12-docs/PLIST@1.18 type: modified - new: '1.30' old: '1.29' path: pkgsrc/databases/postgresql12-plperl/Makefile pathrev: pkgsrc/databases/postgresql12-plperl/Makefile@1.30 type: modified - new: '1.31' old: '1.30' path: pkgsrc/databases/postgresql12-plpython/Makefile pathrev: pkgsrc/databases/postgresql12-plpython/Makefile@1.31 type: modified - new: '1.28' old: '1.27' path: pkgsrc/databases/postgresql12-pltcl/Makefile pathrev: pkgsrc/databases/postgresql12-pltcl/Makefile@1.28 type: modified - new: '1.30' old: '1.29' path: pkgsrc/databases/postgresql12-server/Makefile pathrev: pkgsrc/databases/postgresql12-server/Makefile@1.30 type: modified - new: '1.23' old: '1.22' path: pkgsrc/databases/postgresql13/Makefile pathrev: pkgsrc/databases/postgresql13/Makefile@1.23 type: modified - new: '1.21' old: '1.20' path: pkgsrc/databases/postgresql13/Makefile.common pathrev: pkgsrc/databases/postgresql13/Makefile.common@1.21 type: modified - new: '1.20' old: '1.19' path: pkgsrc/databases/postgresql13/distinfo pathrev: pkgsrc/databases/postgresql13/distinfo@1.20 type: modified - new: '1.29' old: '1.28' path: pkgsrc/databases/postgresql13-client/Makefile pathrev: pkgsrc/databases/postgresql13-client/Makefile@1.29 type: modified - new: '1.23' old: '1.22' path: pkgsrc/databases/postgresql13-contrib/Makefile pathrev: pkgsrc/databases/postgresql13-contrib/Makefile@1.23 type: modified - new: '1.20' old: '1.19' path: pkgsrc/databases/postgresql13-docs/Makefile pathrev: pkgsrc/databases/postgresql13-docs/Makefile@1.20 type: modified - new: '1.14' old: '1.13' path: pkgsrc/databases/postgresql13-docs/PLIST pathrev: pkgsrc/databases/postgresql13-docs/PLIST@1.14 type: modified - new: '1.25' old: '1.24' path: pkgsrc/databases/postgresql13-plperl/Makefile pathrev: pkgsrc/databases/postgresql13-plperl/Makefile@1.25 type: modified - new: '1.25' old: '1.24' path: pkgsrc/databases/postgresql13-plpython/Makefile pathrev: pkgsrc/databases/postgresql13-plpython/Makefile@1.25 type: modified - new: '1.22' old: '1.21' path: pkgsrc/databases/postgresql13-pltcl/Makefile pathrev: pkgsrc/databases/postgresql13-pltcl/Makefile@1.22 type: modified - new: '1.22' old: '1.21' path: pkgsrc/databases/postgresql13-server/Makefile pathrev: pkgsrc/databases/postgresql13-server/Makefile@1.22 type: modified - new: '1.18' old: '1.17' path: pkgsrc/databases/postgresql14/Makefile pathrev: pkgsrc/databases/postgresql14/Makefile@1.18 type: modified - new: '1.13' old: '1.12' path: pkgsrc/databases/postgresql14/Makefile.common pathrev: pkgsrc/databases/postgresql14/Makefile.common@1.13 type: modified - new: '1.13' old: '1.12' path: pkgsrc/databases/postgresql14/distinfo pathrev: pkgsrc/databases/postgresql14/distinfo@1.13 type: modified - new: '1.19' old: '1.18' path: pkgsrc/databases/postgresql14-client/Makefile pathrev: pkgsrc/databases/postgresql14-client/Makefile@1.19 type: modified - new: '1.15' old: '1.14' path: pkgsrc/databases/postgresql14-contrib/Makefile pathrev: pkgsrc/databases/postgresql14-contrib/Makefile@1.15 type: modified - new: '1.15' old: '1.14' path: pkgsrc/databases/postgresql14-docs/Makefile pathrev: pkgsrc/databases/postgresql14-docs/Makefile@1.15 type: modified - new: '1.11' old: '1.10' path: pkgsrc/databases/postgresql14-docs/PLIST pathrev: pkgsrc/databases/postgresql14-docs/PLIST@1.11 type: modified - new: '1.18' old: '1.17' path: pkgsrc/databases/postgresql14-plperl/Makefile pathrev: pkgsrc/databases/postgresql14-plperl/Makefile@1.18 type: modified - new: '1.17' old: '1.16' path: pkgsrc/databases/postgresql14-plpython/Makefile pathrev: pkgsrc/databases/postgresql14-plpython/Makefile@1.17 type: modified - new: '1.15' old: '1.14' path: pkgsrc/databases/postgresql14-pltcl/Makefile pathrev: pkgsrc/databases/postgresql14-pltcl/Makefile@1.15 type: modified - new: '1.15' old: '1.14' path: pkgsrc/databases/postgresql14-server/Makefile pathrev: pkgsrc/databases/postgresql14-server/Makefile@1.15 type: modified - new: '1.9' old: '1.8' path: pkgsrc/databases/postgresql15/Makefile pathrev: pkgsrc/databases/postgresql15/Makefile@1.9 type: modified - new: '1.7' old: '1.6' path: pkgsrc/databases/postgresql15/Makefile.common pathrev: pkgsrc/databases/postgresql15/Makefile.common@1.7 type: modified - new: '1.6' old: '1.5' path: pkgsrc/databases/postgresql15/distinfo pathrev: pkgsrc/databases/postgresql15/distinfo@1.6 type: modified - new: '1.2' old: '1.1' path: pkgsrc/databases/postgresql15/options.mk pathrev: pkgsrc/databases/postgresql15/options.mk@1.2 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/postgresql15-client/Makefile pathrev: pkgsrc/databases/postgresql15-client/Makefile@1.8 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/postgresql15-contrib/Makefile pathrev: pkgsrc/databases/postgresql15-contrib/Makefile@1.8 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/postgresql15-docs/Makefile pathrev: pkgsrc/databases/postgresql15-docs/Makefile@1.8 type: modified - new: '1.6' old: '1.5' path: pkgsrc/databases/postgresql15-docs/PLIST pathrev: pkgsrc/databases/postgresql15-docs/PLIST@1.6 type: modified - new: '1.10' old: '1.9' path: pkgsrc/databases/postgresql15-plperl/Makefile pathrev: pkgsrc/databases/postgresql15-plperl/Makefile@1.10 type: modified - new: '1.9' old: '1.8' path: pkgsrc/databases/postgresql15-plpython/Makefile pathrev: pkgsrc/databases/postgresql15-plpython/Makefile@1.9 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/postgresql15-pltcl/Makefile pathrev: pkgsrc/databases/postgresql15-pltcl/Makefile@1.8 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/postgresql15-server/Makefile pathrev: pkgsrc/databases/postgresql15-server/Makefile@1.8 type: modified - new: '1.5' old: '1.4' path: pkgsrc/databases/postgresql15-server/PLIST pathrev: pkgsrc/databases/postgresql15-server/PLIST@1.5 type: modified - new: '1.4' old: '1.3' path: pkgsrc/databases/postgresql16/Makefile pathrev: pkgsrc/databases/postgresql16/Makefile@1.4 type: modified - new: '1.3' old: '1.2' path: pkgsrc/databases/postgresql16/Makefile.common pathrev: pkgsrc/databases/postgresql16/Makefile.common@1.3 type: modified - new: '1.2' old: '1.1' path: pkgsrc/databases/postgresql16/distinfo pathrev: pkgsrc/databases/postgresql16/distinfo@1.2 type: modified - new: '1.4' old: '1.3' path: pkgsrc/databases/postgresql16-client/Makefile pathrev: pkgsrc/databases/postgresql16-client/Makefile@1.4 type: modified - new: '1.2' old: '1.1' path: pkgsrc/databases/postgresql16-client/PLIST pathrev: pkgsrc/databases/postgresql16-client/PLIST@1.2 type: modified - new: '1.4' old: '1.3' path: pkgsrc/databases/postgresql16-contrib/Makefile pathrev: pkgsrc/databases/postgresql16-contrib/Makefile@1.4 type: modified - new: '1.3' old: '1.2' path: pkgsrc/databases/postgresql16-docs/Makefile pathrev: pkgsrc/databases/postgresql16-docs/Makefile@1.3 type: modified - new: '1.2' old: '1.1' path: pkgsrc/databases/postgresql16-docs/PLIST pathrev: pkgsrc/databases/postgresql16-docs/PLIST@1.2 type: modified - new: '1.4' old: '1.3' path: pkgsrc/databases/postgresql16-plperl/Makefile pathrev: pkgsrc/databases/postgresql16-plperl/Makefile@1.4 type: modified - new: '1.4' old: '1.3' path: pkgsrc/databases/postgresql16-plpython/Makefile pathrev: pkgsrc/databases/postgresql16-plpython/Makefile@1.4 type: modified - new: '1.2' old: '1.1' path: pkgsrc/databases/postgresql16-plpython/PLIST pathrev: pkgsrc/databases/postgresql16-plpython/PLIST@1.2 type: modified - new: '1.4' old: '1.3' path: pkgsrc/databases/postgresql16-pltcl/Makefile pathrev: pkgsrc/databases/postgresql16-pltcl/Makefile@1.4 type: modified - new: '1.4' old: '1.3' path: pkgsrc/databases/postgresql16-server/Makefile pathrev: pkgsrc/databases/postgresql16-server/Makefile@1.4 type: modified id: 20231113T202209Z.0fbef614007b9fa872977a494e74bbb949241ca3 log: | 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. module: pkgsrc subject: 'CVS commit: pkgsrc/databases' unixtime: '1699906929' user: adam