From: Jeremy Evans Subject: Re: For Early Testing: PostgreSQL 18 To: Theo Buehler , OpenBSD ports Cc: sthen@openbsd.org, renato@renatoaguiar.net Date: Thu, 13 Nov 2025 17:56:02 -0800 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. 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