macOs CI: cannot build with topology

[lbartoletti]

As mentioned on ​https://github.com/postgis/postgis/pull/729 there is an error when topology is enabled:

#/usr/bin/perl -0777 -ne 's/^(CREATE|ALTER) (CAST|OPERATOR|TYPE|TABLE|SCHEMA|DOMAIN|TRIGGER).*?;//msg;print;' topology.sql > topology_upgrade.sql.in
echo "BEGIN;" > topology_upgrade.sql
cat topology_before_upgrade.sql topology_upgrade.sql.in topology_after_upgrade.sql > topology_upgrade.sql
echo "COMMIT;" >> topology_upgrade.sql
9 warnings generated.
clang -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Werror=unguarded-availability-new -Wendif-labels -Wmissing-format-attribute -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno-compound-token-split-by-macro -O2  -bundle -multiply_defined suppress -o postgis_topology-3.so postgis_topology.o -L/opt/homebrew/lib/postgresql@14  -isysroot /Library/Developer/CommandLineTools/SDKs/MacOSX12.sdk -L/opt/homebrew/opt/openssl@1.1/lib -L/opt/homebrew/opt/readline/lib -L/opt/homebrew/Cellar/lz4/1.9.4/lib  -Wl,-dead_strip_dylibs   ../libpgcommon/libpgcommon.a ../liblwgeom/.libs/liblwgeom.a  -L/opt/homebrew/Cellar/geos/3.11.2/lib -lgeos_c -L/opt/homebrew/Cellar/proj/9.2.0/lib -lproj -L/opt/homebrew/Cellar/json-c/0.16/lib -ljson-c -L/opt/homebrew/Cellar/protobuf-c/1.4.1_1/lib -lprotobuf-c -L/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/lib -lxml2 -lz -lpthread -licucore -lm -L/opt/homebrew/Cellar/sfcgal/1.4.1_4/lib -lSFCGAL   -lm -L/opt/homebrew/Cellar/sfcgal/1.4.1_4/lib -lSFCGAL -bundle_loader /usr/local/bin/postgres
ld: file not found: /usr/local/bin/postgres
clang: error: linker command failed with exit code 1 (use -v to see invocation)
make[1]: *** [postgis_topology-3.so] Error 1
make: *** [all] Error 1
Stopping `postgresql@14`... (might take a while)
==> Successfully stopped `postgresql@14` (label: homebrew.mxcl.postgresql@14)

But, it seems to be only for the CI, since postgis comes with topology enabled on homebrew ​https://github.com/Homebrew/homebrew-core/blob/d608de039eb7d30b92c52f8c7f6e030969f476d3/Formula/postgis.rb

[strk]

The clang line is written by PGXS, could you attach the topology/Makefile and the PGXS file referenced in it ? grep ^PGXS topolgy/Makefile

Is 3.3 the oldest branch affected ? Could you test older stable branches too ? Is there any way to directly access the problematic system via ssh ?

[pramsey]

I build with topology on MacOS, no problems, sorry.

[pramsey]

I can build and regress fine on MacOS here, so this is a CI issue rather than a code issue (or a code mixed with CI env issue). In any event, if you want to fix it, please do, and reopen this ticket with a patch, I'll be happy to test locally and apply it if you have a solution.

[robe]

I committed the mac testing at [7905ec144/git]

but have not renabled topology. Looks like topology is turned off.