I seem to have lost the ability to use basic postgis queries. Normal postgres queries are unaffected.

Using Mac (High Sierra), using postgres 10.5 / postgis 2.4 (probably)

The same error happens accessing from QGIS, Postico, pgAdmin4, psql and using the Node.js pg library.

This seems to be a fairly new development - I successfully ran similar queries in Node about a week ago. I have no idea what's changed since then. I find it odd that the errors are related to SFCGAL as I don't recall ever installing this.

PostgreSQL said: could not load library "/usr/local/lib/postgresql/postgis-2.4.so": dlopen(/usr/local/lib/postgresql/postgis-2.4.so, 10): Symbol not found: __ZN5boost6system15system_categoryEv Referenced from: /usr/local/opt/sfcgal/lib/libSFCGAL.1.dylib Expected in: /usr/local/opt/boost/lib/libboost_system-mt.dylib in /usr/local/opt/sfcgal/lib/libSFCGAL.1.dylib

I tend to install using Homebrew. Has anyone got a solution?

I suppose I can always set up a Docker container and use that, but I have a lot of databases that I'd rather not lose!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.