Index | Thread | Search

From:
Jeremy Evans <jeremy@openbsd.org>
Subject:
For Early Testing: PostgreSQL 17
To:
OpenBSD ports <ports@openbsd.org>
Date:
Thu, 26 Sep 2024 18:45:28 +0000

Download raw body.

Thread 
This is for early testing and not intended for commit. It updates to the
latest version of PostgreSQL, released today.  I've been testing all
betas and rc1 on amd64, without problems.

This requires updating the docbook dependency with the diff in the email
I recently sent to ports@.

Included here is an update to postgresql-previous, since that is
necessary for building.  I have not tested fallout in any other
dependencies.  There is always fallout, if someone could test this diff
and the docbook diff in a bulk and post the failures in the
dependencies, I can start working on fixing them.

As in previous PostgreSQL major releases, we don't plan to update the
tree until 17.1.

Thanks,
Jeremy

Index: postgresql/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
diff -u -p -u -p -r1.306 Makefile
--- postgresql/Makefile	27 Aug 2024 06:51:18 -0000	1.306
+++ postgresql/Makefile	26 Sep 2024 17:29:58 -0000
@@ -5,11 +5,10 @@ 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.4
-PREV_MAJOR=	15
+VERSION=	17.0
+PREV_MAJOR=	16
 DISTNAME=	postgresql-${VERSION}
 PKGNAME-main=	postgresql-client-${VERSION}
-REVISION=	0
 
 DPB_PROPERTIES=	parallel
 
@@ -17,7 +16,7 @@ CATEGORIES=	databases
 SHARED_LIBS=	ecpg		7.10 \
 		ecpg_compat	4.10 \
 		pgtypes		4.9 \
-		pq		6.15
+		pq		6.16
 
 HOMEPAGE=	https://www.postgresql.org/
 
@@ -26,7 +25,7 @@ MAINTAINER=	Jeremy Evans <jeremy@openbsd
 # BSD
 PERMIT_PACKAGE=	Yes
 
-WANTLIB += c curses crypto m readline ssl z
+WANTLIB += c curses crypto m readline ssl z pthread
 
 SITES=		https://ftp.postgresql.org/pub/source/v${VERSION}/ \
 		ftp://ftp.postgresql.org/pub/source/v${VERSION}/
@@ -82,6 +81,10 @@ MODGNU_CONFIG_GUESS_DIRS=	${WRKSRC}/conf
 ALL_TARGET=	world
 INSTALL_TARGET=	install-world
 
+BUILD_DEPENDS=  textproc/docbook \
+		textproc/docbook-xsl \
+		textproc/xmlto
+
 LIB_DEPENDS-main=	textproc/libxml
 WANTLIB-main=		${WANTLIB} execinfo xml2
 
@@ -110,7 +113,6 @@ RUN_DEPENDS-plpython=	databases/postgres
 WANTLIB-docs=
 PKG_ARCH-docs=	*
 
-
 MAKE_ENV=	LIBpq_MAJOR=${LIBpq_VERSION:R} \
 		LIBpq_MINOR=${LIBpq_VERSION:E} \
 		LIBecpg_MAJOR=${LIBecpg_VERSION:R} \
@@ -118,11 +120,12 @@ MAKE_ENV=	LIBpq_MAJOR=${LIBpq_VERSION:R}
 		LIBecpg_compat_MAJOR=${LIBecpg_compat_VERSION:R} \
 		LIBecpg_compat_MINOR=${LIBecpg_compat_VERSION:E} \
 		LIBpgtypes_MAJOR=${LIBpgtypes_VERSION:R} \
-		LIBpgtypes_MINOR=${LIBpgtypes_VERSION:E}
+		LIBpgtypes_MINOR=${LIBpgtypes_VERSION:E} \
+		XML_CATALOG_FILES="${LOCALBASE}/share/xml/docbook/4.5/catalog.xml \
+			${LOCALBASE}/share/xsl/docbook/catalog.xml"
 
 DOCS=	${WRKSRC}/COPYRIGHT ${WRKSRC}/HISTORY \
-	${WRKSRC}/INSTALL ${WRKSRC}/README \
-	${WRKSRC}/doc/TODO
+	${WRKSRC}/README.md ${WRKSRC}/doc/TODO
 
 # Work around Makefile issue where it attempts to rebuild
 # the documentation even if it is not necessary.
Index: postgresql/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
diff -u -p -u -p -r1.102 distinfo
--- postgresql/distinfo	12 Aug 2024 17:32:01 -0000	1.102
+++ postgresql/distinfo	26 Sep 2024 17:31:27 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-16.4.tar.gz) = LhepAGJAPhXWVASA/exQyLAF60hympHLSYn/6wTfGTw=
-SIZE (postgresql-16.4.tar.gz) = 32660355
+SHA256 (postgresql-17.0.tar.gz) = v4HAxRYeRWqIbt5fH0Ez9DrwAGN+N3FWoC5+g1aQga0=
+SIZE (postgresql-17.0.tar.gz) = 27865263
Index: postgresql/patches/patch-src_bin_initdb_initdb_c
===================================================================
RCS file: /cvs/ports/databases/postgresql/patches/patch-src_bin_initdb_initdb_c,v
diff -u -p -u -p -r1.3 patch-src_bin_initdb_initdb_c
--- postgresql/patches/patch-src_bin_initdb_initdb_c	12 Aug 2024 17:32:01 -0000	1.3
+++ postgresql/patches/patch-src_bin_initdb_initdb_c	3 Sep 2024 23:58:31 -0000
@@ -4,7 +4,7 @@ script handles.
 Index: src/bin/initdb/initdb.c
 --- src/bin/initdb/initdb.c.orig
 +++ src/bin/initdb/initdb.c
-@@ -3416,6 +3416,16 @@ main(int argc, char *argv[])
+@@ -3449,6 +3449,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
  		 */
-@@ -3447,6 +3457,7 @@ main(int argc, char *argv[])
+@@ -3480,6 +3490,7 @@ main(int argc, char *argv[])
  			   start_db_cmd->data);
  
  		destroyPQExpBuffer(start_db_cmd);
Index: postgresql/patches/patch-src_include_storage_s_lock_h
===================================================================
RCS file: /cvs/ports/databases/postgresql/patches/patch-src_include_storage_s_lock_h,v
diff -u -p -u -p -r1.11 patch-src_include_storage_s_lock_h
--- postgresql/patches/patch-src_include_storage_s_lock_h	29 Nov 2023 23:41:15 -0000	1.11
+++ postgresql/patches/patch-src_include_storage_s_lock_h	23 May 2024 16:08:08 -0000
@@ -1,7 +1,7 @@
 Index: src/include/storage/s_lock.h
 --- src/include/storage/s_lock.h.orig
 +++ src/include/storage/s_lock.h
-@@ -655,6 +655,29 @@ tas(volatile slock_t *lock)
+@@ -651,6 +651,29 @@ tas(volatile slock_t *lock)
  	do { __asm__ __volatile__("" : : : "memory");  *(lock) = 0; } while (0)
  #endif
  
Index: postgresql/pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
diff -u -p -u -p -r1.28 PLIST-contrib
--- postgresql/pkg/PLIST-contrib	29 Nov 2023 23:41:15 -0000	1.28
+++ postgresql/pkg/PLIST-contrib	23 May 2024 18:52:19 -0000
@@ -9,7 +9,6 @@
 @bin bin/pgbench
 @bin bin/vacuumlo
 @so lib/postgresql/_int.so
-@so lib/postgresql/adminpack.so
 @so lib/postgresql/amcheck.so
 @so lib/postgresql/auth_delay.so
 @so lib/postgresql/auto_explain.so
@@ -33,7 +32,6 @@
 @so lib/postgresql/lo.so
 @so lib/postgresql/ltree.so
 @so lib/postgresql/moddatetime.so
