From: Jeremy Evans Subject: Re: For Early Testing: PostgreSQL 18 To: Theo Buehler , OpenBSD ports , renato@renatoaguiar.net Date: Fri, 14 Nov 2025 19:00:43 -0800 On 11/14 06:59, Stuart Henderson wrote: > 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. That seems reasonable. Here's a diff for 17.7. OK to commit this now, and 18.1 in a week or so? Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.312 diff -u -p -u -p -r1.312 Makefile --- Makefile 1 Nov 2025 11:16:40 -0000 1.312 +++ Makefile 15 Nov 2025 02:58:41 -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 +VERSION= 17.7 PREV_MAJOR= 16 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} -REVISION-main= 0 DPB_PROPERTIES= parallel Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.106 diff -u -p -u -p -r1.106 distinfo --- distinfo 19 Aug 2025 04:50:48 -0000 1.106 +++ distinfo 15 Nov 2025 02:58:41 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-17.6.tar.gz) = KRC4UoNnTaLa5qwT/l67qvPEgkRjlsujLmco08xzbYY= -SIZE (postgresql-17.6.tar.gz) = 28141372 +SHA256 (postgresql-17.7.tar.gz) = Sp6UIE4mWykrCzZTTDhUPyT52W9UE86sSJ7wUwgq51I= +SIZE (postgresql-17.7.tar.gz) = 28186920 Index: 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 --- pkg/PLIST-docs 19 Aug 2025 04:50:48 -0000 1.119 +++ pkg/PLIST-docs 15 Nov 2025 02:58:41 -0000 @@ -701,6 +701,7 @@ share/doc/postgresql/html/release-17-3.h 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-7.html share/doc/postgresql/html/release-17.html share/doc/postgresql/html/release-prior.html share/doc/postgresql/html/release.html