[postgis-devel] Cannot load library in cygwin PostGIS 2.4 build

[Regina Obe]

The PostGIS 2.4 doesn't have to be in system path, it should be in your lib folder of PostgreSQL.  

I haven't used Cygwin in a while, and surprised it works, since I don't think anyone has been testing Cygwin compilation for PostGIS  in quite some time.

 

I compile under mingw64, the default install structure I get is

 

Pg11\lib (though PostGIS make install automatically puts it in the folder).

 

I think Cygwin might have it as pg11\lib\postgresql or something like that

 

And then the dependencies for PostGIS would go in pg11\bin – you should have a geos_c.dll, geos.dll, libproj-12.dll (might be libproj-9.dll if you are using < 4.9), libgdal-20.dll and all its dependencies, libxml2-2.dll

Then you can add to your system path.  I usually have a launch script that adds these to a local launch path so I can swap out versions for testing and not clutter up my postgresql bin folder.

.

 

From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Roberto Ribeiro
Sent: Wednesday, June 06, 2018 11:32 AM
To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
Subject: [postgis-devel] Cannot load library in cygwin PostGIS 2.4 build

 

Hello list,

I built PostGIS today using Cygwin, and it did so with no problems. However, if I try to create extension in an existing db, it returns the error message: "could not load library <path/postgis-2.4.dll>: No such file or directory".

I searched online, seems like this is a common error, however the two common workarounds did not apply to me: first is to check if build architecture matches that of Postgres (yes, both are 64bits compiled on cygwin); second is to check if the dll is in the system PATH (it is).

Does anyone have any idea what could be the problem?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180607/25f975b7/attachment.html>