-@so lib/postgresql/old_snapshot.so
 @so lib/postgresql/pageinspect.so
 @so lib/postgresql/passwordcheck.so
 @so lib/postgresql/pg_buffercache.so
@@ -65,15 +63,11 @@
 @man man/man1/pg_test_timing.1
 @man man/man1/pgbench.1
 @man man/man1/vacuumlo.1
-share/postgresql/extension/adminpack--1.0--1.1.sql
-share/postgresql/extension/adminpack--1.0.sql
-share/postgresql/extension/adminpack--1.1--2.0.sql
-share/postgresql/extension/adminpack--2.0--2.1.sql
-share/postgresql/extension/adminpack.control
 share/postgresql/extension/amcheck--1.0--1.1.sql
 share/postgresql/extension/amcheck--1.0.sql
 share/postgresql/extension/amcheck--1.1--1.2.sql
 share/postgresql/extension/amcheck--1.2--1.3.sql
+share/postgresql/extension/amcheck--1.3--1.4.sql
 share/postgresql/extension/amcheck.control
 share/postgresql/extension/autoinc--1.0.sql
 share/postgresql/extension/autoinc.control
@@ -168,11 +162,10 @@ share/postgresql/extension/lo.control
 share/postgresql/extension/ltree--1.0--1.1.sql
 share/postgresql/extension/ltree--1.1--1.2.sql
 share/postgresql/extension/ltree--1.1.sql
+share/postgresql/extension/ltree--1.2--1.3.sql
 share/postgresql/extension/ltree.control
 share/postgresql/extension/moddatetime--1.0.sql
 share/postgresql/extension/moddatetime.control
-share/postgresql/extension/old_snapshot--1.0.sql
-share/postgresql/extension/old_snapshot.control
 share/postgresql/extension/pageinspect--1.0--1.1.sql
 share/postgresql/extension/pageinspect--1.1--1.2.sql
 share/postgresql/extension/pageinspect--1.10--1.11.sql
@@ -192,6 +185,7 @@ share/postgresql/extension/pg_buffercach
 share/postgresql/extension/pg_buffercache--1.2--1.3.sql
 share/postgresql/extension/pg_buffercache--1.2.sql
 share/postgresql/extension/pg_buffercache--1.3--1.4.sql
+share/postgresql/extension/pg_buffercache--1.4--1.5.sql
 share/postgresql/extension/pg_buffercache.control
 share/postgresql/extension/pg_freespacemap--1.0--1.1.sql
 share/postgresql/extension/pg_freespacemap--1.1--1.2.sql
@@ -203,6 +197,7 @@ share/postgresql/extension/pg_prewarm--1
 share/postgresql/extension/pg_prewarm.control
 share/postgresql/extension/pg_stat_statements--1.0--1.1.sql
 share/postgresql/extension/pg_stat_statements--1.1--1.2.sql
+share/postgresql/extension/pg_stat_statements--1.10--1.11.sql
 share/postgresql/extension/pg_stat_statements--1.2--1.3.sql
 share/postgresql/extension/pg_stat_statements--1.3--1.4.sql
 share/postgresql/extension/pg_stat_statements--1.4--1.5.sql
Index: postgresql/pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
diff -u -p -u -p -r1.115 PLIST-docs
--- postgresql/pkg/PLIST-docs	12 Aug 2024 17:32:01 -0000	1.115
+++ postgresql/pkg/PLIST-docs	3 Sep 2024 23:58:09 -0000
@@ -1,8 +1,7 @@
 share/doc/postgresql/
 share/doc/postgresql/COPYRIGHT
 share/doc/postgresql/HISTORY
-share/doc/postgresql/INSTALL
-share/doc/postgresql/README
+share/doc/postgresql/README.md
 share/doc/postgresql/TODO
 share/doc/postgresql/extension/
 share/doc/postgresql/extension/autoinc.example
@@ -12,7 +11,6 @@ share/doc/postgresql/extension/refint.ex
 share/doc/postgresql/html/
 share/doc/postgresql/html/acronyms.html
 share/doc/postgresql/html/admin.html
-share/doc/postgresql/html/adminpack.html
 share/doc/postgresql/html/amcheck.html
 share/doc/postgresql/html/app-clusterdb.html
 share/doc/postgresql/html/app-createdb.html
@@ -27,8 +25,10 @@ share/doc/postgresql/html/app-pg-isready
 share/doc/postgresql/html/app-pgamcheck.html
 share/doc/postgresql/html/app-pgbasebackup.html
 share/doc/postgresql/html/app-pgchecksums.html
+share/doc/postgresql/html/app-pgcombinebackup.html
 share/doc/postgresql/html/app-pgconfig.html
 share/doc/postgresql/html/app-pgcontroldata.html
+share/doc/postgresql/html/app-pgcreatesubscriber.html
 share/doc/postgresql/html/app-pgdump.html
 share/doc/postgresql/html/app-pgreceivewal.html
 share/doc/postgresql/html/app-pgreceivexlog.html
@@ -38,6 +38,7 @@ share/doc/postgresql/html/app-pgresetxlo
 share/doc/postgresql/html/app-pgrestore.html
 share/doc/postgresql/html/app-pgrewind.html
 share/doc/postgresql/html/app-pgverifybackup.html
+share/doc/postgresql/html/app-pgwalsummary.html
 share/doc/postgresql/html/app-postgres.html
 share/doc/postgresql/html/app-psql.html
 share/doc/postgresql/html/app-reindexdb.html
@@ -81,16 +82,9 @@ share/doc/postgresql/html/bki-structure.
 share/doc/postgresql/html/bki.html
 share/doc/postgresql/html/bloom.html
 share/doc/postgresql/html/bookindex.html
-share/doc/postgresql/html/brin-builtin-opclasses.html
-share/doc/postgresql/html/brin-extensibility.html
-share/doc/postgresql/html/brin-intro.html
 share/doc/postgresql/html/brin.html
-share/doc/postgresql/html/btree-behavior.html
 share/doc/postgresql/html/btree-gin.html
 share/doc/postgresql/html/btree-gist.html
-share/doc/postgresql/html/btree-implementation.html
-share/doc/postgresql/html/btree-intro.html
-share/doc/postgresql/html/btree-support-funcs.html
 share/doc/postgresql/html/btree.html
 share/doc/postgresql/html/bug-reporting.html
 share/doc/postgresql/html/catalog-pg-aggregate.html
@@ -238,6 +232,7 @@ share/doc/postgresql/html/ddl-default.ht
 share/doc/postgresql/html/ddl-depend.html
 share/doc/postgresql/html/ddl-foreign-data.html
 share/doc/postgresql/html/ddl-generated-columns.html
+share/doc/postgresql/html/ddl-identity-columns.html
 share/doc/postgresql/html/ddl-inherit.html
 share/doc/postgresql/html/ddl-others.html
 share/doc/postgresql/html/ddl-partitioning.html
@@ -250,8 +245,6 @@ share/doc/postgresql/html/default-roles.
 share/doc/postgresql/html/dict-int.html
 share/doc/postgresql/html/dict-xsyn.html
 share/doc/postgresql/html/different-replication-solutions.html
-share/doc/postgresql/html/disk-full.html
-share/doc/postgresql/html/disk-usage.html
 share/doc/postgresql/html/diskusage.html
 share/doc/postgresql/html/dml-delete.html
 share/doc/postgresql/html/dml-insert.html
@@ -308,6 +301,7 @@ share/doc/postgresql/html/errcodes-appen
 share/doc/postgresql/html/error-message-reporting.html
 share/doc/postgresql/html/error-style-guide.html
 share/doc/postgresql/html/event-log-registration.html
+share/doc/postgresql/html/event-trigger-database-login-example.html
 share/doc/postgresql/html/event-trigger-definition.html
 share/doc/postgresql/html/event-trigger-example.html
 share/doc/postgresql/html/event-trigger-interface.html
