<div dir="ltr"><div><div><div><div><div>Sorry, this is 2012R2 Standard Edition, 64 bit.<br><br></div>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.<br><br></div>I tried the libxml2.dll to libxml2-2.dll trick with the same results.<br><br>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.<br><br></div>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.<br><br></div>Thanks!<br></div>Lucas<br><div><div><div><div><div><div><div><br><div class="gmail_extra">On Fri, Apr 1, 2016 at 8:53 PM, "Regina Obe" <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> <span dir="ltr"></span>wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
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.<br>
<br>
<br>
<br>
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.<br>
<br>
<br>
<br>
The general culprit for this is the libxml2-2.dll<br>
<br>
<br>
<br>
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<br>
<br>
<br>
<br>
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.<br>
<br>
You can do so just copying libxml2.dll to libxml2-2.dll<br>
<br>
<br>
<br>
I would suggest giving that a try first.<br>
<br>
<br>
<br>
Hope that helps,<br>
<br>
Regina<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
From: postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>] On Behalf Of Stefano Iacovella<br>
Sent: Friday, April 01, 2016 3:49 AM<br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] Postgis issue installing under win64 with Postgres 9.5.2<br>
<br>
<br>
<br>
I had exactly the same problem with a 9.3 PostgreSQL for windows x64.<br>
<br>
<br>
<br>
<br>
---------------------------------------------------<br>
41.95581N 12.52854E<br>
<br>
<br>
<a href="http://www.linkedin.com/in/stefanoiacovella" rel="noreferrer" target="_blank">http://www.linkedin.com/in/stefanoiacovella</a><br>
<br>
<a href="http://twitter.com/#!/Iacovellas" rel="noreferrer" target="_blank">http://twitter.com/#!/Iacovellas</a><br>
<br>
<br>
<br>
2016-04-01 8:28 GMT+02:00 Lucas Fairchild-Madar <<a href="mailto:lucas.madar@gmail.com">lucas.madar@gmail.com</a> <mailto:<a href="mailto:lucas.madar@gmail.com">lucas.madar@gmail.com</a>> >:<br>
<br>
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 <a href="http://download.osgeo.org/postgis/windows/pg95/" rel="noreferrer" target="_blank">download.osgeo.org/postgis/windows/pg95/</a> <<a href="http://download.osgeo.org/postgis/windows/pg95/" rel="noreferrer" target="_blank">http://download.osgeo.org/postgis/windows/pg95/</a>> .<br>
<br>
I receive this error when running CREATE EXTENSION:<br>
<br>
ERROR: could not load library "S:/PostgreSQL/9.5/lib/rtpostgis-2.2.dll": The specified procedure could not be found.<br>
<br>
I have also tried uninstalling and reinstalling the entire binary system and using the latest winnie build from <a href="http://winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip" rel="noreferrer" target="_blank">winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip</a> <<a href="http://winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip" rel="noreferrer" target="_blank">http://winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip</a>> which has the same results.<br>
<br>
Just creating a function from rtpostgis-2.2.dll results in the same problem:<br>
<br>
<br>
db# CREATE OR REPLACE FUNCTION postgis_raster_lib_version()<br>
RETURNS text AS '$libdir/rtpostgis-2.2', 'RASTER_lib_version'<br>
LANGUAGE 'c' IMMUTABLE;<br>
ERROR: could not load library "S:/PostgreSQL/9.5/lib/rtpostgis-2.2.dll": The specified procedure could not be found.<br>
<br>
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.<br>
<br>
# select version();<br>
version<br>
-------------------------------------------------------------<br>
PostgreSQL 9.5.2, compiled by Visual C++ build 1800, 64-bit<br>
<br>
Is it possible this is a new issue introduced with PG 9.5.2?<br>
<br>
<br>
<br>
Thanks!<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20160401/ef9d0d03/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20160401/ef9d0d03/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 170, Issue 1<br>
*********************************************<br>
</blockquote></div><br></div></div></div></div></div></div></div></div></div>