On 10/02 09:20, Theo Buehler wrote:
> > Included here is an update to postgresql-previous, since that is
> > necessary for building.  I have not tested fallout in any other
> > dependencies.  There is always fallout, if someone could test this diff
> > and the docbook diff in a bulk and post the failures in the
> > dependencies, I can start working on fixing them.
> 
> Seems less fallout than usual. Some of them have patches ready, others
> don't seem to have started.

Thanks for testing.  Most of these will probably be cleaned up before
PostgreSQL 17.1 is released.  Often timescaledb takes longer and we
mark it broken temporarily.  After PostgreSQL 17.1 is released, I'll
work on updates for these ports.

I do have a patch for postgresql-pllua.  Not changes are required,
just a dependency+revision bump:

Thanks,
Jeremy

Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-pllua/Makefile,v
diff -u -p -u -p -r1.24 Makefile
--- Makefile	29 Nov 2023 23:42:00 -0000	1.24
+++ Makefile	2 Oct 2024 23:50:34 -0000
@@ -5,6 +5,7 @@ GH_ACCOUNT =		pllua
 GH_PROJECT =		pllua
 GH_TAGNAME =		REL_${VERSION:S/./_/g}
 PKGNAME =		postgresql-pllua-${VERSION}
+REVISION =		0
 
 CATEGORIES =		databases
 
@@ -21,8 +22,8 @@ MODULES =		lang/lua
 MODLUA_VERSION =	5.3
 
 BUILD_DEPENDS =		${RUN_DEPENDS} \
-			postgresql-client->=16,<17:databases/postgresql,-main
-RUN_DEPENDS =		postgresql-server->=16,<17:databases/postgresql,-server
+			postgresql-client->=17,<18:databases/postgresql,-main
+RUN_DEPENDS =		postgresql-server->=17,<18:databases/postgresql,-server
 
 USE_GMAKE =		Yes
 

> databases/citus
> 
> configure: error: Citus is not compatible with the detected PostgreSQL version 17.
> 
> https://github.com/citusdata/citus/issues?q=label%3Apg17_support
> 
> 
> databases/pg_sqlite_fdw
> 
> ===>  Building for pg_sqlite_fdw-2.4.0
> Makefile:41: *** PostgreSQL 12, 13, 14, 15 or 16 is required to compile this extension.  Stop.
> 
> https://github.com/pgspider/sqlite_fdw/issues/104
> 
> 
> databases/postgresql-pllua
> 
> ===> postgresql-pllua-2.0.12 depends on: postgresql-server->=16,<17 - not found
> ===> postgresql-pllua-2.0.12 depends on: postgresql-server->=16,<17 - default postgresql-server-17.0 does not match
> 
> 
> databases/repmgr
> 
> repmgr-client.c:3185:9: error: use of undeclared identifier 'PG_TEMP_FILE_PREFIX'
>                                                   PG_TEMP_FILE_PREFIX);
>                                                   ^
> 
> https://github.com/EnterpriseDB/repmgr/pull/863
> 
> 
> databases/timescaledb
> 
> CMake Error at CMakeLists.txt:355 (message):
>   TimescaleDB only supports PostgreSQL 14, 15 and 16
> 
> working on it:
> 
> https://github.com/timescale/timescaledb/pulls?q=is%3Apr+label%3Apg17