Created attachment 250562 [details] pgsql 16 It's now at the third patch level, let's see what breaks and contemplate a default upgrade.
Some new failure logs: https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/hashtypes-0.1.4.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/postgresql16-pg_similarity-20160917_2.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/pguri-1.20151224_2.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/postgis31-3.1.11_1.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/postgis32-3.2.7_1.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/postgresql16-mysql_fdw-2.9.0.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/postgresql16-pgaudit-1.7.0.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/postgresql16-prefix-1.2.9.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/postgresql16-promscale-0.8.0_11.log https://pkg-status.freebsd.org/beefy22/data/140amd64-default-foo/2024-05-11_08h00m52s/logs/errors/slony1v2-2.2.11.log
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=b17bdbf17c4acf3efaa9dd5c58b7881d151cb7d4 commit b17bdbf17c4acf3efaa9dd5c58b7881d151cb7d4 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-05-12 07:53:47 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-05-12 07:56:06 +0000 databases/postgresql-promscale: Limit to pgsql < 16 Promscale is no longer developed so it is unlikely to get 16 support PR: 278885 Reported by: exp-run (antoine) databases/postgresql-promscale/Makefile | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=5c969afad5e56473adfa664dcdef4aab291639f8 commit 5c969afad5e56473adfa664dcdef4aab291639f8 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-05-12 08:04:55 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-05-12 08:04:55 +0000 databases/postgis31: Limit to pgsql < 15 per documentation https://postgis.net/2023/05/PostGIS-3.3.3-3.2.5-3.1.9-3.0.9-Patch-Releases/ PR: 278885 Reported by: exp-run (antoine) databases/postgis31/Makefile | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=78e9101ec23dee3bfdb280fb66e41f372993d837 commit 78e9101ec23dee3bfdb280fb66e41f372993d837 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-05-12 08:06:28 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-05-12 08:07:40 +0000 databases/postgis32: Limit to pgsql < 16 per documentation https://postgis.net/2023/05/PostGIS-3.3.3-3.2.5-3.1.9-3.0.9-Patch-Releases/ PR: 278885 Reported by: exp-run (antoine) databases/postgis32/Makefile | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=c1a1bc6d296b8a602ae1d9cdc7b7896a93c93562 commit c1a1bc6d296b8a602ae1d9cdc7b7896a93c93562 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-05-21 06:49:50 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-05-21 06:49:50 +0000 databases/pg_similarity: Limit to pgsql < 16 This extension seems unmaintained. It can be patched easily for pgsql 16 but should be updated first. PR: 278885 databases/pg_similarity/Makefile | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
(In reply to commit-hook from comment #3) This broke it: https://pkg-status.freebsd.org/package19/data/140amd64-default-build-as-user/11601920e699/logs/postgis31-3.1.11_1.log
(In reply to Antoine Brodin from comment #6) Seems like an error in the framework or a dep somehow? "pkg-static: postgresql15-client-15.7 conflicts with postgresql12-client-12.19 (installs files into the same place)." It's not supposed to work with the current default version, 15.
(In reply to Kevin Bowling from comment #7) or a bug in the way you use the framework
(In reply to Antoine Brodin from comment #8) Please enlighten us.
(In reply to Kevin Bowling from comment #7) In this case, you have to use something like .if blablasqlversion > something IGNORE= doesn't work with this version .endif The default versions stuff can't work with it.
(In reply to Antoine Brodin from comment #10) Can you confirm if this is what you mean https://reviews.freebsd.org/D45359
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=5e7078e10186aeeac0693b01c182c1b16b0d1e1d commit 5e7078e10186aeeac0693b01c182c1b16b0d1e1d Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-05-25 07:18:29 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-05-25 07:21:03 +0000 databases/postgis31: enforce pgsql version limit PR: 278885 Reviewed by: antoine Fixes: 5c969afad5e5 databases/postgis31: Limit to pgsql < 15 per documentation Differential Revision: https://reviews.freebsd.org/D45359 databases/postgis31/Makefile | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-)
Created attachment 251454 [details] pgsql + pgaudit 16
(In reply to Antoine Brodin from comment #1) Hi Antoine, Would you be able to run another exp-run? I have refreshed the patch and it is expected that all fallout have been addressed in main and this new patch.
Some new failure logs: https://pkg-status.freebsd.org/gohan04/data/140amd64-default-foo/2024-06-15_21h14m43s/logs/errors/postgis32-3.2.7_2.log https://pkg-status.freebsd.org/gohan04/data/140amd64-default-foo/2024-06-15_21h14m43s/logs/errors/postgresql12-promscale-0.8.0_12.log
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=ad6088a3ab523dff0045e62671250c7dd0227a45 commit ad6088a3ab523dff0045e62671250c7dd0227a45 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-07-06 23:22:21 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-07-06 23:22:21 +0000 databases/postgresql-promscale: enforce pgsql version limit PR: 278885 Reported by: antoine databases/postgresql-promscale/Makefile | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=4d011bdbc64aecb5d158822b01a1d242cb865fa6 commit 4d011bdbc64aecb5d158822b01a1d242cb865fa6 Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-07-06 23:21:13 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-07-06 23:21:13 +0000 databases/postgis32: enforce pgsql version limit PR: 278885 Reported by: antoine databases/postgis32/Makefile | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-)
(In reply to Antoine Brodin from comment #15) Thank you. I applied the same method you showed me earlier and think we should be clear of all build regressions now.
(In reply to Kevin Bowling from comment #18) The patch fails to apply
Created attachment 252024 [details] pgsql + pgaudit 16 Rebase on main
Exp-run looks fine
I would like to commit this in a week or so unless anyone has other ideas.
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=b86336fa4d39af5eb0a1f228a649ca4389e628dc commit b86336fa4d39af5eb0a1f228a649ca4389e628dc Author: Kevin Bowling <kbowling@FreeBSD.org> AuthorDate: 2024-07-23 16:29:21 +0000 Commit: Kevin Bowling <kbowling@FreeBSD.org> CommitDate: 2024-07-23 16:31:07 +0000 Mk/bsd.default-versions.mk: Update to PostgreSQL 16 See UPDATING for upgrade advice PR: 278885 Exp-run by: antoine Mk/bsd.default-versions.mk | 2 +- UPDATING | 53 ++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 54 insertions(+), 1 deletion(-)