[postgis-users] Error installing PostGIS on agensdb

[David Haynes]

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 <lr at 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-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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190503/ba0e0fd5/attachment.html>