p5.34-dbd-pg @3.18.0 does not build on PPC Mac OS X 10.5.8, Leopard, because its dependency postgresql16 does not build

[ballapete (Peter "Pete" Dyballa)]

Portfile should have at the end

 88 if {![variant_isset postgresql10] && \
 89     ![variant_isset postgresql11] && \
 90     ![variant_isset postgresql12] && \
 91     ![variant_isset postgresql13] && \
 92     ![variant_isset postgresql14] && \
 93     ![variant_isset postgresql15] && \
 94     ![variant_isset postgresql16]} {
 95         if {${os.platform} eq "darwin" && ${os.major} <= 10} {
 96             default_variants    +postgresql15
 97         } else {
 98             default_variants    +postgresql16
 99         }
100     }

PostgreSQL versions 12, 13, 14, 15 build fine:

-rw-r--r-- 1 0 80 6.304.085  8. Jan 21:42 /opt/local/var/macports/software/postgresql10/postgresql10-10.19_1+perl.darwin_9.ppc.tbz2
-rw-r--r-- 1 0 80 6.469.078  9. Jan 12:45 /opt/local/var/macports/software/postgresql11/postgresql11-11.14_6+perl.darwin_9.ppc.tbz2
-rw-r--r-- 1 0 80 6.838.421  9. Jan 14:12 /opt/local/var/macports/software/postgresql12/postgresql12-12.22_1+perl.darwin_9.ppc.tbz2
-rw-r--r-- 1 0 80 7.124.680  8. Jan 23:34 /opt/local/var/macports/software/postgresql13/postgresql13-13.18_1+perl.darwin_9.ppc.tbz2
-rw-r--r-- 1 0 80 7.514.783  9. Jan 00:56 /opt/local/var/macports/software/postgresql14/postgresql14-14.15_1+perl.darwin_9.ppc.tbz2
-rw-r--r-- 1 0 80 7.719.203  9. Jan 11:14 /opt/local/var/macports/software/postgresql15/postgresql15-15.10_1+perl.darwin_9.ppc.tbz2
leopard pete 227 /\  gls -Lln /opt/local/var/macports/distfiles/postgresql1?/*
-rw-r--r-- 1 502 80 19.261.478  8. Jan 21:07 /opt/local/var/macports/distfiles/postgresql10/postgresql-10.19.tar.bz2
-rw-r--r-- 1 502 80 20.172.910  8. Jan 21:51 /opt/local/var/macports/distfiles/postgresql11/postgresql-11.14.tar.bz2
-rw-r--r-- 1 502 80 21.305.304  8. Jan 22:29 /opt/local/var/macports/distfiles/postgresql12/postgresql-12.22.tar.bz2
-rw-r--r-- 1 502 80 21.687.645  8. Jan 22:51 /opt/local/var/macports/distfiles/postgresql13/postgresql-13.18.tar.bz2
-rw-r--r-- 1 502 80 22.458.243  9. Jan 00:16 /opt/local/var/macports/distfiles/postgresql14/postgresql-14.15.tar.bz2
-rw-r--r-- 1 502 80 23.138.615  9. Jan 10:25 /opt/local/var/macports/distfiles/postgresql15/postgresql-15.10.tar.bz2
leopard pete 229 /\ sudo gdu -sk /opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql1?
Password:
496.572	/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql10
593.112	/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql11
252.592	/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql12
259.212	/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13
271.808	/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14
280.592	/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15

Could be PostgreSQL versions 10 and 11 contain in build area their test DBs… IMO these old versions can vanish. One problem is left: Which versions of PostgreSQL build on Snow Leopard or darwin10? Same as on Leopard/darwin9?

[ryandesign (Ryan Carsten Schmidt)]

It would be annoying to have to conditionalize the postgresql dependencies in every port. It would be better to fix postgresql16 so that it builds. I see the ticket tracking that is #71355.

[ballapete (Peter "Pete" Dyballa)]

Leopard and Tiger have no idea of fdatasync. Ken would need to write that function for legacy support. And I think it could also help to build MySQL…

[ballapete (Peter "Pete" Dyballa)]

Another option is to choose PostgreSQL 15 as default and allow variants on more up-to-date macOS…

[ballapete (Peter "Pete" Dyballa)]

There are more ports that are setup to use inexistent PostgreSQL 16, for example apr-util.