@@ -354,6 +348,7 @@ share/doc/postgresql/html/functions-json
 share/doc/postgresql/html/functions-logical.html
 share/doc/postgresql/html/functions-matching.html
 share/doc/postgresql/html/functions-math.html
+share/doc/postgresql/html/functions-merge-support.html
 share/doc/postgresql/html/functions-net.html
 share/doc/postgresql/html/functions-range.html
 share/doc/postgresql/html/functions-sequence.html
@@ -375,28 +370,14 @@ share/doc/postgresql/html/geqo-intro.htm
 share/doc/postgresql/html/geqo-intro2.html
 share/doc/postgresql/html/geqo-pg-intro.html
 share/doc/postgresql/html/geqo.html
-share/doc/postgresql/html/gin-builtin-opclasses.html
-share/doc/postgresql/html/gin-examples.html
-share/doc/postgresql/html/gin-extensibility.html
-share/doc/postgresql/html/gin-implementation.html
-share/doc/postgresql/html/gin-intro.html
-share/doc/postgresql/html/gin-limit.html
-share/doc/postgresql/html/gin-tips.html
 share/doc/postgresql/html/gin.html
 share/doc/postgresql/html/gin.svg
-share/doc/postgresql/html/gist-builtin-opclasses.html
-share/doc/postgresql/html/gist-examples.html
-share/doc/postgresql/html/gist-extensibility.html
-share/doc/postgresql/html/gist-implementation.html
-share/doc/postgresql/html/gist-intro.html
 share/doc/postgresql/html/gist.html
 share/doc/postgresql/html/git.html
 share/doc/postgresql/html/glossary.html
 share/doc/postgresql/html/gssapi-auth.html
 share/doc/postgresql/html/gssapi-enc.html
-share/doc/postgresql/html/hash-implementation.html
 share/doc/postgresql/html/hash-index.html
-share/doc/postgresql/html/hash-intro.html
 share/doc/postgresql/html/high-availability.html
 share/doc/postgresql/html/history.html
 share/doc/postgresql/html/hot-standby.html
@@ -423,6 +404,7 @@ share/doc/postgresql/html/indexes-partia
 share/doc/postgresql/html/indexes-types.html
 share/doc/postgresql/html/indexes-unique.html
 share/doc/postgresql/html/indexes.html
+share/doc/postgresql/html/indextypes.html
 share/doc/postgresql/html/information-schema.html
 share/doc/postgresql/html/infoschema-administrable-role-authorizations.html
 share/doc/postgresql/html/infoschema-applicable-roles.html
@@ -496,8 +478,6 @@ share/doc/postgresql/html/install-make.h
 share/doc/postgresql/html/install-meson.html
 share/doc/postgresql/html/install-post.html
 share/doc/postgresql/html/install-requirements.html
-share/doc/postgresql/html/install-windows-full.html
-share/doc/postgresql/html/install-windows.html
 share/doc/postgresql/html/installation-platform-notes.html
 share/doc/postgresql/html/installation.html
 share/doc/postgresql/html/intagg.html
@@ -550,6 +530,7 @@ share/doc/postgresql/html/logical-replic
 share/doc/postgresql/html/logical-replication-col-lists.html
 share/doc/postgresql/html/logical-replication-config.html
 share/doc/postgresql/html/logical-replication-conflicts.html
+share/doc/postgresql/html/logical-replication-failover.html
 share/doc/postgresql/html/logical-replication-monitoring.html
 share/doc/postgresql/html/logical-replication-publication.html
 share/doc/postgresql/html/logical-replication-quick-setup.html
@@ -594,7 +575,6 @@ share/doc/postgresql/html/nls.html
 share/doc/postgresql/html/non-durability.html
 share/doc/postgresql/html/notation.html
 share/doc/postgresql/html/oid2name.html
-share/doc/postgresql/html/oldsnapshot.html
 share/doc/postgresql/html/overview.html
 share/doc/postgresql/html/pageinspect.html
 share/doc/postgresql/html/pagelayout.svg
@@ -715,11 +695,7 @@ share/doc/postgresql/html/regress-run.ht
 share/doc/postgresql/html/regress-tap.html
 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-3.html
-share/doc/postgresql/html/release-16-4.html
-share/doc/postgresql/html/release-16.html
+share/doc/postgresql/html/release-17.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
 share/doc/postgresql/html/replication-origins.html
@@ -768,11 +744,6 @@ share/doc/postgresql/html/source-convent
 share/doc/postgresql/html/source-format.html
 share/doc/postgresql/html/source.html
 share/doc/postgresql/html/sourcerepo.html
-share/doc/postgresql/html/spgist-builtin-opclasses.html
-share/doc/postgresql/html/spgist-examples.html
-share/doc/postgresql/html/spgist-extensibility.html
-share/doc/postgresql/html/spgist-implementation.html
-share/doc/postgresql/html/spgist-intro.html
 share/doc/postgresql/html/spgist.html
 share/doc/postgresql/html/spi-examples.html
 share/doc/postgresql/html/spi-interface-support.html
@@ -1142,10 +1113,12 @@ share/doc/postgresql/html/view-pg-timezo
 share/doc/postgresql/html/view-pg-user-mappings.html
 share/doc/postgresql/html/view-pg-user.html
 share/doc/postgresql/html/view-pg-views.html
+share/doc/postgresql/html/view-pg-wait-events.html
 share/doc/postgresql/html/views-overview.html
 share/doc/postgresql/html/views.html
 share/doc/postgresql/html/wal-async-commit.html
 share/doc/postgresql/html/wal-configuration.html
+share/doc/postgresql/html/wal-for-extensions.html
 share/doc/postgresql/html/wal-internals.html
 share/doc/postgresql/html/wal-intro.html
 share/doc/postgresql/html/wal-reliability.html
Index: postgresql/pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
diff -u -p -u -p -r1.51 PLIST-server
--- postgresql/pkg/PLIST-server	20 May 2024 19:14:05 -0000	1.51
+++ postgresql/pkg/PLIST-server	28 Jun 2024 22:00:42 -0000
@@ -18,7 +18,9 @@
 @bin bin/initdb
 @bin bin/pg_basebackup
 @bin bin/pg_checksums
+@bin bin/pg_combinebackup
 @bin bin/pg_controldata
+@bin bin/pg_createsubscriber
 @bin bin/pg_ctl
 @bin bin/pg_isready
 @bin bin/pg_receivewal
@@ -27,7 +29,9 @@
 @bin bin/pg_rewind
 @bin bin/pg_verifybackup
 @bin bin/pg_waldump
+@bin bin/pg_walsummary
 @bin bin/postgres
+include/postgresql/internal/libpq/protocol.h
 include/postgresql/server/
 include/postgresql/server/access/
 include/postgresql/server/access/amapi.h
@@ -78,6 +82,7 @@ include/postgresql/server/access/rmgr.h
 include/postgresql/server/access/rmgrdesc_utils.h
 include/postgresql/server/access/rmgrlist.h
 include/postgresql/server/access/sdir.h
+include/postgresql/server/access/sequence.h
 include/postgresql/server/access/session.h
 include/postgresql/server/access/skey.h
 include/postgresql/server/access/slru.h
@@ -90,6 +95,7 @@ include/postgresql/server/access/syncsca
 include/postgresql/server/access/sysattr.h
 include/postgresql/server/access/table.h
 include/postgresql/server/access/tableam.h
+include/postgresql/server/access/tidstore.h
 include/postgresql/server/access/timeline.h
 include/postgresql/server/access/toast_compression.h
 include/postgresql/server/access/toast_helper.h
@@ -269,6 +275,8 @@ include/postgresql/server/catalog/pg_use
 include/postgresql/server/catalog/schemapg.h
 include/postgresql/server/catalog/storage.h
 include/postgresql/server/catalog/storage_xlog.h
