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

Reply via email to