Index | Thread | Search

From:
Jeremy Evans <jeremy@openbsd.org>
Subject:
Update: PostgreSQL 17.1
To:
Theo Buehler <tb@theobuehler.org>, OpenBSD ports <ports@openbsd.org>
Cc:
renato@renatoaguiar.net
Date:
Sun, 17 Nov 2024 21:57:39 +0000

Download raw body.

Thread
On 10/02 09:20, Theo Buehler wrote:
> > 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.
> 
> Seems less fallout than usual. Some of them have patches ready, others
> don't seem to have started.
> 
> 
> databases/citus
> 
> configure: error: Citus is not compatible with the detected PostgreSQL version 17.
> 
> https://github.com/citusdata/citus/issues?q=label%3Apg17_support
> 
> 
> databases/pg_sqlite_fdw
> 
> ===>  Building for pg_sqlite_fdw-2.4.0
> Makefile:41: *** PostgreSQL 12, 13, 14, 15 or 16 is required to compile this extension.  Stop.
> 
> https://github.com/pgspider/sqlite_fdw/issues/104
> 
> 
> databases/postgresql-pllua
> 
> ===> postgresql-pllua-2.0.12 depends on: postgresql-server->=16,<17 - not found
> ===> postgresql-pllua-2.0.12 depends on: postgresql-server->=16,<17 - default postgresql-server-17.0 does not match
> 
> 
> databases/repmgr
> 
> repmgr-client.c:3185:9: error: use of undeclared identifier 'PG_TEMP_FILE_PREFIX'
>                                                   PG_TEMP_FILE_PREFIX);
>                                                   ^
> 
> https://github.com/EnterpriseDB/repmgr/pull/863
> 
> 
> databases/timescaledb
> 
> CMake Error at CMakeLists.txt:355 (message):
>   TimescaleDB only supports PostgreSQL 14, 15 and 16
> 
> working on it:
> 
> https://github.com/timescale/timescaledb/pulls?q=is%3Apr+label%3Apg17

PostgreSQL 17.1 has been released.  Here's an updated patch that uses
it, and allows pg_sqlite_fdw, postgresql-pllua, repmgr, and timescaledb
to work.  It marks citus as BROKEN.  I'm guessing citus will be fixed
before the next release, but it is not ready yet, and I don't think we
should hold up the PostgreSQL 17 upgrade for it, just as we didn't hold
it up for timescaledb the last couple major PostgreSQL upgrades.

Can someone put this diff into a bulk and see if there is any breakage?
I wouldn't expect any, since we ran the bulk in early October for
PostgreSQl 17.0, and this handles all of that fallout, but you never
know.

Thanks,
Jeremy

Index: databases/citus/Makefile
===================================================================
RCS file: /cvs/ports/databases/citus/Makefile,v
diff -u -p -u -p -r1.23 Makefile
--- databases/citus/Makefile	25 Jun 2024 11:28:57 -0000	1.23
+++ databases/citus/Makefile	17 Nov 2024 20:25:19 -0000
@@ -1,3 +1,4 @@
+BROKEN =		No support yet for PostgreSQL 17
 COMMENT =		extension to horizontally scale PostgreSQL
 
 GH_ACCOUNT =		citusdata
