Can't find PostGIS extensions (installed in different directory) and $ libdir / postgis-2.3 on mac os
I am using postgres in pycharm and it cannot find postGIS extensions. He looks for them in:/Library/PostgreSQL/9.6/share/postgresql/extension/
however, when I install PostGIS, it tells me that: PostGIS extension modules are installed in: /usr/local/share/postgresql/extension
Another problem (don't know if it's related to the first one): could not access file "$libdir/postgis-2.3": No such file or directory
source to share
I noticed this issue after upgrading from PostGIS 2.3.0 to 2.4.0. My databases were still looking for 2.3.0 libraries when 2.4.0 was installed. The solution was to individually update the databases to find versions 2.4.0:
ALTER EXTENSION postgis UPDATE;
SELECT PostGIS_full_version();
source to share