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

[Regina Obe]

PostGIS install scripts wouldn't copy those because those are usually installed in system folder or by PostgreSQL installer and may be shared by other programs and have their own dependencies (e.g GDAL can have 100 depencies)

The install script would only copy the postgis extension libs to the pg**/lib folder and the extension scripts to pg**/share/extension and share/contrib/postgis-2.4

 

For windows packaging I have a script for deploy the dependencies apart from PostGIS install.

 

From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Roberto Ribeiro
Sent: Thursday, June 14, 2018 5:36 PM
To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
Subject: Re: [postgis-devel] Cannot load library in cygwin PostGIS 2.4 build

 

Hello Regina,

thank you very much for your answer. The dependencies of PostGIS are not being copied into pg**/bin, so that may be a bug in the makefile concerning Cygwin (lack of testing for the platform would certainly explain these issues). I'm also looking at a problem specifically concerning the path to libxml2, I'll investigate further and report later if I find anything.

Thanks again for your answer.

 

2018-06-07 3:55 GMT-03:00 Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> >:

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 <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 <mailto: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?


_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org <mailto:postgis-devel at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-devel

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180615/4df0fadb/attachment.html>