Created attachment 265575 [details] Update PGSQL default to 18 Let's see what breaks and contemplate a default upgrade.
Some failures logs: https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/pg_citus-13.2.0.log https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/pgroonga-4.0.1.log https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/pldebugger-1.8,1.log https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/postgis33-3.3.8_5.log https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/postgis34-3.4.4_5.log https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/postgresql18-pgaudit-16.0.log https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/postgresql18-plv8js-3.2.3.log https://pkg-status.freebsd.org/gohan06/data/143amd64-default-foo/2025-11-28_15h53m10s/logs/errors/postgresql18-rum-1.3.14.log
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=37d977ab7f829b94c2a9e4f78c314cc8fa5544c8 commit 37d977ab7f829b94c2a9e4f78c314cc8fa5544c8 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2026-01-14 00:55:26 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2026-01-14 00:55:26 +0000 databases/postgis34: IGNORE on pgsql>17 PR: 291156 databases/postgis34/Makefile | 4 ++++ 1 file changed, 4 insertions(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=d96290b127d3d6d086d67cd6f9440c8c7ca183a0 commit d96290b127d3d6d086d67cd6f9440c8c7ca183a0 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2026-01-14 00:53:59 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2026-01-14 00:53:59 +0000 databases/postgis33: IGNORE on pgsql>17 PR: 291156 databases/postgis33/Makefile | 4 ++++ 1 file changed, 4 insertions(+)
(In reply to Antoine Brodin from comment #1) Hi portmgr, Can you rerun the exp-run? There is one expected failure for pgaudit which will be committed in the same window as the default upgrade due to version dependency.
I confirm the remaining failure is pgaudit
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=b3067b15e58e432938a6e9a07809b1ecea4c4cb6 commit b3067b15e58e432938a6e9a07809b1ecea4c4cb6 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2026-03-02 03:03:51 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2026-03-02 03:08:32 +0000 Mk/bsd.default-versions.mk: Update to PostgreSQL 18 See UPDATING for upgrade advice PR: 291156 Approved by: antoine (exp-run) Mk/bsd.default-versions.mk | 2 +- UPDATING | 53 ++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 54 insertions(+), 1 deletion(-)
Thanks!