From: Stuart Henderson <stu@spacehopper.org>
Subject: Re: For Early Testing: PostgreSQL 18
To: Jeremy Evans <jeremy@openbsd.org>
Cc: Theo Buehler <tb@theobuehler.org>, OpenBSD ports <ports@openbsd.org>, renato@renatoaguiar.net
Date: Sat, 15 Nov 2025 18:18:54 +0000

On 2025/11/14 19:00, Jeremy Evans wrote:
> 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?

Thanks. OK sthen.

> 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
>