Index: databases/pg_sqlite_fdw/patches/patch-Makefile
===================================================================
RCS file: databases/pg_sqlite_fdw/patches/patch-Makefile
diff -N databases/pg_sqlite_fdw/patches/patch-Makefile
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ databases/pg_sqlite_fdw/patches/patch-Makefile	17 Nov 2024 20:24:22 -0000
@@ -0,0 +1,16 @@
+Allow building on PostgreSQL 17.
+
+Index: Makefile
+--- Makefile.orig
++++ Makefile
+@@ -37,8 +37,8 @@ include $(PGXS)
+ ifndef MAJORVERSION
+ MAJORVERSION := $(basename $(VERSION))
+ endif
+-ifeq (,$(findstring $(MAJORVERSION), 12 13 14 15 16))
+-$(error PostgreSQL 12, 13, 14, 15 or 16 is required to compile this extension)
++ifeq (,$(findstring $(MAJORVERSION), 12 13 14 15 16 17))
++$(error PostgreSQL 12, 13, 14, 15, 16 or 17 is required to compile this extension)
+ endif
+ 
+ else
Index: databases/pg_sqlite_fdw/patches/patch-sqlite_fdw_c
===================================================================
RCS file: databases/pg_sqlite_fdw/patches/patch-sqlite_fdw_c
diff -N databases/pg_sqlite_fdw/patches/patch-sqlite_fdw_c
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ databases/pg_sqlite_fdw/patches/patch-sqlite_fdw_c	17 Nov 2024 20:24:32 -0000
@@ -0,0 +1,115 @@
+Support PostgreSQL 17.
+
+Index: sqlite_fdw.c
+--- sqlite_fdw.c.orig
++++ sqlite_fdw.c
+@@ -841,6 +841,9 @@ sqlite_add_paths_with_pathkeys_for_rel(PlannerInfo *ro
+ 											 NULL,	/* no outer rel either */
+ #endif
+ 											 sorted_epq_path,
++#if PG_VERSION_NUM >= 170000
++											 NULL,
++#endif
+ 											 fdw_private));
+ 		else
+ 			add_path(rel, (Path *)
+@@ -860,6 +863,9 @@ sqlite_add_paths_with_pathkeys_for_rel(PlannerInfo *ro
+ 											 NULL,	/* no outer rel either */
+ #endif
+ 											 sorted_epq_path,
++#if PG_VERSION_NUM >= 170000
++											 NULL,
++#endif
+ 											 fdw_private));
+ 	}
+ }
+@@ -955,6 +961,9 @@ sqliteGetForeignPaths(PlannerInfo *root, RelOptInfo *b
+ 									 NULL,	/* no outer rel either */
+ #endif
+ 									 NULL,	/* no extra plan */
++#if PG_VERSION_NUM >= 170000
++									 NULL,
++#endif
+ 									 fdw_private));
+ 
+ 	/* Add paths with pathkeys */
+@@ -1137,6 +1146,9 @@ sqliteGetForeignPaths(PlannerInfo *root, RelOptInfo *b
+ 									   NIL, /* no pathkeys */
+ 									   param_info->ppi_req_outer,
+ 									   NULL,
++#if PG_VERSION_NUM >= 170000
++									   NULL,
++#endif
+ 									   NIL);	/* no fdw_private list */
+ 		add_path(baserel, (Path *) path);
+ 	}
+@@ -3698,6 +3710,9 @@ sqliteGetForeignJoinPaths(PlannerInfo *root,
+ 									   NIL, /* no pathkeys */
+ 									   joinrel->lateral_relids,
+ 									   epq_path,
++#if PG_VERSION_NUM >= 170000
++									   NULL,
++#endif
+ 									   NIL);	/* no fdw_private */
+ 
+ 	/* Add generated path into joinrel by add_path(). */
+@@ -4144,6 +4159,9 @@ sqlite_add_foreign_grouping_paths(PlannerInfo *root, R
+ 										  total_cost,
+ 										  NIL,	/* no pathkeys */
+ 										  NULL,
++#if PG_VERSION_NUM >= 170000
++										  NULL,
++#endif
+ 										  NIL); /* no fdw_private */
+ #else
+ 	grouppath = create_foreignscan_path(root,
+@@ -4155,6 +4173,9 @@ sqlite_add_foreign_grouping_paths(PlannerInfo *root, R
+ 										NIL,	/* no pathkeys */
+ 										NULL,	/* no required_outer */
+ 										NULL,
++#if PG_VERSION_NUM >= 170000
++										NULL,
++#endif
+ 										NIL);	/* no fdw_private */
+ #endif
+ 
+@@ -4302,6 +4323,9 @@ sqlite_add_foreign_ordered_paths(PlannerInfo *root, Re
+ 											 total_cost,
+ 											 root->sort_pathkeys,
+ 											 NULL,	/* no extra plan */
++#if PG_VERSION_NUM >= 170000
++											 NULL,
++#endif
+ 											 fdw_private);
+ #else
+ 
+@@ -4323,6 +4347,9 @@ sqlite_add_foreign_ordered_paths(PlannerInfo *root, Re
+ 										   root->sort_pathkeys,
+ 										   NULL,
+ 										   NULL,	/* no extra plan */
++#if PG_VERSION_NUM >= 170000
++										   NULL,
++#endif
+ 										   fdw_private);
+ #endif
+ 
+@@ -4506,6 +4533,9 @@ sqlite_add_foreign_final_paths(PlannerInfo *root, RelO
+ 										   total_cost,
+ 										   pathkeys,
+ 										   NULL,	/* no extra plan */
++#if PG_VERSION_NUM >= 170000
++										   NULL,
++#endif
+ 										   fdw_private);
+ #else
+ 	final_path = create_foreignscan_path(root,
+@@ -4517,6 +4547,9 @@ sqlite_add_foreign_final_paths(PlannerInfo *root, RelO
+ 										 pathkeys,
+ 										 NULL,	/* no required_outer */
+ 										 NULL,	/* no extra plan */
++#if PG_VERSION_NUM >= 170000
++										 NULL,
++#endif
+ 										 fdw_private);
+ #endif
+ 	/* and add it to the final_rel */
Index: databases/postgresql/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
diff -u -p -u -p -r1.306 Makefile
--- databases/postgresql/Makefile	27 Aug 2024 06:51:18 -0000	1.306
+++ databases/postgresql/Makefile	14 Nov 2024 16:36:41 -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.1
+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: databases/postgresql/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
diff -u -p -u -p -r1.102 distinfo
--- databases/postgresql/distinfo	12 Aug 2024 17:32:01 -0000	1.102
+++ databases/postgresql/distinfo	17 Nov 2024 00:33:17 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-16.4.tar.gz) = LhepAGJAPhXWVASA/exQyLAF60hympHLSYn/6wTfGTw=
-SIZE (postgresql-16.4.tar.gz) = 32660355
+SHA256 (postgresql-17.1.tar.gz) = 9OGirdJAS3639RxplX8qlgqU6dYJiDt5hQ2ZbP1IWqY=
+SIZE (postgresql-17.1.tar.gz) = 27957918
Index: databases/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
--- databases/postgresql/patches/patch-src_bin_initdb_initdb_c	12 Aug 2024 17:32:01 -0000	1.3
+++ databases/postgresql/patches/patch-src_bin_initdb_initdb_c	14 Nov 2024 16:37:49 -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[])
+@@ -3502,6 +3502,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[])
+@@ -3533,6 +3543,7 @@ main(int argc, char *argv[])
  			   start_db_cmd->data);
  
  		destroyPQExpBuffer(start_db_cmd);
