From: Stuart Henderson Subject: Re: For Early Testing: PostgreSQL 18 To: Jeremy Evans Cc: Theo Buehler , OpenBSD ports , renato@renatoaguiar.net Date: Fri, 14 Nov 2025 18:59:56 +0000 On 2025/11/13 17:56, Jeremy Evans wrote: > On 10/06 07:28, Theo Buehler wrote: > > On Thu, Sep 25, 2025 at 05:41:48PM -0700, Jeremy Evans wrote: > > > This is for early testing and not intended for commit. It updates to the > > > latest version of PostgreSQL, released today. I've been testing all > > > betas and rc1 on amd64, without problems. > > > > > > As in previous PostgreSQL major releases, we don't plan to update the > > > tree until PostgreSQL 18.1. > > > > > > If someone could run a bulk with this and let me know about breakage, > > > I'll work on fixing the related ports. > > > > Only these four failed to build: > > > > databases/citus https://github.com/citusdata/citus/milestone/27 > > databases/pg_sqlite_fdw https://github.com/pgspider/sqlite_fdw/issues/117 > > databases/postgresql-pllua https://github.com/pllua/pllua/issues/18 > > databases/timescaledb https://github.com/timescale/timescaledb/pulls?q=is%3Apr+label%3Apg18+ > > PostgreSQL 18.1 was released today. In terms of the dependencies that > did not build correctly with PostgreSQL 18.0: > > databases/citus: PG 18 support not yet ready > databases/timescaledb: PG 18 supported in 2.23.0 > databases/pg_sqlite_fdw: PG 18 support not yet ready > databases/postgresql-pllua: GitHub PR adds PG 18 support > > This updates postgresql to 18.1 and postgresql-previous to 17.7. > Release notes for PG 18.1: > https://www.postgresql.org/docs/18/release-18-1.html > > This includes 2 CVE fixes, so postgresql in -stable should be > updated to 17.7. -current users of any of the "PG 18 support not yet ready" ports won't be able to update until they're fixed (plus the python switchover I just committed will be a pain too), so it would be good to get a 17.7 commit in first and wait for fast arch snaps before switching branch. > This updates timescaledb to 2.23.1, and uses the pllua PR patch. It > marks citus and pg_sqlite_fdw BROKEN. This follows our practice in > previous PostgreSQL major updates (when it was usually timescaledb > being marked BROKEN). > > For pg_sqlite_fdw, there is a fork with PG 18 support: > https://github.com/mkgrgis/sqlite_fdw > > The fork still has some test failures on PG 18, and hasn't been updated > in about 6 weeks. This doesn't use the fork, but if the main repository > doesn't support PG 18 before OpenBSD 7.9, we could consider switching to > it or using the related patches. > > OKs? > > Jeremy > > Index: postgresql/Makefile > =================================================================== > RCS file: /cvs/ports/databases/postgresql/Makefile,v > retrieving revision 1.312 > diff -u -p -u -p -r1.312 Makefile > --- postgresql/Makefile 1 Nov 2025 11:16:40 -0000 1.312 > +++ postgresql/Makefile 14 Nov 2025 01:24:37 -0000 > @@ -4,17 +4,11 @@ COMMENT-docs= PostgreSQL RDBMS documenta > COMMENT-contrib=PostgreSQL RDBMS contributions > COMMENT-plpython=Python procedural language for PostgreSQL > COMMENT-pg_upgrade=Support for upgrading PostgreSQL data from previous version > -REVISION-contrib= 0 > -REVISION-docs= 0 > -REVISION-pg_upgrade= 0 > -REVISION-plpython= 0 > -REVISION-server=0 > > -VERSION= 17.6 > -PREV_MAJOR= 16 > +VERSION= 18.1 > +PREV_MAJOR= 17 > DISTNAME= postgresql-${VERSION} > PKGNAME-main= postgresql-client-${VERSION} > -REVISION-main= 0 > > DPB_PROPERTIES= parallel > > @@ -22,7 +16,7 @@ CATEGORIES= databases > SHARED_LIBS= ecpg 7.10 \ > ecpg_compat 4.10 \ > pgtypes 4.9 \ > - pq 6.16 > + pq 6.17 > > HOMEPAGE= https://www.postgresql.org/ > > Index: postgresql/distinfo > =================================================================== > RCS file: /cvs/ports/databases/postgresql/distinfo,v > retrieving revision 1.106 > diff -u -p -u -p -r1.106 distinfo > --- postgresql/distinfo 19 Aug 2025 04:50:48 -0000 1.106 > +++ postgresql/distinfo 14 Nov 2025 01:24:37 -0000 > @@ -1,2 +1,2 @@ > -SHA256 (postgresql-17.6.tar.gz) = KRC4UoNnTaLa5qwT/l67qvPEgkRjlsujLmco08xzbYY= > -SIZE (postgresql-17.6.tar.gz) = 28141372 > +SHA256 (postgresql-18.1.tar.gz) = sPGMLWlz0qoCPPx3/tp4fXu+nDGjl30PBKwpiF+5jsQ= > +SIZE (postgresql-18.1.tar.gz) = 29294939 > Index: postgresql/patches/patch-src_bin_initdb_initdb_c > =================================================================== > RCS file: /cvs/ports/databases/postgresql/patches/patch-src_bin_initdb_initdb_c,v > retrieving revision 1.4 > diff -u -p -u -p -r1.4 patch-src_bin_initdb_initdb_c > --- postgresql/patches/patch-src_bin_initdb_initdb_c 23 Nov 2024 06:54:15 -0000 1.4 > +++ postgresql/patches/patch-src_bin_initdb_initdb_c 14 Nov 2025 01:24:37 -0000 > @@ -4,7 +4,7 @@ script handles. > Index: src/bin/initdb/initdb.c > --- src/bin/initdb/initdb.c.orig > +++ src/bin/initdb/initdb.c > -@@ -3502,6 +3502,16 @@ main(int argc, char *argv[]) > +@@ -3525,6 +3525,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 > */ > -@@ -3533,6 +3543,7 @@ main(int argc, char *argv[]) > +@@ -3556,6 +3566,7 @@ main(int argc, char *argv[]) > start_db_cmd->data); > > destroyPQExpBuffer(start_db_cmd); > Index: postgresql/patches/patch-src_include_storage_s_lock_h > =================================================================== > RCS file: /cvs/ports/databases/postgresql/patches/patch-src_include_storage_s_lock_h,v > retrieving revision 1.12 > diff -u -p -u -p -r1.12 patch-src_include_storage_s_lock_h > --- postgresql/patches/patch-src_include_storage_s_lock_h 23 Nov 2024 06:54:15 -0000 1.12 > +++ postgresql/patches/patch-src_include_storage_s_lock_h 14 Nov 2025 01:24:37 -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 > -@@ -651,6 +651,29 @@ tas(volatile slock_t *lock) > +@@ -583,6 +583,29 @@ tas(volatile slock_t *lock) > do { __asm__ __volatile__("" : : : "memory"); *(lock) = 0; } while (0) > #endif > > Index: postgresql/patches/patch-src_interfaces_libpq_Makefile > =================================================================== > RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v > retrieving revision 1.19 > diff -u -p -u -p -r1.19 patch-src_interfaces_libpq_Makefile > --- postgresql/patches/patch-src_interfaces_libpq_Makefile 19 Aug 2025 04:50:48 -0000 1.19 > +++ postgresql/patches/patch-src_interfaces_libpq_Makefile 14 Nov 2025 01:24:37 -0000 > @@ -1,7 +1,7 @@ > Index: src/interfaces/libpq/Makefile > --- src/interfaces/libpq/Makefile.orig > +++ src/interfaces/libpq/Makefile > -@@ -19,8 +19,8 @@ PGFILEDESC = "PostgreSQL Access Library" > +@@ -21,8 +21,8 @@ PGFILEDESC = "PostgreSQL Access Library" > > # shared library parameters > NAME= pq > Index: postgresql/pkg/PLIST-contrib > =================================================================== > RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v > retrieving revision 1.30 > diff -u -p -u -p -r1.30 PLIST-contrib > --- postgresql/pkg/PLIST-contrib 22 Feb 2025 03:15:44 -0000 1.30 > +++ postgresql/pkg/PLIST-contrib 14 Nov 2025 01:24:37 -0000 > @@ -36,6 +36,8 @@ > @so lib/postgresql/passwordcheck.so > @so lib/postgresql/pg_buffercache.so > @so lib/postgresql/pg_freespacemap.so > +@so lib/postgresql/pg_logicalinspect.so > +@so lib/postgresql/pg_overexplain.so > @so lib/postgresql/pg_prewarm.so > @so lib/postgresql/pg_stat_statements.so > @so lib/postgresql/pg_surgery.so > @@ -68,6 +70,7 @@ share/postgresql/extension/amcheck--1.0. > 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--1.4--1.5.sql > share/postgresql/extension/amcheck.control > share/postgresql/extension/autoinc--1.0.sql > share/postgresql/extension/autoinc.control > @@ -90,6 +93,7 @@ share/postgresql/extension/btree_gist--1 > share/postgresql/extension/btree_gist--1.4--1.5.sql > share/postgresql/extension/btree_gist--1.5--1.6.sql > share/postgresql/extension/btree_gist--1.6--1.7.sql > +share/postgresql/extension/btree_gist--1.7--1.8.sql > share/postgresql/extension/btree_gist.control > share/postgresql/extension/citext--1.0--1.1.sql > share/postgresql/extension/citext--1.1--1.2.sql > @@ -98,6 +102,8 @@ share/postgresql/extension/citext--1.3-- > share/postgresql/extension/citext--1.4--1.5.sql > share/postgresql/extension/citext--1.4.sql > share/postgresql/extension/citext--1.5--1.6.sql > +share/postgresql/extension/citext--1.6--1.7.sql > +share/postgresql/extension/citext--1.7--1.8.sql > share/postgresql/extension/citext.control > share/postgresql/extension/cube--1.0--1.1.sql > share/postgresql/extension/cube--1.1--1.2.sql > @@ -152,12 +158,14 @@ share/postgresql/extension/intarray.cont > share/postgresql/extension/isn--1.0--1.1.sql > share/postgresql/extension/isn--1.1--1.2.sql > share/postgresql/extension/isn--1.1.sql > +share/postgresql/extension/isn--1.2--1.3.sql > share/postgresql/extension/isn.control > share/postgresql/extension/jsonb_plperl--1.0.sql > share/postgresql/extension/jsonb_plperl.control > share/postgresql/extension/jsonb_plperlu--1.0.sql > share/postgresql/extension/jsonb_plperlu.control > share/postgresql/extension/lo--1.0--1.1.sql > +share/postgresql/extension/lo--1.1--1.2.sql > share/postgresql/extension/lo--1.1.sql > share/postgresql/extension/lo.control > share/postgresql/extension/ltree--1.0--1.1.sql > @@ -171,6 +179,7 @@ share/postgresql/extension/pageinspect-- > share/postgresql/extension/pageinspect--1.1--1.2.sql > share/postgresql/extension/pageinspect--1.10--1.11.sql > share/postgresql/extension/pageinspect--1.11--1.12.sql > +share/postgresql/extension/pageinspect--1.12--1.13.sql > share/postgresql/extension/pageinspect--1.2--1.3.sql > share/postgresql/extension/pageinspect--1.3--1.4.sql > share/postgresql/extension/pageinspect--1.4--1.5.sql > @@ -187,11 +196,15 @@ share/postgresql/extension/pg_buffercach > 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--1.5--1.6.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 > share/postgresql/extension/pg_freespacemap--1.1.sql > +share/postgresql/extension/pg_freespacemap--1.2--1.3.sql > share/postgresql/extension/pg_freespacemap.control > +share/postgresql/extension/pg_logicalinspect--1.0.sql > +share/postgresql/extension/pg_logicalinspect.control > share/postgresql/extension/pg_prewarm--1.0--1.1.sql > share/postgresql/extension/pg_prewarm--1.1--1.2.sql > share/postgresql/extension/pg_prewarm--1.1.sql > @@ -199,6 +212,7 @@ share/postgresql/extension/pg_prewarm.co > 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.11--1.12.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 > @@ -229,6 +243,7 @@ share/postgresql/extension/pg_walinspect > share/postgresql/extension/pgcrypto--1.0--1.1.sql > share/postgresql/extension/pgcrypto--1.1--1.2.sql > share/postgresql/extension/pgcrypto--1.2--1.3.sql > +share/postgresql/extension/pgcrypto--1.3--1.4.sql > share/postgresql/extension/pgcrypto--1.3.sql > share/postgresql/extension/pgcrypto.control > share/postgresql/extension/pgrowlocks--1.0--1.1.sql > @@ -244,6 +259,7 @@ share/postgresql/extension/pgstattuple-- > share/postgresql/extension/pgstattuple.control > share/postgresql/extension/postgres_fdw--1.0--1.1.sql > share/postgresql/extension/postgres_fdw--1.0.sql > +share/postgresql/extension/postgres_fdw--1.1--1.2.sql > share/postgresql/extension/postgres_fdw.control > share/postgresql/extension/refint--1.0.sql > share/postgresql/extension/refint.control > @@ -272,5 +288,6 @@ share/postgresql/extension/uuid-ossp--1. > share/postgresql/extension/uuid-ossp--1.1.sql > share/postgresql/extension/uuid-ossp.control > share/postgresql/extension/xml2--1.0--1.1.sql > +share/postgresql/extension/xml2--1.1--1.2.sql > share/postgresql/extension/xml2--1.1.sql > share/postgresql/extension/xml2.control > Index: postgresql/pkg/PLIST-docs > =================================================================== > RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v > retrieving revision 1.119 > diff -u -p -u -p -r1.119 PLIST-docs > --- postgresql/pkg/PLIST-docs 19 Aug 2025 04:50:48 -0000 1.119 > +++ postgresql/pkg/PLIST-docs 14 Nov 2025 01:24:37 -0000 > @@ -56,6 +56,7 @@ share/doc/postgresql/html/auth-delay.htm > share/doc/postgresql/html/auth-ident.html > share/doc/postgresql/html/auth-ldap.html > share/doc/postgresql/html/auth-methods.html > +share/doc/postgresql/html/auth-oauth.html > share/doc/postgresql/html/auth-pam.html > share/doc/postgresql/html/auth-password.html > share/doc/postgresql/html/auth-peer.html > @@ -305,7 +306,6 @@ share/doc/postgresql/html/event-trigger- > share/doc/postgresql/html/event-trigger-definition.html > share/doc/postgresql/html/event-trigger-example.html > share/doc/postgresql/html/event-trigger-interface.html > -share/doc/postgresql/html/event-trigger-matrix.html > share/doc/postgresql/html/event-trigger-table-rewrite-example.html > share/doc/postgresql/html/event-triggers.html > share/doc/postgresql/html/executor.html > @@ -508,6 +508,7 @@ share/doc/postgresql/html/libpq-ldap.htm > share/doc/postgresql/html/libpq-misc.html > share/doc/postgresql/html/libpq-notice-processing.html > share/doc/postgresql/html/libpq-notify.html > +share/doc/postgresql/html/libpq-oauth.html > share/doc/postgresql/html/libpq-pgpass.html > share/doc/postgresql/html/libpq-pgservice.html > share/doc/postgresql/html/libpq-pipeline-mode.html > @@ -531,6 +532,7 @@ share/doc/postgresql/html/logical-replic > 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-gencols.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 > @@ -538,6 +540,7 @@ share/doc/postgresql/html/logical-replic > share/doc/postgresql/html/logical-replication-row-filter.html > share/doc/postgresql/html/logical-replication-security.html > share/doc/postgresql/html/logical-replication-subscription.html > +share/doc/postgresql/html/logical-replication-upgrade.html > share/doc/postgresql/html/logical-replication.html > share/doc/postgresql/html/logicaldecoding-catalogs.html > share/doc/postgresql/html/logicaldecoding-example.html > @@ -574,6 +577,10 @@ share/doc/postgresql/html/nls-translator > share/doc/postgresql/html/nls.html > share/doc/postgresql/html/non-durability.html > share/doc/postgresql/html/notation.html > +share/doc/postgresql/html/oauth-validator-callbacks.html > +share/doc/postgresql/html/oauth-validator-design.html > +share/doc/postgresql/html/oauth-validator-init.html > +share/doc/postgresql/html/oauth-validators.html > share/doc/postgresql/html/oid2name.html > share/doc/postgresql/html/overview.html > share/doc/postgresql/html/pageinspect.html > @@ -590,6 +597,8 @@ share/doc/postgresql/html/pgbench.html > share/doc/postgresql/html/pgbuffercache.html > share/doc/postgresql/html/pgcrypto.html > share/doc/postgresql/html/pgfreespacemap.html > +share/doc/postgresql/html/pglogicalinspect.html > +share/doc/postgresql/html/pgoverexplain.html > share/doc/postgresql/html/pgprewarm.html > share/doc/postgresql/html/pgrowlocks.html > share/doc/postgresql/html/pgstatstatements.html > @@ -695,13 +704,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-17-1.html > -share/doc/postgresql/html/release-17-2.html > -share/doc/postgresql/html/release-17-3.html > -share/doc/postgresql/html/release-17-4.html > -share/doc/postgresql/html/release-17-5.html > -share/doc/postgresql/html/release-17-6.html > -share/doc/postgresql/html/release-17.html > +share/doc/postgresql/html/release-18-1.html > +share/doc/postgresql/html/release-18.html > share/doc/postgresql/html/release-prior.html > share/doc/postgresql/html/release.html > share/doc/postgresql/html/replication-origins.html > @@ -721,7 +725,6 @@ share/doc/postgresql/html/rules-triggers > share/doc/postgresql/html/rules-update.html > share/doc/postgresql/html/rules-views.html > share/doc/postgresql/html/rules.html > -share/doc/postgresql/html/runtime-config-autovacuum.html > share/doc/postgresql/html/runtime-config-client.html > share/doc/postgresql/html/runtime-config-compatible.html > share/doc/postgresql/html/runtime-config-connection.html > @@ -737,6 +740,7 @@ share/doc/postgresql/html/runtime-config > share/doc/postgresql/html/runtime-config-resource.html > share/doc/postgresql/html/runtime-config-short.html > share/doc/postgresql/html/runtime-config-statistics.html > +share/doc/postgresql/html/runtime-config-vacuum.html > share/doc/postgresql/html/runtime-config-wal.html > share/doc/postgresql/html/runtime-config.html > share/doc/postgresql/html/runtime.html > @@ -1085,6 +1089,7 @@ share/doc/postgresql/html/user-manag.htm > share/doc/postgresql/html/using-explain.html > share/doc/postgresql/html/uuid-ossp.html > share/doc/postgresql/html/vacuumlo.html > +share/doc/postgresql/html/view-pg-aios.html > share/doc/postgresql/html/view-pg-available-extension-versions.html > share/doc/postgresql/html/view-pg-available-extensions.html > share/doc/postgresql/html/view-pg-backend-memory-contexts.html > @@ -1109,6 +1114,7 @@ share/doc/postgresql/html/view-pg-seclab > share/doc/postgresql/html/view-pg-sequences.html > share/doc/postgresql/html/view-pg-settings.html > share/doc/postgresql/html/view-pg-shadow.html > +share/doc/postgresql/html/view-pg-shmem-allocations-numa.html > share/doc/postgresql/html/view-pg-shmem-allocations.html > share/doc/postgresql/html/view-pg-stats-ext-exprs.html > share/doc/postgresql/html/view-pg-stats-ext.html > Index: postgresql/pkg/PLIST-main > =================================================================== > RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v > retrieving revision 1.36 > diff -u -p -u -p -r1.36 PLIST-main > --- postgresql/pkg/PLIST-main 16 Nov 2022 02:59:23 -0000 1.36 > +++ postgresql/pkg/PLIST-main 14 Nov 2025 01:24:37 -0000 > @@ -41,7 +41,6 @@ include/postgresql/libpq-events.h > include/postgresql/libpq-fe.h > include/postgresql/libpq/libpq-fs.h > include/postgresql/pg_config.h > -include/postgresql/pg_config_ext.h > include/postgresql/pg_config_manual.h > include/postgresql/pg_config_os.h > include/postgresql/pgtypes.h > Index: postgresql/pkg/PLIST-server > =================================================================== > RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v > retrieving revision 1.52 > diff -u -p -u -p -r1.52 PLIST-server > --- postgresql/pkg/PLIST-server 23 Nov 2024 06:54:15 -0000 1.52 > +++ postgresql/pkg/PLIST-server 14 Nov 2025 01:24:38 -0000 > @@ -47,12 +47,14 @@ include/postgresql/server/access/brin_tu > include/postgresql/server/access/brin_xlog.h > include/postgresql/server/access/bufmask.h > include/postgresql/server/access/clog.h > +include/postgresql/server/access/cmptype.h > include/postgresql/server/access/commit_ts.h > include/postgresql/server/access/detoast.h > include/postgresql/server/access/genam.h > include/postgresql/server/access/generic_xlog.h > include/postgresql/server/access/gin.h > include/postgresql/server/access/gin_private.h > +include/postgresql/server/access/gin_tuple.h > include/postgresql/server/access/ginblock.h > include/postgresql/server/access/ginxlog.h > include/postgresql/server/access/gist.h > @@ -287,6 +289,7 @@ include/postgresql/server/commands/colla > include/postgresql/server/commands/comment.h > include/postgresql/server/commands/conversioncmds.h > include/postgresql/server/commands/copy.h > +include/postgresql/server/commands/copyapi.h > include/postgresql/server/commands/copyfrom_internal.h > include/postgresql/server/commands/createas.h > include/postgresql/server/commands/dbcommands.h > @@ -295,6 +298,9 @@ include/postgresql/server/commands/defre > include/postgresql/server/commands/discard.h > include/postgresql/server/commands/event_trigger.h > include/postgresql/server/commands/explain.h > +include/postgresql/server/commands/explain_dr.h > +include/postgresql/server/commands/explain_format.h > +include/postgresql/server/commands/explain_state.h > include/postgresql/server/commands/extension.h > include/postgresql/server/commands/lockcmds.h > include/postgresql/server/commands/matview.h > @@ -340,6 +346,7 @@ include/postgresql/server/common/kwlooku > include/postgresql/server/common/link-canary.h > include/postgresql/server/common/logging.h > include/postgresql/server/common/md5.h > +include/postgresql/server/common/oauth-common.h > include/postgresql/server/common/openssl.h > include/postgresql/server/common/parse_manifest.h > include/postgresql/server/common/percentrepl.h > @@ -372,6 +379,7 @@ include/postgresql/server/executor/execA > include/postgresql/server/executor/execExpr.h > include/postgresql/server/executor/execParallel.h > include/postgresql/server/executor/execPartition.h > +include/postgresql/server/executor/execScan.h > include/postgresql/server/executor/execdebug.h > include/postgresql/server/executor/execdesc.h > include/postgresql/server/executor/executor.h > @@ -440,6 +448,7 @@ include/postgresql/server/extension/seg/ > include/postgresql/server/extension/seg/segdata.h > include/postgresql/server/fe_utils/ > include/postgresql/server/fe_utils/archive.h > +include/postgresql/server/fe_utils/astreamer.h > include/postgresql/server/fe_utils/cancel.h > include/postgresql/server/fe_utils/conditional.h > include/postgresql/server/fe_utils/connect_utils.h > @@ -492,6 +501,8 @@ include/postgresql/server/libpq/libpq-be > include/postgresql/server/libpq/libpq-be.h > include/postgresql/server/libpq/libpq-fs.h > include/postgresql/server/libpq/libpq.h > +include/postgresql/server/libpq/oauth.h > +include/postgresql/server/libpq/pg-gssapi.h > include/postgresql/server/libpq/pqcomm.h > include/postgresql/server/libpq/pqformat.h > include/postgresql/server/libpq/pqmq.h > @@ -586,7 +597,6 @@ include/postgresql/server/partitioning/p > include/postgresql/server/partitioning/partdesc.h > include/postgresql/server/partitioning/partprune.h > include/postgresql/server/pg_config.h > -include/postgresql/server/pg_config_ext.h > include/postgresql/server/pg_config_manual.h > include/postgresql/server/pg_config_os.h > include/postgresql/server/pg_getopt.h > @@ -614,7 +624,6 @@ include/postgresql/server/port.h > include/postgresql/server/port/atomics/ > include/postgresql/server/port/atomics.h > include/postgresql/server/port/atomics/arch-arm.h > -include/postgresql/server/port/atomics/arch-hppa.h > include/postgresql/server/port/atomics/arch-ppc.h > include/postgresql/server/port/atomics/arch-x86.h > include/postgresql/server/port/atomics/fallback.h > @@ -633,6 +642,7 @@ include/postgresql/server/port/pg_bswap. > include/postgresql/server/port/pg_crc32c.h > include/postgresql/server/port/pg_iovec.h > include/postgresql/server/port/pg_lfind.h > +include/postgresql/server/port/pg_numa.h > include/postgresql/server/port/pg_pthread.h > include/postgresql/server/port/simd.h > include/postgresql/server/port/solaris.h > @@ -691,6 +701,7 @@ include/postgresql/server/regex/regex.h > include/postgresql/server/regex/regexport.h > include/postgresql/server/regex/regguts.h > include/postgresql/server/replication/ > +include/postgresql/server/replication/conflict.h > include/postgresql/server/replication/decode.h > include/postgresql/server/replication/logical.h > include/postgresql/server/replication/logicallauncher.h > @@ -705,6 +716,7 @@ include/postgresql/server/replication/re > include/postgresql/server/replication/slot.h > include/postgresql/server/replication/slotsync.h > include/postgresql/server/replication/snapbuild.h > +include/postgresql/server/replication/snapbuild_internal.h > include/postgresql/server/replication/syncrep.h > include/postgresql/server/replication/walreceiver.h > include/postgresql/server/replication/walsender.h > @@ -741,7 +753,6 @@ include/postgresql/server/snowball/libst > include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_spanish.h > include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_swedish.h > include/postgresql/server/snowball/libstemmer/stem_ISO_8859_2_hungarian.h > -include/postgresql/server/snowball/libstemmer/stem_ISO_8859_2_romanian.h > include/postgresql/server/snowball/libstemmer/stem_KOI8_R_russian.h > include/postgresql/server/snowball/libstemmer/stem_UTF_8_arabic.h > include/postgresql/server/snowball/libstemmer/stem_UTF_8_armenian.h > @@ -750,6 +761,7 @@ include/postgresql/server/snowball/libst > include/postgresql/server/snowball/libstemmer/stem_UTF_8_danish.h > include/postgresql/server/snowball/libstemmer/stem_UTF_8_dutch.h > include/postgresql/server/snowball/libstemmer/stem_UTF_8_english.h > +include/postgresql/server/snowball/libstemmer/stem_UTF_8_estonian.h > include/postgresql/server/snowball/libstemmer/stem_UTF_8_finnish.h > include/postgresql/server/snowball/libstemmer/stem_UTF_8_french.h > include/postgresql/server/snowball/libstemmer/stem_UTF_8_german.h > @@ -774,8 +786,13 @@ include/postgresql/server/snowball/libst > include/postgresql/server/snowball/libstemmer/stem_UTF_8_yiddish.h > include/postgresql/server/statistics/ > include/postgresql/server/statistics/extended_stats_internal.h > +include/postgresql/server/statistics/stat_utils.h > include/postgresql/server/statistics/statistics.h > include/postgresql/server/storage/ > +include/postgresql/server/storage/aio.h > +include/postgresql/server/storage/aio_internal.h > +include/postgresql/server/storage/aio_subsys.h > +include/postgresql/server/storage/aio_types.h > include/postgresql/server/storage/barrier.h > include/postgresql/server/storage/block.h > include/postgresql/server/storage/buf.h > @@ -796,6 +813,7 @@ include/postgresql/server/storage/filese > include/postgresql/server/storage/freespace.h > include/postgresql/server/storage/fsm_internals.h > include/postgresql/server/storage/indexfsm.h > +include/postgresql/server/storage/io_worker.h > include/postgresql/server/storage/ipc.h > include/postgresql/server/storage/item.h > include/postgresql/server/storage/itemid.h > @@ -836,6 +854,7 @@ include/postgresql/server/storage/spin.h > include/postgresql/server/storage/standby.h > include/postgresql/server/storage/standbydefs.h > include/postgresql/server/storage/sync.h > +include/postgresql/server/storage/waiteventset.h > include/postgresql/server/tcop/ > include/postgresql/server/tcop/backend_startup.h > include/postgresql/server/tcop/cmdtag.h > @@ -886,6 +905,7 @@ include/postgresql/server/utils/fmgrprot > include/postgresql/server/utils/fmgrtab.h > include/postgresql/server/utils/formatting.h > include/postgresql/server/utils/freepage.h > +include/postgresql/server/utils/funccache.h > include/postgresql/server/utils/geo_decls.h > include/postgresql/server/utils/guc.h > include/postgresql/server/utils/guc_hooks.h > @@ -915,6 +935,7 @@ include/postgresql/server/utils/pg_local > include/postgresql/server/utils/pg_lsn.h > include/postgresql/server/utils/pg_rusage.h > include/postgresql/server/utils/pgstat_internal.h > +include/postgresql/server/utils/pgstat_kind.h > include/postgresql/server/utils/pidfile.h > include/postgresql/server/utils/plancache.h > include/postgresql/server/utils/portal.h > @@ -935,6 +956,7 @@ include/postgresql/server/utils/ruleutil > include/postgresql/server/utils/sampling.h > include/postgresql/server/utils/selfuncs.h > include/postgresql/server/utils/sharedtuplestore.h > +include/postgresql/server/utils/skipsupport.h > include/postgresql/server/utils/snapmgr.h > include/postgresql/server/utils/snapshot.h > include/postgresql/server/utils/sortsupport.h > @@ -950,6 +972,7 @@ include/postgresql/server/utils/usercont > include/postgresql/server/utils/uuid.h > include/postgresql/server/utils/varbit.h > include/postgresql/server/utils/varlena.h > +include/postgresql/server/utils/wait_classes.h > include/postgresql/server/utils/wait_event.h > include/postgresql/server/utils/wait_event_types.h > include/postgresql/server/utils/xid8.h > Index: postgresql-previous/Makefile > =================================================================== > RCS file: /cvs/ports/databases/postgresql-previous/Makefile,v > retrieving revision 1.28 > diff -u -p -u -p -r1.28 Makefile > --- postgresql-previous/Makefile 23 Nov 2024 06:55:02 -0000 1.28 > +++ postgresql-previous/Makefile 14 Nov 2025 01:24:38 -0000 > @@ -1,6 +1,6 @@ > COMMENT= PostgreSQL RDBMS (previous version, for pg_upgrade) > > -VERSION= 16.6 > +VERSION= 17.7 > DISTNAME= postgresql-${VERSION} > PKGNAME= postgresql-previous-${VERSION} > > @@ -8,7 +8,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/ > > Index: postgresql-previous/distinfo > =================================================================== > RCS file: /cvs/ports/databases/postgresql-previous/distinfo,v > retrieving revision 1.12 > diff -u -p -u -p -r1.12 distinfo > --- postgresql-previous/distinfo 23 Nov 2024 06:55:02 -0000 1.12 > +++ postgresql-previous/distinfo 14 Nov 2025 01:24:38 -0000 > @@ -1,2 +1,2 @@ > -SHA256 (postgresql-16.6.tar.gz) = Ug0XNjLpNQfybrZnE9lTtofPul5yxGfTrbyOxNu4FI8= > -SIZE (postgresql-16.6.tar.gz) = 32715613 > +SHA256 (postgresql-17.7.tar.gz) = Sp6UIE4mWykrCzZTTDhUPyT52W9UE86sSJ7wUwgq51I= > +SIZE (postgresql-17.7.tar.gz) = 28186920 > Index: postgresql-previous/patches/patch-src_include_storage_s_lock_h > =================================================================== > RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h,v > retrieving revision 1.8 > diff -u -p -u -p -r1.8 patch-src_include_storage_s_lock_h > --- postgresql-previous/patches/patch-src_include_storage_s_lock_h 23 Nov 2024 06:55:02 -0000 1.8 > +++ postgresql-previous/patches/patch-src_include_storage_s_lock_h 14 Nov 2025 01:24:38 -0000 > @@ -1,7 +1,7 @@ > Index: src/include/storage/s_lock.h > --- src/include/storage/s_lock.h.orig > +++ src/include/storage/s_lock.h > -@@ -655,6 +655,29 @@ tas(volatile slock_t *lock) > +@@ -651,6 +651,29 @@ tas(volatile slock_t *lock) > do { __asm__ __volatile__("" : : : "memory"); *(lock) = 0; } while (0) > #endif > > Index: postgresql-previous/patches/patch-src_interfaces_libpq_Makefile > =================================================================== > RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile,v > retrieving revision 1.7 > diff -u -p -u -p -r1.7 patch-src_interfaces_libpq_Makefile > --- postgresql-previous/patches/patch-src_interfaces_libpq_Makefile 23 Nov 2024 06:55:02 -0000 1.7 > +++ postgresql-previous/patches/patch-src_interfaces_libpq_Makefile 14 Nov 2025 01:24:38 -0000 > @@ -10,5 +10,5 @@ Index: src/interfaces/libpq/Makefile > +SO_MAJOR_VERSION= ${LIBpq_MAJOR} > +SO_MINOR_VERSION= ${LIBpq_MINOR} > > - override CPPFLAGS := -I$(srcdir) $(CPPFLAGS) -I$(top_builddir)/src/port -I$(top_srcdir)/src/port > + override CPPFLAGS := -I$(srcdir) -I$(top_builddir)/src/port -I$(top_srcdir)/src/port $(CPPFLAGS) > ifneq ($(PORTNAME), win32) > Index: postgresql-previous/pkg/PLIST > =================================================================== > RCS file: /cvs/ports/databases/postgresql-previous/pkg/PLIST,v > retrieving revision 1.11 > diff -u -p -u -p -r1.11 PLIST > --- postgresql-previous/pkg/PLIST 23 Nov 2024 06:55:03 -0000 1.11 > +++ postgresql-previous/pkg/PLIST 14 Nov 2025 01:24:38 -0000 > @@ -11,8 +11,10 @@ bin/${POSTGRESQL_DIR}/ > @bin bin/${POSTGRESQL_DIR}/pg_archivecleanup > @bin bin/${POSTGRESQL_DIR}/pg_basebackup > @bin bin/${POSTGRESQL_DIR}/pg_checksums > +@bin bin/${POSTGRESQL_DIR}/pg_combinebackup > @bin bin/${POSTGRESQL_DIR}/pg_config > @bin bin/${POSTGRESQL_DIR}/pg_controldata > +@bin bin/${POSTGRESQL_DIR}/pg_createsubscriber > @bin bin/${POSTGRESQL_DIR}/pg_ctl > @bin bin/${POSTGRESQL_DIR}/pg_dump > @bin bin/${POSTGRESQL_DIR}/pg_dumpall > @@ -27,6 +29,7 @@ bin/${POSTGRESQL_DIR}/ > @bin bin/${POSTGRESQL_DIR}/pg_upgrade > @bin bin/${POSTGRESQL_DIR}/pg_verifybackup > @bin bin/${POSTGRESQL_DIR}/pg_waldump > +@bin bin/${POSTGRESQL_DIR}/pg_walsummary > @bin bin/${POSTGRESQL_DIR}/pgbench > @bin bin/${POSTGRESQL_DIR}/postgres > @bin bin/${POSTGRESQL_DIR}/psql > @@ -50,6 +53,7 @@ include/${POSTGRESQL_DIR}/internal/fe-au > include/${POSTGRESQL_DIR}/internal/libpq/ > include/${POSTGRESQL_DIR}/internal/libpq-int.h > include/${POSTGRESQL_DIR}/internal/libpq/pqcomm.h > +include/${POSTGRESQL_DIR}/internal/libpq/protocol.h > include/${POSTGRESQL_DIR}/internal/port.h > include/${POSTGRESQL_DIR}/internal/postgres_fe.h > include/${POSTGRESQL_DIR}/internal/pqexpbuffer.h > @@ -118,6 +122,7 @@ include/${POSTGRESQL_DIR}/server/access/ > 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/sequence.h > include/${POSTGRESQL_DIR}/server/access/session.h > include/${POSTGRESQL_DIR}/server/access/skey.h > include/${POSTGRESQL_DIR}/server/access/slru.h > @@ -130,6 +135,7 @@ include/${POSTGRESQL_DIR}/server/access/ > include/${POSTGRESQL_DIR}/server/access/sysattr.h > include/${POSTGRESQL_DIR}/server/access/table.h > include/${POSTGRESQL_DIR}/server/access/tableam.h > +include/${POSTGRESQL_DIR}/server/access/tidstore.h > include/${POSTGRESQL_DIR}/server/access/timeline.h > include/${POSTGRESQL_DIR}/server/access/toast_compression.h > include/${POSTGRESQL_DIR}/server/access/toast_helper.h > @@ -309,6 +315,8 @@ include/${POSTGRESQL_DIR}/server/catalog > include/${POSTGRESQL_DIR}/server/catalog/schemapg.h > include/${POSTGRESQL_DIR}/server/catalog/storage.h > include/${POSTGRESQL_DIR}/server/catalog/storage_xlog.h > +include/${POSTGRESQL_DIR}/server/catalog/syscache_ids.h > +include/${POSTGRESQL_DIR}/server/catalog/syscache_info.h > include/${POSTGRESQL_DIR}/server/catalog/system_fk_info.h > include/${POSTGRESQL_DIR}/server/catalog/toasting.h > include/${POSTGRESQL_DIR}/server/commands/ > @@ -350,6 +358,7 @@ include/${POSTGRESQL_DIR}/server/command > include/${POSTGRESQL_DIR}/server/common/ > include/${POSTGRESQL_DIR}/server/common/archive.h > include/${POSTGRESQL_DIR}/server/common/base64.h > +include/${POSTGRESQL_DIR}/server/common/blkreftable.h > include/${POSTGRESQL_DIR}/server/common/checksum_helper.h > include/${POSTGRESQL_DIR}/server/common/compression.h > include/${POSTGRESQL_DIR}/server/common/config_info.h > @@ -360,6 +369,7 @@ include/${POSTGRESQL_DIR}/server/common/ > include/${POSTGRESQL_DIR}/server/common/file_perm.h > include/${POSTGRESQL_DIR}/server/common/file_utils.h > include/${POSTGRESQL_DIR}/server/common/hashfn.h > +include/${POSTGRESQL_DIR}/server/common/hashfn_unstable.h > include/${POSTGRESQL_DIR}/server/common/hmac.h > include/${POSTGRESQL_DIR}/server/common/int.h > include/${POSTGRESQL_DIR}/server/common/int128.h > @@ -371,6 +381,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/parse_manifest.h > include/${POSTGRESQL_DIR}/server/common/percentrepl.h > include/${POSTGRESQL_DIR}/server/common/pg_lzcompress.h > include/${POSTGRESQL_DIR}/server/common/pg_prng.h > @@ -382,12 +393,17 @@ 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_case.h > +include/${POSTGRESQL_DIR}/server/common/unicode_case_table.h > +include/${POSTGRESQL_DIR}/server/common/unicode_category.h > +include/${POSTGRESQL_DIR}/server/common/unicode_category_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 > include/${POSTGRESQL_DIR}/server/common/unicode_normprops_table.h > +include/${POSTGRESQL_DIR}/server/common/unicode_version.h > include/${POSTGRESQL_DIR}/server/common/username.h > include/${POSTGRESQL_DIR}/server/datatype/ > include/${POSTGRESQL_DIR}/server/datatype/timestamp.h > @@ -500,6 +516,7 @@ include/${POSTGRESQL_DIR}/server/lib/int > include/${POSTGRESQL_DIR}/server/lib/knapsack.h > include/${POSTGRESQL_DIR}/server/lib/pairingheap.h > include/${POSTGRESQL_DIR}/server/lib/qunique.h > +include/${POSTGRESQL_DIR}/server/lib/radixtree.h > include/${POSTGRESQL_DIR}/server/lib/rbtree.h > include/${POSTGRESQL_DIR}/server/lib/simplehash.h > include/${POSTGRESQL_DIR}/server/lib/sort_template.h > @@ -519,6 +536,7 @@ include/${POSTGRESQL_DIR}/server/libpq/p > include/${POSTGRESQL_DIR}/server/libpq/pqformat.h > include/${POSTGRESQL_DIR}/server/libpq/pqmq.h > include/${POSTGRESQL_DIR}/server/libpq/pqsignal.h > +include/${POSTGRESQL_DIR}/server/libpq/protocol.h > include/${POSTGRESQL_DIR}/server/libpq/sasl.h > include/${POSTGRESQL_DIR}/server/libpq/scram.h > include/${POSTGRESQL_DIR}/server/mb/ > @@ -621,7 +639,6 @@ include/${POSTGRESQL_DIR}/server/plperl_ > include/${POSTGRESQL_DIR}/server/plpgsql.h > include/${POSTGRESQL_DIR}/server/port/ > include/${POSTGRESQL_DIR}/server/port.h > -include/${POSTGRESQL_DIR}/server/port/aix.h > include/${POSTGRESQL_DIR}/server/port/atomics/ > include/${POSTGRESQL_DIR}/server/port/atomics.h > include/${POSTGRESQL_DIR}/server/port/atomics/arch-arm.h > @@ -692,6 +709,7 @@ include/${POSTGRESQL_DIR}/server/postmas > include/${POSTGRESQL_DIR}/server/postmaster/postmaster.h > include/${POSTGRESQL_DIR}/server/postmaster/startup.h > include/${POSTGRESQL_DIR}/server/postmaster/syslogger.h > +include/${POSTGRESQL_DIR}/server/postmaster/walsummarizer.h > include/${POSTGRESQL_DIR}/server/postmaster/walwriter.h > include/${POSTGRESQL_DIR}/server/ppport.h > include/${POSTGRESQL_DIR}/server/regex/ > @@ -713,6 +731,7 @@ include/${POSTGRESQL_DIR}/server/replica > include/${POSTGRESQL_DIR}/server/replication/pgoutput.h > include/${POSTGRESQL_DIR}/server/replication/reorderbuffer.h > include/${POSTGRESQL_DIR}/server/replication/slot.h > +include/${POSTGRESQL_DIR}/server/replication/slotsync.h > include/${POSTGRESQL_DIR}/server/replication/snapbuild.h > include/${POSTGRESQL_DIR}/server/replication/syncrep.h > include/${POSTGRESQL_DIR}/server/replication/walreceiver.h > @@ -785,7 +804,6 @@ include/${POSTGRESQL_DIR}/server/statist > include/${POSTGRESQL_DIR}/server/statistics/extended_stats_internal.h > include/${POSTGRESQL_DIR}/server/statistics/statistics.h > include/${POSTGRESQL_DIR}/server/storage/ > -include/${POSTGRESQL_DIR}/server/storage/backendid.h > include/${POSTGRESQL_DIR}/server/storage/barrier.h > include/${POSTGRESQL_DIR}/server/storage/block.h > include/${POSTGRESQL_DIR}/server/storage/buf.h > @@ -793,12 +811,14 @@ include/${POSTGRESQL_DIR}/server/storage > include/${POSTGRESQL_DIR}/server/storage/buffile.h > include/${POSTGRESQL_DIR}/server/storage/bufmgr.h > include/${POSTGRESQL_DIR}/server/storage/bufpage.h > +include/${POSTGRESQL_DIR}/server/storage/bulk_write.h > include/${POSTGRESQL_DIR}/server/storage/checksum.h > include/${POSTGRESQL_DIR}/server/storage/checksum_impl.h > include/${POSTGRESQL_DIR}/server/storage/condition_variable.h > include/${POSTGRESQL_DIR}/server/storage/copydir.h > include/${POSTGRESQL_DIR}/server/storage/dsm.h > include/${POSTGRESQL_DIR}/server/storage/dsm_impl.h > +include/${POSTGRESQL_DIR}/server/storage/dsm_registry.h > include/${POSTGRESQL_DIR}/server/storage/fd.h > include/${POSTGRESQL_DIR}/server/storage/fileset.h > include/${POSTGRESQL_DIR}/server/storage/freespace.h > @@ -814,6 +834,7 @@ include/${POSTGRESQL_DIR}/server/storage > include/${POSTGRESQL_DIR}/server/storage/lock.h > include/${POSTGRESQL_DIR}/server/storage/lockdefs.h > include/${POSTGRESQL_DIR}/server/storage/lwlock.h > +include/${POSTGRESQL_DIR}/server/storage/lwlocklist.h > include/${POSTGRESQL_DIR}/server/storage/lwlocknames.h > include/${POSTGRESQL_DIR}/server/storage/md.h > include/${POSTGRESQL_DIR}/server/storage/off.h > @@ -826,7 +847,9 @@ include/${POSTGRESQL_DIR}/server/storage > include/${POSTGRESQL_DIR}/server/storage/procarray.h > include/${POSTGRESQL_DIR}/server/storage/proclist.h > include/${POSTGRESQL_DIR}/server/storage/proclist_types.h > +include/${POSTGRESQL_DIR}/server/storage/procnumber.h > include/${POSTGRESQL_DIR}/server/storage/procsignal.h > +include/${POSTGRESQL_DIR}/server/storage/read_stream.h > include/${POSTGRESQL_DIR}/server/storage/reinit.h > include/${POSTGRESQL_DIR}/server/storage/relfilelocator.h > include/${POSTGRESQL_DIR}/server/storage/s_lock.h > @@ -842,6 +865,7 @@ include/${POSTGRESQL_DIR}/server/storage > include/${POSTGRESQL_DIR}/server/storage/standbydefs.h > include/${POSTGRESQL_DIR}/server/storage/sync.h > include/${POSTGRESQL_DIR}/server/tcop/ > +include/${POSTGRESQL_DIR}/server/tcop/backend_startup.h > include/${POSTGRESQL_DIR}/server/tcop/cmdtag.h > include/${POSTGRESQL_DIR}/server/tcop/cmdtaglist.h > include/${POSTGRESQL_DIR}/server/tcop/deparse_utility.h > @@ -898,6 +922,7 @@ include/${POSTGRESQL_DIR}/server/utils/h > include/${POSTGRESQL_DIR}/server/utils/hsearch.h > include/${POSTGRESQL_DIR}/server/utils/index_selfuncs.h > include/${POSTGRESQL_DIR}/server/utils/inet.h > +include/${POSTGRESQL_DIR}/server/utils/injection_point.h > include/${POSTGRESQL_DIR}/server/utils/inval.h > include/${POSTGRESQL_DIR}/server/utils/json.h > include/${POSTGRESQL_DIR}/server/utils/jsonb.h > @@ -911,7 +936,6 @@ include/${POSTGRESQL_DIR}/server/utils/m > 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 > include/${POSTGRESQL_DIR}/server/utils/palloc.h > include/${POSTGRESQL_DIR}/server/utils/partcache.h > include/${POSTGRESQL_DIR}/server/utils/pg_crc.h > @@ -934,7 +958,6 @@ include/${POSTGRESQL_DIR}/server/utils/r > include/${POSTGRESQL_DIR}/server/utils/relptr.h > include/${POSTGRESQL_DIR}/server/utils/reltrigger.h > include/${POSTGRESQL_DIR}/server/utils/resowner.h > -include/${POSTGRESQL_DIR}/server/utils/resowner_private.h > include/${POSTGRESQL_DIR}/server/utils/rls.h > include/${POSTGRESQL_DIR}/server/utils/ruleutils.h > include/${POSTGRESQL_DIR}/server/utils/sampling.h > @@ -956,6 +979,7 @@ include/${POSTGRESQL_DIR}/server/utils/u > 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/wait_event_types.h > include/${POSTGRESQL_DIR}/server/utils/xid8.h > include/${POSTGRESQL_DIR}/server/utils/xml.h > include/${POSTGRESQL_DIR}/server/varatt.h > @@ -967,7 +991,6 @@ include/${POSTGRESQL_DIR}/sqlda-native.h > include/${POSTGRESQL_DIR}/sqlda.h > lib/${POSTGRESQL_DIR}/ > @so lib/${POSTGRESQL_DIR}/_int.so > -@so lib/${POSTGRESQL_DIR}/adminpack.so > @so lib/${POSTGRESQL_DIR}/amcheck.so > @so lib/${POSTGRESQL_DIR}/auth_delay.so > @so lib/${POSTGRESQL_DIR}/auto_explain.so > @@ -1025,7 +1048,6 @@ lib/${POSTGRESQL_DIR}/libpq.so.6 > @so lib/${POSTGRESQL_DIR}/lo.so > @so lib/${POSTGRESQL_DIR}/ltree.so > @so lib/${POSTGRESQL_DIR}/moddatetime.so > -@so lib/${POSTGRESQL_DIR}/old_snapshot.so > @so lib/${POSTGRESQL_DIR}/pageinspect.so > @so lib/${POSTGRESQL_DIR}/passwordcheck.so > @so lib/${POSTGRESQL_DIR}/pg_buffercache.so > @@ -1095,15 +1117,11 @@ lib/${POSTGRESQL_DIR}/pkgconfig/libpq.pc > share/${POSTGRESQL_DIR}/ > share/${POSTGRESQL_DIR}/errcodes.txt > share/${POSTGRESQL_DIR}/extension/ > -share/${POSTGRESQL_DIR}/extension/adminpack--1.0--1.1.sql > -share/${POSTGRESQL_DIR}/extension/adminpack--1.0.sql > -share/${POSTGRESQL_DIR}/extension/adminpack--1.1--2.0.sql > -share/${POSTGRESQL_DIR}/extension/adminpack--2.0--2.1.sql > -share/${POSTGRESQL_DIR}/extension/adminpack.control > share/${POSTGRESQL_DIR}/extension/amcheck--1.0--1.1.sql > share/${POSTGRESQL_DIR}/extension/amcheck--1.0.sql > share/${POSTGRESQL_DIR}/extension/amcheck--1.1--1.2.sql > share/${POSTGRESQL_DIR}/extension/amcheck--1.2--1.3.sql > +share/${POSTGRESQL_DIR}/extension/amcheck--1.3--1.4.sql > share/${POSTGRESQL_DIR}/extension/amcheck.control > share/${POSTGRESQL_DIR}/extension/autoinc--1.0.sql > share/${POSTGRESQL_DIR}/extension/autoinc.control > @@ -1151,6 +1169,7 @@ share/${POSTGRESQL_DIR}/extension/dict_i > share/${POSTGRESQL_DIR}/extension/dict_xsyn--1.0.sql > share/${POSTGRESQL_DIR}/extension/dict_xsyn.control > share/${POSTGRESQL_DIR}/extension/earthdistance--1.0--1.1.sql > +share/${POSTGRESQL_DIR}/extension/earthdistance--1.1--1.2.sql > share/${POSTGRESQL_DIR}/extension/earthdistance--1.1.sql > share/${POSTGRESQL_DIR}/extension/earthdistance.control > share/${POSTGRESQL_DIR}/extension/file_fdw--1.0.sql > @@ -1198,11 +1217,10 @@ share/${POSTGRESQL_DIR}/extension/lo.con > share/${POSTGRESQL_DIR}/extension/ltree--1.0--1.1.sql > share/${POSTGRESQL_DIR}/extension/ltree--1.1--1.2.sql > share/${POSTGRESQL_DIR}/extension/ltree--1.1.sql > +share/${POSTGRESQL_DIR}/extension/ltree--1.2--1.3.sql > share/${POSTGRESQL_DIR}/extension/ltree.control > share/${POSTGRESQL_DIR}/extension/moddatetime--1.0.sql > share/${POSTGRESQL_DIR}/extension/moddatetime.control > -share/${POSTGRESQL_DIR}/extension/old_snapshot--1.0.sql > -share/${POSTGRESQL_DIR}/extension/old_snapshot.control > 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 > @@ -1222,6 +1240,7 @@ share/${POSTGRESQL_DIR}/extension/pg_buf > 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--1.4--1.5.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 > @@ -1233,6 +1252,7 @@ share/${POSTGRESQL_DIR}/extension/pg_pre > share/${POSTGRESQL_DIR}/extension/pg_prewarm.control > share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.0--1.1.sql > share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.1--1.2.sql > +share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.10--1.11.sql > share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.2--1.3.sql > share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.3--1.4.sql > share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.4--1.5.sql > @@ -1314,7 +1334,6 @@ 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: citus/Makefile > =================================================================== > RCS file: /cvs/ports/databases/citus/Makefile,v > retrieving revision 1.27 > diff -u -p -u -p -r1.27 Makefile > --- citus/Makefile 17 Oct 2025 07:37:01 -0000 1.27 > +++ citus/Makefile 14 Nov 2025 01:24:38 -0000 > @@ -1,3 +1,4 @@ > +BROKEN = does not yet support PostgreSQL 18 > COMMENT= extension to horizontally scale PostgreSQL > > GH_ACCOUNT= citusdata > Index: timescaledb/Makefile > =================================================================== > RCS file: /cvs/ports/databases/timescaledb/Makefile,v > retrieving revision 1.34 > diff -u -p -u -p -r1.34 Makefile > --- timescaledb/Makefile 3 Oct 2025 17:36:29 -0000 1.34 > +++ timescaledb/Makefile 14 Nov 2025 01:24:38 -0000 > @@ -4,7 +4,7 @@ ONLY_FOR_ARCHS = ${LP64_ARCHS} > > GH_ACCOUNT = timescale > GH_PROJECT = timescaledb > -GH_TAGNAME = 2.22.1 > +GH_TAGNAME = 2.23.1 > > # -extras is only used for 2.15.X-fix_hypertable_foreign_keys.sql > EXTRAS_COMMIT = ba47f5dff02e8d75268cb09dd3c30101cf12dd6f > Index: timescaledb/distinfo > =================================================================== > RCS file: /cvs/ports/databases/timescaledb/distinfo,v > retrieving revision 1.28 > diff -u -p -u -p -r1.28 distinfo > --- timescaledb/distinfo 3 Oct 2025 17:36:29 -0000 1.28 > +++ timescaledb/distinfo 14 Nov 2025 01:24:38 -0000 > @@ -1,4 +1,4 @@ > SHA256 (timescale-timescaledb-extras-ba47f5dff02e8d75268cb09dd3c30101cf12dd6f.tar.gz) = MFKGKubWrbok/Gqg6qo3sBn/5J9H1uHK2C9O682MCAw= > -SHA256 (timescaledb-2.22.1.tar.gz) = RZO7YYjwn6iW+mD/nwRfod3LrIS/9ppzws5WF1VSaSI= > +SHA256 (timescaledb-2.23.1.tar.gz) = JldfqeKHphB6a/Fiusq0kysN8ZvuONKMEy+aLWWR1kc= > SIZE (timescale-timescaledb-extras-ba47f5dff02e8d75268cb09dd3c30101cf12dd6f.tar.gz) = 17811 > -SIZE (timescaledb-2.22.1.tar.gz) = 8149506 > +SIZE (timescaledb-2.23.1.tar.gz) = 8276671 > Index: timescaledb/pkg/PLIST > =================================================================== > RCS file: /cvs/ports/databases/timescaledb/pkg/PLIST,v > retrieving revision 1.29 > diff -u -p -u -p -r1.29 PLIST > --- timescaledb/pkg/PLIST 3 Oct 2025 17:36:29 -0000 1.29 > +++ timescaledb/pkg/PLIST 14 Nov 2025 01:24:38 -0000 > @@ -44,6 +44,8 @@ share/postgresql/extension/timescaledb-- > share/postgresql/extension/timescaledb--2.21.3--${GH_TAGNAME}.sql > share/postgresql/extension/timescaledb--2.21.4--${GH_TAGNAME}.sql > share/postgresql/extension/timescaledb--2.22.0--${GH_TAGNAME}.sql > +share/postgresql/extension/timescaledb--2.22.1--${GH_TAGNAME}.sql > +share/postgresql/extension/timescaledb--2.23.0--${GH_TAGNAME}.sql > share/postgresql/extension/timescaledb--${GH_TAGNAME}.sql > share/postgresql/extension/timescaledb--2.9.0--${GH_TAGNAME}.sql > share/postgresql/extension/timescaledb--2.9.1--${GH_TAGNAME}.sql > Index: pg_sqlite_fdw/Makefile > =================================================================== > RCS file: /cvs/ports/databases/pg_sqlite_fdw/Makefile,v > retrieving revision 1.7 > diff -u -p -u -p -r1.7 Makefile > --- pg_sqlite_fdw/Makefile 13 Dec 2024 07:49:32 -0000 1.7 > +++ pg_sqlite_fdw/Makefile 14 Nov 2025 01:24:38 -0000 > @@ -1,3 +1,4 @@ > +BROKEN = does not yet support PostgreSQL 18 > COMMENT = PostgreSQL Foreign Data Wrapper for SQLite > > GH_ACCOUNT = pgspider > Index: postgresql-pllua/Makefile > =================================================================== > RCS file: /cvs/ports/databases/postgresql-pllua/Makefile,v > retrieving revision 1.25 > diff -u -p -u -p -r1.25 Makefile > --- postgresql-pllua/Makefile 23 Nov 2024 06:56:11 -0000 1.25 > +++ postgresql-pllua/Makefile 14 Nov 2025 01:24:38 -0000 > @@ -5,7 +5,11 @@ GH_ACCOUNT = pllua > GH_PROJECT = pllua > GH_TAGNAME = REL_${VERSION:S/./_/g} > PKGNAME = postgresql-pllua-${VERSION} > -REVISION = 0 > +REVISION = 1 > + > +SITES.p = https://github.com/pllua/pllua/commit/ > +PATCHFILES.p = pllua-pg18-fix{bb2f44b542e650ddd250e4e27c73e86aadb09dde}.patch > +PATCH_DIST_STRIP = -p1 > > CATEGORIES = databases > > @@ -22,8 +26,8 @@ MODULES = lang/lua > MODLUA_VERSION = 5.3 > > BUILD_DEPENDS = ${RUN_DEPENDS} \ > - postgresql-client->=17,<18:databases/postgresql,-main > -RUN_DEPENDS = postgresql-server->=17,<18:databases/postgresql,-server > + postgresql-client->=18,<19:databases/postgresql,-main > +RUN_DEPENDS = postgresql-server->=18,<19:databases/postgresql,-server > > USE_GMAKE = Yes > > Index: postgresql-pllua/distinfo > =================================================================== > RCS file: /cvs/ports/databases/postgresql-pllua/distinfo,v > retrieving revision 1.10 > diff -u -p -u -p -r1.10 distinfo > --- postgresql-pllua/distinfo 29 Nov 2023 23:42:00 -0000 1.10 > +++ postgresql-pllua/distinfo 14 Nov 2025 01:24:38 -0000 > @@ -1,2 +1,4 @@ > SHA256 (pllua-REL_2_0_12.tar.gz) = eztLXXSaLR4EBznA6q1LWze2d4ZurX9qbjSfhAxetMM= > +SHA256 (pllua-pg18-fix.patch) = MAeJdYPQ1hqqAiKQCoR0jl9xBM8ktbE3i5fXXGsjSO0= > SIZE (pllua-REL_2_0_12.tar.gz) = 222446 > +SIZE (pllua-pg18-fix.patch) = 3950 >