+include/postgresql/server/catalog/syscache_ids.h
+include/postgresql/server/catalog/syscache_info.h
 include/postgresql/server/catalog/system_fk_info.h
 include/postgresql/server/catalog/toasting.h
 include/postgresql/server/commands/
@@ -310,6 +318,7 @@ include/postgresql/server/commands/view.
 include/postgresql/server/common/
 include/postgresql/server/common/archive.h
 include/postgresql/server/common/base64.h
+include/postgresql/server/common/blkreftable.h
 include/postgresql/server/common/checksum_helper.h
 include/postgresql/server/common/compression.h
 include/postgresql/server/common/config_info.h
@@ -320,6 +329,7 @@ include/postgresql/server/common/fe_memu
 include/postgresql/server/common/file_perm.h
 include/postgresql/server/common/file_utils.h
 include/postgresql/server/common/hashfn.h
+include/postgresql/server/common/hashfn_unstable.h
 include/postgresql/server/common/hmac.h
 include/postgresql/server/common/int.h
 include/postgresql/server/common/int128.h
@@ -331,6 +341,7 @@ include/postgresql/server/common/link-ca
 include/postgresql/server/common/logging.h
 include/postgresql/server/common/md5.h
 include/postgresql/server/common/openssl.h
+include/postgresql/server/common/parse_manifest.h
 include/postgresql/server/common/percentrepl.h
 include/postgresql/server/common/pg_lzcompress.h
 include/postgresql/server/common/pg_prng.h
@@ -342,12 +353,17 @@ include/postgresql/server/common/sha1.h
 include/postgresql/server/common/sha2.h
 include/postgresql/server/common/shortest_dec.h
 include/postgresql/server/common/string.h
+include/postgresql/server/common/unicode_case.h
+include/postgresql/server/common/unicode_case_table.h
+include/postgresql/server/common/unicode_category.h
+include/postgresql/server/common/unicode_category_table.h
 include/postgresql/server/common/unicode_east_asian_fw_table.h
 include/postgresql/server/common/unicode_nonspacing_table.h
 include/postgresql/server/common/unicode_norm.h
 include/postgresql/server/common/unicode_norm_hashfunc.h
 include/postgresql/server/common/unicode_norm_table.h
 include/postgresql/server/common/unicode_normprops_table.h
+include/postgresql/server/common/unicode_version.h
 include/postgresql/server/common/username.h
 include/postgresql/server/datatype/
 include/postgresql/server/datatype/timestamp.h
@@ -458,6 +474,7 @@ include/postgresql/server/lib/integerset
 include/postgresql/server/lib/knapsack.h
 include/postgresql/server/lib/pairingheap.h
 include/postgresql/server/lib/qunique.h
+include/postgresql/server/lib/radixtree.h
 include/postgresql/server/lib/rbtree.h
 include/postgresql/server/lib/simplehash.h
 include/postgresql/server/lib/sort_template.h
@@ -477,6 +494,7 @@ include/postgresql/server/libpq/pqcomm.h
 include/postgresql/server/libpq/pqformat.h
 include/postgresql/server/libpq/pqmq.h
 include/postgresql/server/libpq/pqsignal.h
+include/postgresql/server/libpq/protocol.h
 include/postgresql/server/libpq/sasl.h
 include/postgresql/server/libpq/scram.h
 include/postgresql/server/mb/
@@ -591,7 +609,6 @@ 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
 include/postgresql/server/port/atomics/
 include/postgresql/server/port/atomics.h
 include/postgresql/server/port/atomics/arch-arm.h
@@ -662,6 +679,7 @@ include/postgresql/server/postmaster/pga
 include/postgresql/server/postmaster/postmaster.h
 include/postgresql/server/postmaster/startup.h
 include/postgresql/server/postmaster/syslogger.h
+include/postgresql/server/postmaster/walsummarizer.h
 include/postgresql/server/postmaster/walwriter.h
 include/postgresql/server/ppport.h
 include/postgresql/server/regex/
@@ -683,6 +701,7 @@ include/postgresql/server/replication/ou
 include/postgresql/server/replication/pgoutput.h
 include/postgresql/server/replication/reorderbuffer.h
 include/postgresql/server/replication/slot.h
+include/postgresql/server/replication/slotsync.h
 include/postgresql/server/replication/snapbuild.h
 include/postgresql/server/replication/syncrep.h
 include/postgresql/server/replication/walreceiver.h
@@ -755,7 +774,6 @@ include/postgresql/server/statistics/
 include/postgresql/server/statistics/extended_stats_internal.h
 include/postgresql/server/statistics/statistics.h
 include/postgresql/server/storage/
-include/postgresql/server/storage/backendid.h
 include/postgresql/server/storage/barrier.h
 include/postgresql/server/storage/block.h
 include/postgresql/server/storage/buf.h
@@ -763,12 +781,14 @@ include/postgresql/server/storage/buf_in
 include/postgresql/server/storage/buffile.h
 include/postgresql/server/storage/bufmgr.h
 include/postgresql/server/storage/bufpage.h
+include/postgresql/server/storage/bulk_write.h
 include/postgresql/server/storage/checksum.h
 include/postgresql/server/storage/checksum_impl.h
 include/postgresql/server/storage/condition_variable.h
 include/postgresql/server/storage/copydir.h
 include/postgresql/server/storage/dsm.h
 include/postgresql/server/storage/dsm_impl.h
+include/postgresql/server/storage/dsm_registry.h
 include/postgresql/server/storage/fd.h
 include/postgresql/server/storage/fileset.h
 include/postgresql/server/storage/freespace.h
@@ -784,6 +804,7 @@ include/postgresql/server/storage/lmgr.h
 include/postgresql/server/storage/lock.h
 include/postgresql/server/storage/lockdefs.h
 include/postgresql/server/storage/lwlock.h
+include/postgresql/server/storage/lwlocklist.h
 include/postgresql/server/storage/lwlocknames.h
 include/postgresql/server/storage/md.h
 include/postgresql/server/storage/off.h
@@ -796,7 +817,9 @@ include/postgresql/server/storage/proc.h
 include/postgresql/server/storage/procarray.h
 include/postgresql/server/storage/proclist.h
 include/postgresql/server/storage/proclist_types.h
+include/postgresql/server/storage/procnumber.h
 include/postgresql/server/storage/procsignal.h
+include/postgresql/server/storage/read_stream.h
 include/postgresql/server/storage/reinit.h
 include/postgresql/server/storage/relfilelocator.h
 include/postgresql/server/storage/s_lock.h
@@ -812,6 +835,7 @@ include/postgresql/server/storage/standb
 include/postgresql/server/storage/standbydefs.h
 include/postgresql/server/storage/sync.h
 include/postgresql/server/tcop/
+include/postgresql/server/tcop/backend_startup.h
 include/postgresql/server/tcop/cmdtag.h
 include/postgresql/server/tcop/cmdtaglist.h
 include/postgresql/server/tcop/deparse_utility.h
@@ -868,6 +892,7 @@ include/postgresql/server/utils/help_con
 include/postgresql/server/utils/hsearch.h
 include/postgresql/server/utils/index_selfuncs.h
 include/postgresql/server/utils/inet.h
+include/postgresql/server/utils/injection_point.h
 include/postgresql/server/utils/inval.h
 include/postgresql/server/utils/json.h
 include/postgresql/server/utils/jsonb.h
@@ -881,7 +906,6 @@ include/postgresql/server/utils/memutils
 include/postgresql/server/utils/memutils_memorychunk.h
 include/postgresql/server/utils/multirangetypes.h
 include/postgresql/server/utils/numeric.h
-include/postgresql/server/utils/old_snapshot.h
 include/postgresql/server/utils/palloc.h
 include/postgresql/server/utils/partcache.h
 include/postgresql/server/utils/pg_crc.h
