El Capitan - CREATE EXTENSION postgis fails with "ERROR: could not load library "/Library/PostgreSQL/9.5/lib/postgresql/rtpostgis-2.2.so": dlopen(/Library/PostgreSQL/9.5/lib/postgresql/rtpostgis-2.2.so, 10): Symbol not found: _SSLv2_client_method"

[remy]

Hello,

I'm trying to install the new 9.5.2 Postgres version with Postgis 2.2 (downloaded from ​​http://www.enterprisedb.com/products/pgdownload.do#osx)

When I issue "CREATE EXTENSION postgis", I'm getting :

ERROR: ERROR: could not load library "/Library/PostgreSQL/9.5/lib/postgresql/rtpostgis-2.2.so": dlopen(/Library/PostgreSQL/9.5/lib/postgresql/rtpostgis-2.2.so, 10): Symbol not found: _SSLv2_client_method

Referenced from: /Library/PostgreSQL/9.5/lib/postgresql/libcurl.4.dylib Expected in: /Library/PostgreSQL/9.5/bin/../lib/libssl.1.0.0.dylib

in /Library/PostgreSQL/9.5/lib/postgresql/libcurl.4.dylib

OS X : El Capitan 10.11.4

I have tried to reproduce the issue on Postgres 9.4.7 and an other computer with OS X 10.11.

Thanks, Rémy

[robe]

This sounds like the same issue I ran into and fixed on windows.

Unfortunately I don't package for MacOSX so you need to talk with EDB folks directly and have them rebuild their GDAL library.

The issue I ran into on windows and fixed detailed here - ​http://www.postgresonline.com/journal/archives/364-PostGIS-2.2-Windows-users-hold-off-on-installing-latest-PostgreSQL-patch-release.html

In older versions they compiled with a lower SSL and in 9.5.2 (at least for windows they upgraded the OpenSSL library to a version that is incompatible with what they shipped in 9.5.1 - assume the same case on Mac) . So Short answer - the libcurl they are shipping (to support GDAL) needs to be compiled with newer version of SSL.

I'll relay your message to them.

[robe]

Okay relayed message to them. They are working on updates now. I'll close this ticket once they've released their update.

[robe]

Note from EDB folks about MacOSX packages:

---

New updates with the fix are available through StackBuilder.

---

Please give those a try should fix this issue.