[postgis-users] Error installing PostGIS on agensdb

[Regina Obe]

Not familiar with how AgensDB puts things.

That error happens whenever the dll can't be loaded.

 

You might be better off using the binaries instead of the installer as I think the paths you put things relative to PostgreSQL install folder may be different.

 

For example in BigSQL things go  in

 

the lib files go into lib/postgresql folder, share/extension files in share/postgresql  and bin in bin

 

So that's why the installer can never work for BigSQL and you have to use the binaries.

 

The other issue is I don't ship files in the zip or installer that I know EDB ships to prevent accidental overwriting.

So you maybe need to copy those separately from elsewhere. 

 

If you use Dependency Walker (x64 version) - http://www.dependencywalker.com/  will tell you the dependencies you need or are missing.

 

There is yet another reason why this error happens, and that depends compile switches (--disable-float8-byval) comes to mind

For example EDB PostgreSQL used to have this off pre-9.5 so I had (--disable-float8-byval  ) when compiling and so the pre-9.5 binaries I built weren't compatible with BigSQL  because I had to use this switch too.

 

Post 9.5 both EDB and BigSQL don't use this switch so the binaries are compatible.  So if agent is doing something else, you probably can't use these binaries at all and will have to compile your own or pay someone to do so (like me :) ).

 

BTW just uploaded the 2.5.2 zip and binaries for 10. 

 

Hope that helps,

Regina 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of David Haynes
Sent: Wednesday, May 01, 2019 12:15 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Error installing PostGIS on agensdb

 

Hello,

 

I'm running into an error trying to enable the postgis extension on AgensDB (a fork of PostgreSQL). My setup is on a windows machine, PSQL 10.4. I have done this sucessfully once before, but I am unable to replicate it on my new machine.

 

The process I used is the following. I downloaded the precompiled windows binaries (postgis-bundle-pg10x64-setup-2.5.1-1.exe) and executed it within the agens directory successfully, but it still errors. The error below is strange because the file exists within the directory.

 

agens -p 5433 -U agens -c "CREATE EXTENSION postgis"

ERROR:  could not load library "C:/AgensGraph-2.1.0/lib/rtpostgis-2.5.dll": The specified module could not be found.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190501/2d5011d2/attachment.html>