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

[Regina Obe]

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