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