Index: databases/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
--- databases/postgresql/patches/patch-src_include_storage_s_lock_h	29 Nov 2023 23:41:15 -0000	1.11
+++ databases/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: databases/postgresql/pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
diff -u -p -u -p -r1.28 PLIST-contrib
--- databases/postgresql/pkg/PLIST-contrib	29 Nov 2023 23:41:15 -0000	1.28
+++ databases/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: databases/postgresql/pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
diff -u -p -u -p -r1.115 PLIST-docs
--- databases/postgresql/pkg/PLIST-docs	12 Aug 2024 17:32:01 -0000	1.115
+++ databases/postgresql/pkg/PLIST-docs	17 Nov 2024 00:32:43 -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,8 @@ 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-1.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 +745,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 +1114,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: databases/postgresql/pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
diff -u -p -u -p -r1.51 PLIST-server
--- databases/postgresql/pkg/PLIST-server	20 May 2024 19:14:05 -0000	1.51
+++ databases/postgresql/pkg/PLIST-server	17 Nov 2024 00:33:50 -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
@@ -444,8 +460,10 @@ include/postgresql/server/foreign/foreig
 include/postgresql/server/funcapi.h
 include/postgresql/server/getopt_long.h
 include/postgresql/server/jit/
+include/postgresql/server/jit/SectionMemoryManager.h
 include/postgresql/server/jit/jit.h
 include/postgresql/server/jit/llvmjit.h
+include/postgresql/server/jit/llvmjit_backport.h
 include/postgresql/server/jit/llvmjit_emit.h
 include/postgresql/server/lib/
 include/postgresql/server/lib/binaryheap.h
@@ -458,6 +476,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 +496,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 +611,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 +681,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 +703,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 +776,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 +783,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 +806,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 +819,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 +837,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 +894,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 +908,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 +930,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 +951,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 +995,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 +1005,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 +1017,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: databases/postgresql-pllua/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-pllua/Makefile,v
diff -u -p -u -p -r1.24 Makefile
--- databases/postgresql-pllua/Makefile	29 Nov 2023 23:42:00 -0000	1.24
+++ databases/postgresql-pllua/Makefile	2 Oct 2024 23:50:34 -0000
@@ -5,6 +5,7 @@ GH_ACCOUNT =		pllua
 GH_PROJECT =		pllua
 GH_TAGNAME =		REL_${VERSION:S/./_/g}
 PKGNAME =		postgresql-pllua-${VERSION}
