Okay I think it’s a change they made in PostgreSQL 9.5.2 that is the culprit.
I do see that they updated libeasy32.dll and ssleasy32.dll so I'm suspecting that might be it. I will investigate.
To test I used the EDB 9.5.1 binaries – installed a fresh put of PostGIS 2.2.2 in that on my Windows 7 64-bit
Did
CREATE EXTENSION postgis;
Worked fine.
Repeated the same exercise with the PostgreSQL 9.5.2 binaries and got the same error you did.
ERROR: could not load library "C:/ming64gcc48/projects/postgresql/rel/pgsqltest/lib/rtpostgis-2.2.dll": The specified procedure could not be found.
So lesson here – stay away from the PostgreSQL 9.5.2 Windows (64-bit at least) if you are using PostGIS until I figure out what's up here and can package a new PostGIS 2.2.2 build that's compatible with 095.2
Thanks,
Regina
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Lucas Fairchild-Madar
Sent: Friday, April 01, 2016 7:40 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] Postgis issue installing under win64 with Postgres 9.5.2
Sorry, this is 2012R2 Standard Edition, 64 bit.
When I did an uninstall/reinstall between the winnie build and postgis build I uninstalled the entire postgres installation and installed a new one (keeping the data directory). There's not any information on this server yet.
I tried the libxml2.dll to libxml2-2.dll trick with the same results.
At no point were any 32 bit binaries used. Dependency walker (in static analysis mode) shows no 32 bit dependencies. The non-winnie build was for postgis-bundle-pg95x64-setup-2.2.1-1.exe.
Is there any other information I can give you to help debug this issue? I will try to roll back to 9.5.1 at some point soon and see how that behaves.
Thanks!
Lucas
On Fri, Apr 1, 2016 at 8:53 PM, "Regina Obe" <lr at pcorp.us <mailto:lr at pcorp.us> > wrote:
This is 2012 not 2012R2? I don't think I have a 2012 only to test on but haven't had an issue with 2012r2 or windows 2008 variants.
That said, I haven't upgraded to 9.5.2 yet (still 9.5.1) though that shouldn't matter. I'll double check to make sure.
The general culprit for this is the libxml2-2.dll
For whatever reason you are using a PostgreSQL 32-bit and trying to use 64-bit PostGIS binaries or you are using PostgreSQL 64-bit and using PostGIS 32-bit binaries
Reinstalling won't fix this since it won't replace files libxml2-2.dll if it see it already there snce sometimes EDB distributes it and sometimes they don't. So you'd have to explicitly overwrite those.
You can do so just copying libxml2.dll to libxml2-2.dll
I would suggest giving that a try first.
Hope that helps,
Regina
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org <mailto:postgis-users-bounces at lists.osgeo.org> ] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> >
Subject: Re: [postgis-users] Postgis issue installing under win64 with Postgres 9.5.2
I had exactly the same problem with a 9.3 PostgreSQL for windows x64.
---------------------------------------------------
41.95581N 12.52854E
http://www.linkedin.com/in/stefanoiacovella
http://twitter.com/#!/Iacovellas
2016-04-01 8:28 GMT+02:00 Lucas Fairchild-Madar <lucas.madar at gmail.com <mailto:lucas.madar at gmail.com> <mailto:lucas.madar at gmail.com <mailto:lucas.madar at gmail.com> > >:
I'm trying to install postgis on a windows machine running windows server 2012 64 bit. This is a fresh install using the 9.5.2 release from EnterpriseDB and the 64 bit installer from download.osgeo.org/postgis/windows/pg95/ <http://download.osgeo.org/postgis/windows/pg95/> <http://download.osgeo.org/postgis/windows/pg95/> .
I receive this error when running CREATE EXTENSION:
ERROR: could not load library "S:/PostgreSQL/9.5/lib/rtpostgis-2.2.dll": The specified procedure could not be found.
I have also tried uninstalling and reinstalling the entire binary system and using the latest winnie build from winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip <http://winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip> <http://winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip> which has the same results.
Just creating a function from rtpostgis-2.2.dll results in the same problem:
db# CREATE OR REPLACE FUNCTION postgis_raster_lib_version()
RETURNS text AS '$libdir/rtpostgis-2.2', 'RASTER_lib_version'
LANGUAGE 'c' IMMUTABLE;
ERROR: could not load library "S:/PostgreSQL/9.5/lib/rtpostgis-2.2.dll": The specified procedure could not be found.
I've verified the file is there and that the symbol RASTER_lib_version exists inside. Dependency walker shows no obvious problems although I am not an expert at using it.
# select version();
version
-------------------------------------------------------------
PostgreSQL 9.5.2, compiled by Visual C++ build 1800, 64-bit
Is it possible this is a new issue introduced with PG 9.5.2?
Thanks!
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> <mailto:postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> >
http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160401/ef9d0d03/attachment-0001.html>
------------------------------
Subject: Digest Footer
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/postgis-users
------------------------------
End of postgis-users Digest, Vol 170, Issue 1
*********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160401/53250810/attachment.html>