@@ -904,7 +928,6 @@ include/postgresql/server/utils/relmappe
 include/postgresql/server/utils/relptr.h
 include/postgresql/server/utils/reltrigger.h
 include/postgresql/server/utils/resowner.h
-include/postgresql/server/utils/resowner_private.h
 include/postgresql/server/utils/rls.h
 include/postgresql/server/utils/ruleutils.h
 include/postgresql/server/utils/sampling.h
@@ -926,6 +949,7 @@ include/postgresql/server/utils/uuid.h
 include/postgresql/server/utils/varbit.h
 include/postgresql/server/utils/varlena.h
 include/postgresql/server/utils/wait_event.h
+include/postgresql/server/utils/wait_event_types.h
 include/postgresql/server/utils/xid8.h
 include/postgresql/server/utils/xml.h
 include/postgresql/server/varatt.h
@@ -969,7 +993,9 @@ lib/postgresql/pgxs/src/test/isolation/
 @man man/man1/initdb.1
 @man man/man1/pg_basebackup.1
 @man man/man1/pg_checksums.1
+@man man/man1/pg_combinebackup.1
 @man man/man1/pg_controldata.1
+@man man/man1/pg_createsubscriber.1
 @man man/man1/pg_ctl.1
 @man man/man1/pg_receivewal.1
 @man man/man1/pg_recvlogical.1
@@ -977,6 +1003,7 @@ lib/postgresql/pgxs/src/test/isolation/
 @man man/man1/pg_rewind.1
 @man man/man1/pg_verifybackup.1
 @man man/man1/pg_waldump.1
+@man man/man1/pg_walsummary.1
 @man man/man1/postgres.1
 share/doc/pkg-readmes/${PKGSTEM}
 share/examples/login.conf.d/postgresql
@@ -988,7 +1015,6 @@ share/postgresql/extension/plperlu--1.0.
 share/postgresql/extension/plperlu.control
 share/postgresql/extension/plpgsql--1.0.sql
 share/postgresql/extension/plpgsql.control
-share/postgresql/fix-CVE-2024-4317.sql
 share/postgresql/pg_hba.conf.sample
 share/postgresql/pg_ident.conf.sample
 share/postgresql/pg_service.conf.sample
Index: postgresql-previous/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/Makefile,v
diff -u -p -u -p -r1.27 Makefile
--- postgresql-previous/Makefile	27 Aug 2024 06:51:46 -0000	1.27
+++ postgresql-previous/Makefile	3 Sep 2024 00:05:47 -0000
@@ -1,6 +1,6 @@
 COMMENT=	PostgreSQL RDBMS (previous version, for pg_upgrade)
 
-VERSION=	15.4
+VERSION=	16.3
 DISTNAME=	postgresql-${VERSION}
 PKGNAME=	postgresql-previous-${VERSION}
 REVISION=	0
@@ -9,7 +9,7 @@ CATEGORIES=	databases
 SHARED_LIBS=	ecpg		7.10 \
 		ecpg_compat	4.10 \
 		pgtypes		4.9 \
-		pq		6.14
+		pq		6.15
 
 HOMEPAGE=	https://www.postgresql.org/
 
@@ -18,7 +18,7 @@ MAINTAINER=	Jeremy Evans <jeremy@openbsd
 # BSD
 PERMIT_PACKAGE=	Yes
 
-WANTLIB =  c crypto curses execinfo m perl readline ssl xml2 z
+WANTLIB =  c crypto curses execinfo icudata icui18n icuuc m perl readline ssl xml2 z
 
 SITES=		https://ftp.postgresql.org/pub/source/v${VERSION}/ \
 		ftp://ftp.postgresql.org/pub/source/v${VERSION}/
@@ -68,7 +68,8 @@ MODGNU_CONFIG_GUESS_DIRS=	${WRKSRC}/conf
 ALL_TARGET=	all
 INSTALL_TARGET=	install
 
-LIB_DEPENDS = textproc/libxml
+LIB_DEPENDS =	textproc/libxml \
+		textproc/icu4c
 
 MAKE_ENV=	LIBpq_MAJOR=${LIBpq_VERSION:R} \
 		LIBpq_MINOR=${LIBpq_VERSION:E} \
Index: postgresql-previous/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/distinfo,v
diff -u -p -u -p -r1.11 distinfo
--- postgresql-previous/distinfo	29 Nov 2023 23:41:30 -0000	1.11
+++ postgresql-previous/distinfo	23 May 2024 15:32:43 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-15.4.tar.gz) = DhHu5yPdflmmNAUrwb/JvmBeVcHMo/Zun8JdOjlPsDA=
-SIZE (postgresql-15.4.tar.gz) = 29978353
+SHA256 (postgresql-16.3.tar.gz) = vTeYw5m8G20IuUNA+d16daMKf6B2eI7y9ISL4r5qX8U=
+SIZE (postgresql-16.3.tar.gz) = 32616059
Index: postgresql-previous/patches/patch-src_backend_libpq_ip_c
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_backend_libpq_ip_c,v
diff -u -p -u -p -r1.3 patch-src_backend_libpq_ip_c
--- postgresql-previous/patches/patch-src_backend_libpq_ip_c	11 Mar 2022 18:31:38 -0000	1.3
+++ postgresql-previous/patches/patch-src_backend_libpq_ip_c	23 May 2024 15:44:27 -0000
@@ -4,12 +4,11 @@ since the latter is unreliable. Fixes "s
 Index: src/backend/libpq/ifaddr.c
 --- src/backend/libpq/ifaddr.c.orig
 +++ src/backend/libpq/ifaddr.c
