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:[email protected]] On Behalf Of David Haynes Sent: Wednesday, May 01, 2019 12:15 PM To: [email protected] 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.
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
