<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)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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 I seem to be having problems getting the new PostgreSQL 9.5.2 64-bit installed on my windows 2012 r2 64-bit box (haven't even gotten to PostGIS install). Granted this box already has 9.4, but I've never had issues running multiple versions on same box if they run on different ports and have another server running 9.4.something and 9.5.1 fine together.<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'>On 9.5.2 64-bit after it completes – I get this error I've never seen before:<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><img width=569 height=441 id="Picture_x0020_1" src="cid:image001.png@01D18C58.20EE64C0"><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'>Did you by chance get any errors installing PostgreSQL 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'>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><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 8:36 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'>The only other thing I can think of that could cause the problem is a dependency in GDAL.<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'>For example EDB does ship libeasy32.dll and ssleasy32.dll and I made sure in prior versions to use a version of curl that would be compatible with what they shipped.<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 suppose that might have changed.<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'>If that is the issue, then the postgis-2.2.dll should be fine since it would only have a libxml dependency.<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'>Are you able to install the postgis.sql file in contrib/postgis-2.2 folder okay. If so then that would point at a libgdal dependency issue.<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'll try to do a fresh install of PostgreSQL 9.5.2 and install of PostGIS 2.2.1 to see if I run into any issues.<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: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>