-@@ -200,17 +200,16 @@ run_ifaddr_callback(PgIfAddrCallback callback, void *c
+@@ -189,16 +189,14 @@ run_ifaddr_callback(PgIfAddrCallback callback, void *c
  	/* Check that the mask is valid */
  	if (mask)
  	{
 -		if (mask->sa_family != addr->sa_family)
-+
 +		/* mask->sa_family can be different from addr->sa_family. */
 +
 +		if (addr->sa_family == AF_INET)
@@ -21,7 +20,6 @@ Index: src/backend/libpq/ifaddr.c
  			if (((struct sockaddr_in *) mask)->sin_addr.s_addr == INADDR_ANY)
  				mask = NULL;
  		}
- #ifdef HAVE_IPV6
 -		else if (mask->sa_family == AF_INET6)
 +		else if (addr->sa_family == AF_INET6)
  		{
Index: postgresql-previous/patches/patch-src_include_storage_s_lock_h
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h,v
diff -u -p -u -p -r1.7 patch-src_include_storage_s_lock_h
--- postgresql-previous/patches/patch-src_include_storage_s_lock_h	29 Nov 2023 23:41:30 -0000	1.7
+++ postgresql-previous/patches/patch-src_include_storage_s_lock_h	23 May 2024 15:44:48 -0000
@@ -1,7 +1,7 @@
 Index: src/include/storage/s_lock.h
 --- src/include/storage/s_lock.h.orig
 +++ src/include/storage/s_lock.h
-@@ -802,6 +802,29 @@ tas(volatile slock_t *lock)
+@@ -655,6 +655,29 @@ tas(volatile slock_t *lock)
  	do { __asm__ __volatile__("" : : : "memory");  *(lock) = 0; } while (0)
  #endif
  
Index: postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v
diff -u -p -u -p -r1.5 patch-src_interfaces_ecpg_compatlib_Makefile
--- postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile	11 Mar 2022 18:31:38 -0000	1.5
+++ postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile	23 May 2024 15:44:48 -0000
@@ -11,4 +11,4 @@ Index: src/interfaces/ecpg/compatlib/Mak
 +SO_MINOR_VERSION= ${LIBecpg_compat_MINOR}
  
  override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \
- 	-I$(libpq_srcdir) -DFRONTEND $(CPPFLAGS)
+ 	-I$(libpq_srcdir) $(CPPFLAGS)
Index: postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile,v
diff -u -p -u -p -r1.5 patch-src_interfaces_ecpg_ecpglib_Makefile
--- postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile	11 Mar 2022 18:31:38 -0000	1.5
+++ postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile	23 May 2024 15:44:48 -0000
@@ -11,4 +11,4 @@ Index: src/interfaces/ecpg/ecpglib/Makef
 +SO_MINOR_VERSION= ${LIBecpg_MINOR}
  
  override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \
- 	-I$(libpq_srcdir) -I$(top_builddir)/src/port -DFRONTEND $(CPPFLAGS)
+ 	-I$(libpq_srcdir) -I$(top_builddir)/src/port $(CPPFLAGS)
Index: postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile,v
diff -u -p -u -p -r1.5 patch-src_interfaces_ecpg_pgtypeslib_Makefile
--- postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile	11 Mar 2022 18:31:38 -0000	1.5
+++ postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile	23 May 2024 15:44:48 -0000
@@ -11,4 +11,4 @@ Index: src/interfaces/ecpg/pgtypeslib/Ma
 +SO_MINOR_VERSION= ${LIBpgtypes_MINOR}
  
  override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \
- 	-DFRONTEND $(CPPFLAGS)
+ 	$(CPPFLAGS)
Index: postgresql-previous/patches/patch-src_interfaces_libpq_Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile,v
diff -u -p -u -p -r1.6 patch-src_interfaces_libpq_Makefile
--- postgresql-previous/patches/patch-src_interfaces_libpq_Makefile	29 Nov 2023 23:41:30 -0000	1.6
+++ postgresql-previous/patches/patch-src_interfaces_libpq_Makefile	23 May 2024 15:44:48 -0000
@@ -10,5 +10,5 @@ Index: src/interfaces/libpq/Makefile
 +SO_MAJOR_VERSION= ${LIBpq_MAJOR}
 +SO_MINOR_VERSION= ${LIBpq_MINOR}
  
- override CPPFLAGS :=  -DFRONTEND -DUNSAFE_STAT_OK -I$(srcdir) $(CPPFLAGS) -I$(top_builddir)/src/port -I$(top_srcdir)/src/port
+ override CPPFLAGS :=  -I$(srcdir) $(CPPFLAGS) -I$(top_builddir)/src/port -I$(top_srcdir)/src/port
  ifneq ($(PORTNAME), win32)
Index: postgresql-previous/pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/pkg/PLIST,v
diff -u -p -u -p -r1.10 PLIST
--- postgresql-previous/pkg/PLIST	29 Nov 2023 23:41:30 -0000	1.10
+++ postgresql-previous/pkg/PLIST	23 May 2024 15:56:20 -0000
@@ -29,7 +29,6 @@ bin/${POSTGRESQL_DIR}/
 @bin bin/${POSTGRESQL_DIR}/pg_waldump
 @bin bin/${POSTGRESQL_DIR}/pgbench
 @bin bin/${POSTGRESQL_DIR}/postgres
-bin/${POSTGRESQL_DIR}/postmaster
 @bin bin/${POSTGRESQL_DIR}/psql
 @bin bin/${POSTGRESQL_DIR}/reindexdb
 @bin bin/${POSTGRESQL_DIR}/vacuumdb
@@ -116,6 +115,7 @@ include/${POSTGRESQL_DIR}/server/access/
 include/${POSTGRESQL_DIR}/server/access/relscan.h
 include/${POSTGRESQL_DIR}/server/access/rewriteheap.h
 include/${POSTGRESQL_DIR}/server/access/rmgr.h
+include/${POSTGRESQL_DIR}/server/access/rmgrdesc_utils.h
 include/${POSTGRESQL_DIR}/server/access/rmgrlist.h
 include/${POSTGRESQL_DIR}/server/access/sdir.h
 include/${POSTGRESQL_DIR}/server/access/session.h
@@ -149,6 +149,7 @@ include/${POSTGRESQL_DIR}/server/access/
 include/${POSTGRESQL_DIR}/server/access/xlog.h
 include/${POSTGRESQL_DIR}/server/access/xlog_internal.h
 include/${POSTGRESQL_DIR}/server/access/xlogarchive.h
+include/${POSTGRESQL_DIR}/server/access/xlogbackup.h
 include/${POSTGRESQL_DIR}/server/access/xlogdefs.h
 include/${POSTGRESQL_DIR}/server/access/xloginsert.h
 include/${POSTGRESQL_DIR}/server/access/xlogprefetcher.h
@@ -157,6 +158,9 @@ include/${POSTGRESQL_DIR}/server/access/
 include/${POSTGRESQL_DIR}/server/access/xlogrecovery.h
 include/${POSTGRESQL_DIR}/server/access/xlogstats.h
 include/${POSTGRESQL_DIR}/server/access/xlogutils.h
+include/${POSTGRESQL_DIR}/server/archive/
+include/${POSTGRESQL_DIR}/server/archive/archive_module.h
+include/${POSTGRESQL_DIR}/server/archive/shell_archive.h
 include/${POSTGRESQL_DIR}/server/bootstrap/
 include/${POSTGRESQL_DIR}/server/bootstrap/bootstrap.h
 include/${POSTGRESQL_DIR}/server/c.h
@@ -342,7 +346,6 @@ include/${POSTGRESQL_DIR}/server/command
 include/${POSTGRESQL_DIR}/server/commands/typecmds.h
 include/${POSTGRESQL_DIR}/server/commands/user.h
 include/${POSTGRESQL_DIR}/server/commands/vacuum.h
-include/${POSTGRESQL_DIR}/server/commands/variable.h
 include/${POSTGRESQL_DIR}/server/commands/view.h
 include/${POSTGRESQL_DIR}/server/common/
 include/${POSTGRESQL_DIR}/server/common/archive.h
@@ -368,6 +371,7 @@ include/${POSTGRESQL_DIR}/server/common/
 include/${POSTGRESQL_DIR}/server/common/logging.h
 include/${POSTGRESQL_DIR}/server/common/md5.h
 include/${POSTGRESQL_DIR}/server/common/openssl.h
+include/${POSTGRESQL_DIR}/server/common/percentrepl.h
 include/${POSTGRESQL_DIR}/server/common/pg_lzcompress.h
 include/${POSTGRESQL_DIR}/server/common/pg_prng.h
 include/${POSTGRESQL_DIR}/server/common/relpath.h
@@ -378,8 +382,8 @@ include/${POSTGRESQL_DIR}/server/common/
 include/${POSTGRESQL_DIR}/server/common/sha2.h
 include/${POSTGRESQL_DIR}/server/common/shortest_dec.h
 include/${POSTGRESQL_DIR}/server/common/string.h
-include/${POSTGRESQL_DIR}/server/common/unicode_combining_table.h
 include/${POSTGRESQL_DIR}/server/common/unicode_east_asian_fw_table.h
+include/${POSTGRESQL_DIR}/server/common/unicode_nonspacing_table.h
 include/${POSTGRESQL_DIR}/server/common/unicode_norm.h
 include/${POSTGRESQL_DIR}/server/common/unicode_norm_hashfunc.h
 include/${POSTGRESQL_DIR}/server/common/unicode_norm_table.h
@@ -478,7 +482,6 @@ include/${POSTGRESQL_DIR}/server/foreign
 include/${POSTGRESQL_DIR}/server/foreign/fdwapi.h
 include/${POSTGRESQL_DIR}/server/foreign/foreign.h
 include/${POSTGRESQL_DIR}/server/funcapi.h
-include/${POSTGRESQL_DIR}/server/getaddrinfo.h
 include/${POSTGRESQL_DIR}/server/getopt_long.h
 include/${POSTGRESQL_DIR}/server/jit/
 include/${POSTGRESQL_DIR}/server/jit/jit.h
@@ -506,6 +509,7 @@ include/${POSTGRESQL_DIR}/server/libpq/b
 include/${POSTGRESQL_DIR}/server/libpq/crypt.h
 include/${POSTGRESQL_DIR}/server/libpq/hba.h
 include/${POSTGRESQL_DIR}/server/libpq/ifaddr.h
+include/${POSTGRESQL_DIR}/server/libpq/libpq-be-fe-helpers.h
 include/${POSTGRESQL_DIR}/server/libpq/libpq-be.h
 include/${POSTGRESQL_DIR}/server/libpq/libpq-fs.h
 include/${POSTGRESQL_DIR}/server/libpq/libpq.h
@@ -526,8 +530,11 @@ include/${POSTGRESQL_DIR}/server/nodes/e
 include/${POSTGRESQL_DIR}/server/nodes/lockoptions.h
 include/${POSTGRESQL_DIR}/server/nodes/makefuncs.h
 include/${POSTGRESQL_DIR}/server/nodes/memnodes.h
+include/${POSTGRESQL_DIR}/server/nodes/miscnodes.h
+include/${POSTGRESQL_DIR}/server/nodes/multibitmapset.h
 include/${POSTGRESQL_DIR}/server/nodes/nodeFuncs.h
 include/${POSTGRESQL_DIR}/server/nodes/nodes.h
+include/${POSTGRESQL_DIR}/server/nodes/nodetags.h
 include/${POSTGRESQL_DIR}/server/nodes/params.h
 include/${POSTGRESQL_DIR}/server/nodes/parsenodes.h
 include/${POSTGRESQL_DIR}/server/nodes/pathnodes.h
@@ -535,6 +542,7 @@ include/${POSTGRESQL_DIR}/server/nodes/p
 include/${POSTGRESQL_DIR}/server/nodes/plannodes.h
 include/${POSTGRESQL_DIR}/server/nodes/primnodes.h
 include/${POSTGRESQL_DIR}/server/nodes/print.h
+include/${POSTGRESQL_DIR}/server/nodes/queryjumble.h
 include/${POSTGRESQL_DIR}/server/nodes/readfuncs.h
 include/${POSTGRESQL_DIR}/server/nodes/replnodes.h
 include/${POSTGRESQL_DIR}/server/nodes/subscripting.h
@@ -571,8 +579,6 @@ include/${POSTGRESQL_DIR}/server/optimiz
 include/${POSTGRESQL_DIR}/server/optimizer/tlist.h
 include/${POSTGRESQL_DIR}/server/parser/
 include/${POSTGRESQL_DIR}/server/parser/analyze.h
-include/${POSTGRESQL_DIR}/server/parser/gram.h
-include/${POSTGRESQL_DIR}/server/parser/gramparse.h
 include/${POSTGRESQL_DIR}/server/parser/kwlist.h
 include/${POSTGRESQL_DIR}/server/parser/parse_agg.h
 include/${POSTGRESQL_DIR}/server/parser/parse_clause.h
@@ -609,7 +615,7 @@ include/${POSTGRESQL_DIR}/server/pgstat.
 include/${POSTGRESQL_DIR}/server/pgtar.h
 include/${POSTGRESQL_DIR}/server/pgtime.h
 include/${POSTGRESQL_DIR}/server/plperl.h
-include/${POSTGRESQL_DIR}/server/plperl_helpers.h
+include/${POSTGRESQL_DIR}/server/plperl_system.h
 include/${POSTGRESQL_DIR}/server/plpgsql.h
 include/${POSTGRESQL_DIR}/server/port/
 include/${POSTGRESQL_DIR}/server/port.h
@@ -618,11 +624,9 @@ include/${POSTGRESQL_DIR}/server/port/at
 include/${POSTGRESQL_DIR}/server/port/atomics.h
 include/${POSTGRESQL_DIR}/server/port/atomics/arch-arm.h
 include/${POSTGRESQL_DIR}/server/port/atomics/arch-hppa.h
-include/${POSTGRESQL_DIR}/server/port/atomics/arch-ia64.h
 include/${POSTGRESQL_DIR}/server/port/atomics/arch-ppc.h
 include/${POSTGRESQL_DIR}/server/port/atomics/arch-x86.h
 include/${POSTGRESQL_DIR}/server/port/atomics/fallback.h
-include/${POSTGRESQL_DIR}/server/port/atomics/generic-acc.h
 include/${POSTGRESQL_DIR}/server/port/atomics/generic-gcc.h
 include/${POSTGRESQL_DIR}/server/port/atomics/generic-msvc.h
 include/${POSTGRESQL_DIR}/server/port/atomics/generic-sunpro.h
@@ -630,7 +634,6 @@ include/${POSTGRESQL_DIR}/server/port/at
 include/${POSTGRESQL_DIR}/server/port/cygwin.h
 include/${POSTGRESQL_DIR}/server/port/darwin.h
 include/${POSTGRESQL_DIR}/server/port/freebsd.h
-include/${POSTGRESQL_DIR}/server/port/hpux.h
 include/${POSTGRESQL_DIR}/server/port/linux.h
 include/${POSTGRESQL_DIR}/server/port/netbsd.h
 include/${POSTGRESQL_DIR}/server/port/openbsd.h
@@ -638,7 +641,9 @@ include/${POSTGRESQL_DIR}/server/port/pg
 include/${POSTGRESQL_DIR}/server/port/pg_bswap.h
 include/${POSTGRESQL_DIR}/server/port/pg_crc32c.h
 include/${POSTGRESQL_DIR}/server/port/pg_iovec.h
+include/${POSTGRESQL_DIR}/server/port/pg_lfind.h
 include/${POSTGRESQL_DIR}/server/port/pg_pthread.h
+include/${POSTGRESQL_DIR}/server/port/simd.h
 include/${POSTGRESQL_DIR}/server/port/solaris.h
 include/${POSTGRESQL_DIR}/server/port/win32/
 include/${POSTGRESQL_DIR}/server/port/win32.h
@@ -649,9 +654,13 @@ include/${POSTGRESQL_DIR}/server/port/wi
 include/${POSTGRESQL_DIR}/server/port/win32/netdb.h
 include/${POSTGRESQL_DIR}/server/port/win32/netinet/
 include/${POSTGRESQL_DIR}/server/port/win32/netinet/in.h
+include/${POSTGRESQL_DIR}/server/port/win32/netinet/tcp.h
 include/${POSTGRESQL_DIR}/server/port/win32/pwd.h
 include/${POSTGRESQL_DIR}/server/port/win32/sys/
+include/${POSTGRESQL_DIR}/server/port/win32/sys/resource.h
+include/${POSTGRESQL_DIR}/server/port/win32/sys/select.h
 include/${POSTGRESQL_DIR}/server/port/win32/sys/socket.h
+include/${POSTGRESQL_DIR}/server/port/win32/sys/un.h
 include/${POSTGRESQL_DIR}/server/port/win32/sys/wait.h
 include/${POSTGRESQL_DIR}/server/port/win32_msvc/
 include/${POSTGRESQL_DIR}/server/port/win32_msvc/dirent.h
@@ -717,7 +726,6 @@ include/${POSTGRESQL_DIR}/server/rewrite
 include/${POSTGRESQL_DIR}/server/rewrite/rewriteSearchCycle.h
 include/${POSTGRESQL_DIR}/server/rewrite/rewriteSupport.h
 include/${POSTGRESQL_DIR}/server/rewrite/rowsecurity.h
-include/${POSTGRESQL_DIR}/server/rusagestub.h
 include/${POSTGRESQL_DIR}/server/snowball/
 include/${POSTGRESQL_DIR}/server/snowball/header.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/
@@ -818,7 +826,7 @@ include/${POSTGRESQL_DIR}/server/storage
 include/${POSTGRESQL_DIR}/server/storage/proclist_types.h
 include/${POSTGRESQL_DIR}/server/storage/procsignal.h
 include/${POSTGRESQL_DIR}/server/storage/reinit.h
-include/${POSTGRESQL_DIR}/server/storage/relfilenode.h
+include/${POSTGRESQL_DIR}/server/storage/relfilelocator.h
 include/${POSTGRESQL_DIR}/server/storage/s_lock.h
 include/${POSTGRESQL_DIR}/server/storage/sharedfileset.h
 include/${POSTGRESQL_DIR}/server/storage/shm_mq.h
@@ -863,6 +871,7 @@ include/${POSTGRESQL_DIR}/server/utils/b
 include/${POSTGRESQL_DIR}/server/utils/cash.h
 include/${POSTGRESQL_DIR}/server/utils/catcache.h
 include/${POSTGRESQL_DIR}/server/utils/combocid.h
+include/${POSTGRESQL_DIR}/server/utils/conffiles.h
 include/${POSTGRESQL_DIR}/server/utils/date.h
 include/${POSTGRESQL_DIR}/server/utils/datetime.h
 include/${POSTGRESQL_DIR}/server/utils/datum.h
@@ -881,6 +890,7 @@ include/${POSTGRESQL_DIR}/server/utils/f
 include/${POSTGRESQL_DIR}/server/utils/freepage.h
 include/${POSTGRESQL_DIR}/server/utils/geo_decls.h
 include/${POSTGRESQL_DIR}/server/utils/guc.h
+include/${POSTGRESQL_DIR}/server/utils/guc_hooks.h
 include/${POSTGRESQL_DIR}/server/utils/guc_tables.h
 include/${POSTGRESQL_DIR}/server/utils/help_config.h
 include/${POSTGRESQL_DIR}/server/utils/hsearch.h
@@ -895,6 +905,8 @@ include/${POSTGRESQL_DIR}/server/utils/l
 include/${POSTGRESQL_DIR}/server/utils/lsyscache.h
 include/${POSTGRESQL_DIR}/server/utils/memdebug.h
 include/${POSTGRESQL_DIR}/server/utils/memutils.h
+include/${POSTGRESQL_DIR}/server/utils/memutils_internal.h
+include/${POSTGRESQL_DIR}/server/utils/memutils_memorychunk.h
 include/${POSTGRESQL_DIR}/server/utils/multirangetypes.h
 include/${POSTGRESQL_DIR}/server/utils/numeric.h
 include/${POSTGRESQL_DIR}/server/utils/old_snapshot.h
@@ -911,12 +923,11 @@ include/${POSTGRESQL_DIR}/server/utils/p
 include/${POSTGRESQL_DIR}/server/utils/probes.h
 include/${POSTGRESQL_DIR}/server/utils/ps_status.h
 include/${POSTGRESQL_DIR}/server/utils/queryenvironment.h
-include/${POSTGRESQL_DIR}/server/utils/queryjumble.h
 include/${POSTGRESQL_DIR}/server/utils/rangetypes.h
 include/${POSTGRESQL_DIR}/server/utils/regproc.h
 include/${POSTGRESQL_DIR}/server/utils/rel.h
 include/${POSTGRESQL_DIR}/server/utils/relcache.h
-include/${POSTGRESQL_DIR}/server/utils/relfilenodemap.h
+include/${POSTGRESQL_DIR}/server/utils/relfilenumbermap.h
 include/${POSTGRESQL_DIR}/server/utils/relmapper.h
 include/${POSTGRESQL_DIR}/server/utils/relptr.h
 include/${POSTGRESQL_DIR}/server/utils/reltrigger.h
@@ -938,12 +949,14 @@ include/${POSTGRESQL_DIR}/server/utils/t
 include/${POSTGRESQL_DIR}/server/utils/tuplestore.h
 include/${POSTGRESQL_DIR}/server/utils/typcache.h
 include/${POSTGRESQL_DIR}/server/utils/tzparser.h
+include/${POSTGRESQL_DIR}/server/utils/usercontext.h
 include/${POSTGRESQL_DIR}/server/utils/uuid.h
 include/${POSTGRESQL_DIR}/server/utils/varbit.h
 include/${POSTGRESQL_DIR}/server/utils/varlena.h
 include/${POSTGRESQL_DIR}/server/utils/wait_event.h
 include/${POSTGRESQL_DIR}/server/utils/xid8.h
 include/${POSTGRESQL_DIR}/server/utils/xml.h
+include/${POSTGRESQL_DIR}/server/varatt.h
 include/${POSTGRESQL_DIR}/server/windowapi.h
 include/${POSTGRESQL_DIR}/sql3types.h
 include/${POSTGRESQL_DIR}/sqlca.h
@@ -1141,6 +1154,7 @@ share/${POSTGRESQL_DIR}/extension/earthd
 share/${POSTGRESQL_DIR}/extension/file_fdw--1.0.sql
 share/${POSTGRESQL_DIR}/extension/file_fdw.control
 share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.0--1.1.sql
+share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.1--1.2.sql
 share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.1.sql
 share/${POSTGRESQL_DIR}/extension/fuzzystrmatch.control
 share/${POSTGRESQL_DIR}/extension/hstore--1.1--1.2.sql
@@ -1190,6 +1204,7 @@ share/${POSTGRESQL_DIR}/extension/old_sn
 share/${POSTGRESQL_DIR}/extension/pageinspect--1.0--1.1.sql
 share/${POSTGRESQL_DIR}/extension/pageinspect--1.1--1.2.sql
 share/${POSTGRESQL_DIR}/extension/pageinspect--1.10--1.11.sql
+share/${POSTGRESQL_DIR}/extension/pageinspect--1.11--1.12.sql
 share/${POSTGRESQL_DIR}/extension/pageinspect--1.2--1.3.sql
 share/${POSTGRESQL_DIR}/extension/pageinspect--1.3--1.4.sql
 share/${POSTGRESQL_DIR}/extension/pageinspect--1.4--1.5.sql
@@ -1204,6 +1219,7 @@ share/${POSTGRESQL_DIR}/extension/pg_buf
 share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.1--1.2.sql
 share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.2--1.3.sql
 share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.2.sql
+share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.3--1.4.sql
 share/${POSTGRESQL_DIR}/extension/pg_buffercache.control
 share/${POSTGRESQL_DIR}/extension/pg_freespacemap--1.0--1.1.sql
 share/${POSTGRESQL_DIR}/extension/pg_freespacemap--1.1--1.2.sql
@@ -1239,6 +1255,7 @@ share/${POSTGRESQL_DIR}/extension/pg_vis
 share/${POSTGRESQL_DIR}/extension/pg_visibility--1.1--1.2.sql
 share/${POSTGRESQL_DIR}/extension/pg_visibility--1.1.sql
 share/${POSTGRESQL_DIR}/extension/pg_visibility.control
+share/${POSTGRESQL_DIR}/extension/pg_walinspect--1.0--1.1.sql
 share/${POSTGRESQL_DIR}/extension/pg_walinspect--1.0.sql
 share/${POSTGRESQL_DIR}/extension/pg_walinspect.control
 share/${POSTGRESQL_DIR}/extension/pgcrypto--1.0--1.1.sql
@@ -1295,6 +1312,7 @@ share/${POSTGRESQL_DIR}/extension/uuid-o
 share/${POSTGRESQL_DIR}/extension/xml2--1.0--1.1.sql
 share/${POSTGRESQL_DIR}/extension/xml2--1.1.sql
 share/${POSTGRESQL_DIR}/extension/xml2.control
+share/${POSTGRESQL_DIR}/fix-CVE-2024-4317.sql
 share/${POSTGRESQL_DIR}/information_schema.sql
 share/${POSTGRESQL_DIR}/pg_hba.conf.sample
 share/${POSTGRESQL_DIR}/pg_ident.conf.sample