+REVISION =		0
 
 CATEGORIES =		databases
 
@@ -21,8 +22,8 @@ MODULES =		lang/lua
 MODLUA_VERSION =	5.3
 
 BUILD_DEPENDS =		${RUN_DEPENDS} \
-			postgresql-client->=16,<17:databases/postgresql,-main
-RUN_DEPENDS =		postgresql-server->=16,<17:databases/postgresql,-server
+			postgresql-client->=17,<18:databases/postgresql,-main
+RUN_DEPENDS =		postgresql-server->=17,<18:databases/postgresql,-server
 
 USE_GMAKE =		Yes
 
Index: databases/postgresql-previous/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/Makefile,v
diff -u -p -u -p -r1.27 Makefile
--- databases/postgresql-previous/Makefile	27 Aug 2024 06:51:46 -0000	1.27
+++ databases/postgresql-previous/Makefile	14 Nov 2024 16:37:04 -0000
@@ -1,15 +1,14 @@
 COMMENT=	PostgreSQL RDBMS (previous version, for pg_upgrade)
 
-VERSION=	15.4
+VERSION=	16.5
 DISTNAME=	postgresql-${VERSION}
 PKGNAME=	postgresql-previous-${VERSION}
-REVISION=	0
 
 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 +17,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 +67,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: databases/postgresql-previous/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/distinfo,v
diff -u -p -u -p -r1.11 distinfo
--- databases/postgresql-previous/distinfo	29 Nov 2023 23:41:30 -0000	1.11
+++ databases/postgresql-previous/distinfo	14 Nov 2024 16:37:35 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-15.4.tar.gz) = DhHu5yPdflmmNAUrwb/JvmBeVcHMo/Zun8JdOjlPsDA=
-SIZE (postgresql-15.4.tar.gz) = 29978353
+SHA256 (postgresql-16.5.tar.gz) = 3L+Nsd8zSEZtqZnH4ZxqIiW+ImOpA03ah2ZgAuWyUaU=
+SIZE (postgresql-16.5.tar.gz) = 32714194
Index: databases/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
--- databases/postgresql-previous/patches/patch-src_backend_libpq_ip_c	11 Mar 2022 18:31:38 -0000	1.3
+++ databases/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: databases/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
--- databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h	29 Nov 2023 23:41:30 -0000	1.7
+++ databases/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: databases/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
--- databases/postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile	11 Mar 2022 18:31:38 -0000	1.5
+++ databases/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: databases/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
--- databases/postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile	11 Mar 2022 18:31:38 -0000	1.5
+++ databases/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: databases/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
--- databases/postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile	11 Mar 2022 18:31:38 -0000	1.5
+++ databases/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: databases/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
--- databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile	29 Nov 2023 23:41:30 -0000	1.6
+++ databases/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: databases/postgresql-previous/pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/pkg/PLIST,v
diff -u -p -u -p -r1.10 PLIST
--- databases/postgresql-previous/pkg/PLIST	29 Nov 2023 23:41:30 -0000	1.10
+++ databases/postgresql-previous/pkg/PLIST	14 Nov 2024 16:55:27 -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,11 +482,12 @@ 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/SectionMemoryManager.h
 include/${POSTGRESQL_DIR}/server/jit/jit.h
 include/${POSTGRESQL_DIR}/server/jit/llvmjit.h
+include/${POSTGRESQL_DIR}/server/jit/llvmjit_backport.h
 include/${POSTGRESQL_DIR}/server/jit/llvmjit_emit.h
 include/${POSTGRESQL_DIR}/server/lib/
 include/${POSTGRESQL_DIR}/server/lib/binaryheap.h
@@ -506,6 +511,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 +532,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 +544,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 +581,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 +617,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 +626,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 +636,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 +643,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 +656,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 +728,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 +828,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 +873,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 +892,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 +907,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 +925,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 +951,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 +1156,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 +1206,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 +1221,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 +1257,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 +1314,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
Index: databases/repmgr/Makefile
===================================================================
RCS file: /cvs/ports/databases/repmgr/Makefile,v
diff -u -p -u -p -r1.15 Makefile
--- databases/repmgr/Makefile	17 Apr 2024 20:15:48 -0000	1.15
+++ databases/repmgr/Makefile	17 Nov 2024 21:50:04 -0000
@@ -3,6 +3,11 @@ COMMENT =	HA and replication cluster man
 DISTNAME =	repmgr-5.4.1
 CATEGORIES =	databases
 HOMEPAGE =	https://repmgr.org/
