[postgis-users] ERROR: could not access file "$libdir/postgis-2.5" under Windows

[Stefan Keller]

Hi Regina

I've to check again which PG installer I used.
Just to be sure, I'm considering reinstalling PG and PostGIS again
using PostgreSQL 11 EDB.
Thanks for your help.
I hope I can give s'thing back by testing this :-).

Yours, Stefan
Am Mo., 17. Dez. 2018 um 06:13 Uhr schrieb Regina Obe <lr at pcorp.us>:
>
> Stefan,
>
> Are you sure you are using the EnterpriseDb distribution of PostgreSQL and NOT BigSQL windows distribution?
>
> That path you describe sounds like BigSQL distribution.  I tested with a brand new install of PostgreSQL 11 EDB and it installed fine without moving anything.
>
> As mentioned here - https://postgis.net/windows_downloads/  the installer EXEs are meant for PostgreSQL EDB distribution ONLY.  DO NOT USE WITH BigSQL.
>
> The binaries however are compatible with both EDB and BigSQL distributions, but paths where things are installed in PostgreSQL EDB is different from BigSQL.
> I don't bother trying to get the installer to work with BigSQL because BigSQL ships their own PostGIS binaries which you can get
>
> Via their pretty-good commandline (pgc) installer.
>
> https://www.openscg.com/bigsql/components/  (and THEY DO HAVE postgis 2.5.1 listed there).
>
> SO YOU SHOULD NEVER USE THE INSTALLER with BigSQL distribution, but if you need postgis SFCGAL or pgRouting you can use the binaries on OSGEO downloads on windows_downloads experimental section.
>
> Hope that clarifies things a bit.
>
> Thanks,
> Regina
>
>
> > -----Original Message-----
> > From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
> > Of Stefan Keller
> > Sent: Sunday, December 16, 2018 12:57 PM
> > To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> > Subject: [postgis-users] ERROR: could not access file "$libdir/postgis-2.5"
> > under Windows
> >
> > Hi,
> >
> > After installing PG 11 from EnterpriseDB from here [0] I used both PostGIS
> > installers here [1]. For both I'm getting following
> >
> > ERROR: could not access file "$libdir/postgis-2.5": No such file or directory SQL
> > state: 58P01
> >
> > Then I moved the files in .\lib into .\lib\postgresql and now the create
> > extension postgis works as indicated here [2].
> >
> > Did I got deviated by any default PostGIS installation workflow - or is this a
> > PostGIS for Windows installer issue?
> >
> > :Stefan
> >
> > [0] postgresql-11.1-1-windows-x64.exe by EnterpriseDB [1]
> > http://download.osgeo.org/postgis/windows/pg11/
> > [2] https://gis.stackexchange.com/questions/298761/how-to-resolve-the-
> > error-could-not-open-extension-control-file-when-create-e
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users