This updates PostgreSQL to 16.2. Release announcement at https://www.postgresql.org/about/news/postgresql-162-156-1411-1314-and-1218-released-2807/
This fixes one CVE: CVE-2024-0985: PostgreSQL non-owner REFRESH MATERIALIZED VIEW CONCURRENTLY executes arbitrary SQL Tested on amd64. Will be committing in a couple days unless I hear objections. Will backport to -stable next week. Thanks, Jeremy Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v diff -u -p -r1.300 Makefile --- Makefile 29 Nov 2023 23:41:15 -0000 1.300 +++ Makefile 8 Feb 2024 15:43:27 -0000 @@ -5,7 +5,7 @@ COMMENT-contrib=PostgreSQL RDBMS contrib COMMENT-plpython=Python procedural language for PostgreSQL COMMENT-pg_upgrade=Support for upgrading PostgreSQL data from previous version -VERSION= 16.1 +VERSION= 16.2 PREV_MAJOR= 15 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v diff -u -p -r1.99 distinfo --- distinfo 29 Nov 2023 23:41:15 -0000 1.99 +++ distinfo 8 Feb 2024 15:45:09 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-16.1.tar.gz) = vwVkclYT98V/HD6/XJCbPsWLnPs9gbS7EgnYh2cGWoc= -SIZE (postgresql-16.1.tar.gz) = 32433767 +SHA256 (postgresql-16.2.tar.gz) = K4IBBH7IGs0brSnbonjXiOeJG5w+gjLtoWuyneyBMcc= +SIZE (postgresql-16.2.tar.gz) = 32558575 Index: patches/patch-src_bin_initdb_initdb_c =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_bin_initdb_initdb_c,v diff -u -p -r1.1 patch-src_bin_initdb_initdb_c --- patches/patch-src_bin_initdb_initdb_c 11 Sep 2023 20:04:47 -0000 1.1 +++ patches/patch-src_bin_initdb_initdb_c 8 Feb 2024 16:30:59 -0000 @@ -4,7 +4,7 @@ script handles. Index: src/bin/initdb/initdb.c --- src/bin/initdb/initdb.c.orig +++ src/bin/initdb/initdb.c -@@ -3152,6 +3152,16 @@ main(int argc, char *argv[]) +@@ -3411,6 +3411,16 @@ main(int argc, char *argv[]) if (!noinstructions) { @@ -21,7 +21,7 @@ Index: src/bin/initdb/initdb.c /* * Build up a shell command to tell the user how to start the server */ -@@ -3183,6 +3193,7 @@ main(int argc, char *argv[]) +@@ -3442,6 +3452,7 @@ main(int argc, char *argv[]) start_db_cmd->data); destroyPQExpBuffer(start_db_cmd); Index: pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v diff -u -p -r1.112 PLIST-docs --- pkg/PLIST-docs 29 Nov 2023 23:41:15 -0000 1.112 +++ pkg/PLIST-docs 8 Feb 2024 16:26:53 -0000 @@ -716,6 +716,7 @@ share/doc/postgresql/html/regress-tap.ht share/doc/postgresql/html/regress-variant.html share/doc/postgresql/html/regress.html share/doc/postgresql/html/release-16-1.html +share/doc/postgresql/html/release-16-2.html share/doc/postgresql/html/release-16.html share/doc/postgresql/html/release-prior.html share/doc/postgresql/html/release.html Index: pkg/PLIST-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v diff -u -p -r1.49 PLIST-server --- pkg/PLIST-server 29 Nov 2023 23:41:15 -0000 1.49 +++ pkg/PLIST-server 8 Feb 2024 16:27:24 -0000 @@ -575,6 +575,7 @@ include/postgresql/server/pgstat.h include/postgresql/server/pgtar.h include/postgresql/server/pgtime.h include/postgresql/server/plperl.h +include/postgresql/server/plperl_system.h include/postgresql/server/plpgsql.h include/postgresql/server/plpy_cursorobject.h include/postgresql/server/plpy_elog.h @@ -587,6 +588,7 @@ include/postgresql/server/plpy_resultobj include/postgresql/server/plpy_spi.h include/postgresql/server/plpy_subxactobject.h include/postgresql/server/plpy_typeio.h +include/postgresql/server/plpython_system.h include/postgresql/server/port/ include/postgresql/server/port.h include/postgresql/server/port/aix.h