<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Okay more news. I think I've pretty much confirmed the libeasy32.dll and ssleasy32.dll are the culprit. Because if I replace the libcurl-4.dll with one that does not include SSL support (meaning it has no dependency on those two files),<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>CREATE EXTENSION postgis;<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Works fine on the 9.5.2.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So if you are in a rush (this goes for the person who was having issue with 9.4, as I expect has the same issue).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I have put a zip file on Winnie (will work for 9.4 as well since the 9.4 I ship with the same GDAL library as 9.5)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><a href="http://winnie.postgis.net/download/windows/pg95/buildbot/libcurl-no-ssl_forPostgreSQ9.5.2users.zip">http://winnie.postgis.net/download/windows/pg95/buildbot/libcurl-no-ssl_forPostgreSQ9.5.2users.zip</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>This is a curl binary compiled without SSL support so doesn't rely on ssleasy32.dll and libeasy32.dll<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Replace the one you have currently with this one.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I still need to ship one with SSL support after I recompile – since main reason I bother shipping SSL is because CURL is also used by WWW_FDW which I use heavily with SSL.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I think for most PostGIS users (except possibly for OGR_FDW users, the SSL support is not needed)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Regina Obe<br><b>Sent:</b> Friday, April 01, 2016 9:10 PM<br><b>To:</b> 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org><br><b>Subject:</b> Re: [postgis-users] Postgis issue installing under win64 with Postgres 9.5.2<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Okay I think it’s a change they made in PostgreSQL 9.5.2 that is the culprit.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I do see that they updated libeasy32.dll and ssleasy32.dll so I'm suspecting that might be it. I will investigate.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>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<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Did <o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>CREATE EXTENSION postgis;<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Worked fine.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Repeated the same exercise with the PostgreSQL 9.5.2 binaries and got the same error you did.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>ERROR: could not load library "C:/ming64gcc48/projects/postgresql/rel/pgsqltest/lib/rtpostgis-2.2.dll": The specified procedure could not be found.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>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<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Lucas Fairchild-Madar<br><b>Sent:</b> Friday, April 01, 2016 7:40 PM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> Re: [postgis-users] Postgis issue installing under win64 with Postgres 9.5.2<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p><div><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:1.0in'>Sorry, this is 2012R2 Standard Edition, 64 bit.<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:1.0in'>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.<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:1.0in'>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.<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:1.0in'>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.<o:p></o:p></p></div><p class=MsoNormal style='margin-left:1.0in'>Thanks!<o:p></o:p></p></div><p class=MsoNormal style='margin-left:1.0in'>Lucas<o:p></o:p></p><div><div><div><div><div><div><div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p><div><p class=MsoNormal style='margin-left:1.0in'>On Fri, Apr 1, 2016 at 8:53 PM, "Regina Obe" <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<o:p></o:p></p><div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><p class=MsoNormal style='margin-left:1.0in'><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" target="_blank">http://www.linkedin.com/in/stefanoiacovella</a><br><br><a href="http://twitter.com/#!/Iacovellas" 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/" target="_blank">download.osgeo.org/postgis/windows/pg95/</a> <<a href="http://download.osgeo.org/postgis/windows/pg95/" 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" 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" 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" 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" 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" 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>*********************************************<o:p></o:p></p></blockquote></div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p></div></div></div></div></div></div></div></div></div></div></body></html>