+REVISION =	0
+
+SITES.github =	https://github.com/EnterpriseDB/repmgr/commit/
+PATCHFILES.github =	repmgr-pg17-fix{5abdbb0d39e77b9463857c60a53707fd6f2abc45}.patch
+PATCH_DIST_STRIP =	-p1
 
 # GPLv3
 PERMIT_PACKAGE =	Yes
Index: databases/repmgr/distinfo
===================================================================
RCS file: /cvs/ports/databases/repmgr/distinfo,v
diff -u -p -u -p -r1.7 distinfo
--- databases/repmgr/distinfo	17 Apr 2024 20:15:48 -0000	1.7
+++ databases/repmgr/distinfo	17 Nov 2024 21:50:07 -0000
@@ -1,2 +1,4 @@
 SHA256 (repmgr-5.4.1.tar.gz) = oY1hqZ310ma/KYVM4Q5pdmYXiLoJYF0yY9Y4WtRCOxA=
+SHA256 (repmgr-pg17-fix.patch) = 8bnAAEkso7WAxpQBCG9wfGdQFFrkvZE1y0LiyLZaFCw=
 SIZE (repmgr-5.4.1.tar.gz) = 461670
+SIZE (repmgr-pg17-fix.patch) = 749
Index: databases/timescaledb/Makefile
===================================================================
RCS file: /cvs/ports/databases/timescaledb/Makefile,v
diff -u -p -u -p -r1.26 Makefile
--- databases/timescaledb/Makefile	29 Aug 2024 15:44:08 -0000	1.26
+++ databases/timescaledb/Makefile	17 Nov 2024 21:40:59 -0000
@@ -2,7 +2,7 @@ COMMENT =	database designed to make SQL 
 
 GH_ACCOUNT =	timescale
 GH_PROJECT =	timescaledb
-GH_TAGNAME =	2.16.1
+GH_TAGNAME =	2.17.2
 
 EXTRAS_COMMIT =	52443a469a58d3f64a4e049889f468e8a149cc8f
 DIST_TUPLE +=	github timescale timescaledb-extras ${EXTRAS_COMMIT} _extras
Index: databases/timescaledb/distinfo
===================================================================
RCS file: /cvs/ports/databases/timescaledb/distinfo,v
diff -u -p -u -p -r1.23 distinfo
--- databases/timescaledb/distinfo	29 Aug 2024 15:44:08 -0000	1.23
+++ databases/timescaledb/distinfo	17 Nov 2024 21:40:59 -0000
@@ -1,4 +1,4 @@
 SHA256 (timescale-timescaledb-extras-52443a469a58d3f64a4e049889f468e8a149cc8f.tar.gz) = /fBZ0+p3BcPYlmf7Oj4cqXKF19YpWJaywrt0qGuZqvw=
-SHA256 (timescaledb-2.16.1.tar.gz) = wdJ9oR0Ns7lH7Qy/Y9IwQnpTL9gIYA3qnsOvxKtdcws=
+SHA256 (timescaledb-2.17.2.tar.gz) = svzCnpl1uIxTI677BiNGMmaUw5HVKvRhhvWlrQkTbUc=
 SIZE (timescale-timescaledb-extras-52443a469a58d3f64a4e049889f468e8a149cc8f.tar.gz) = 12981
-SIZE (timescaledb-2.16.1.tar.gz) = 7449327
+SIZE (timescaledb-2.17.2.tar.gz) = 7567447
Index: databases/timescaledb/pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/timescaledb/pkg/PLIST,v
diff -u -p -u -p -r1.24 PLIST
--- databases/timescaledb/pkg/PLIST	29 Aug 2024 15:44:09 -0000	1.24
+++ databases/timescaledb/pkg/PLIST	17 Nov 2024 21:40:59 -0000
@@ -22,6 +22,9 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.15.2--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.15.3--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.16.0--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.16.1--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.17.0--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.17.1--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.5.0--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.5.1--${GH_TAGNAME}.sql