Can you elaborate a bit more on why "the dll can not be loaded" I'm confused as the error asks for a file at a specific location and the file is there at that exact location.
On Wed, May 1, 2019 at 12:55 PM Regina Obe <l...@pcorp.us> wrote: > 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 J ). > > > > BTW just uploaded the 2.5.2 zip and binaries for 10. > > > > Hope that helps, > > Regina > > > > > > *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On > Behalf Of *David Haynes > *Sent:* Wednesday, May 01, 2019 12:15 PM > *To:* postgis-users@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. > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users