<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=us-ascii"><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;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Century Gothic";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma",sans-serif;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma",sans-serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle23
{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='color:#1F497D'>Ross,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>For reference My install gives:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>PostgreSQL 9.6.8, compiled by Visual C++ build 1800, 64-bit<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>POSTGIS="2.4.3 r16312" PGSQL="96" GEOS="3.6.2-CAPI-1.10.2 4d2925d" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.3, released 2017/11/20" LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Given that your GDAL is older (if you had installed 2.4.3 using the latest installer, it should have overwritten your 2.3.5 gdal so it should be showing 2.2.3). Given it didn't that could be the problem.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>I forget if the I had originally shipped 2.4.3 with GDAL 2.2.2 (so maybe that is not the issue and you have the same cause you are using an earlier installer)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>Anyrate if you are not in a super rush to upgrade, you might want to wait till I release: </span><span style='color:#1F497D'><a href="https://winnie.postgis.net/download/windows/pg96/buildbot/postgis-bundle-pg96x64-setup-2.4.3-3.exe">postgis-bundle-pg96x64-setup-2.4.3-3.exe</a><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>Which I'm hoping to get out this weekend or next. The things that will be upgraded in it are pgRouting and GDAL.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>GDAL 2.2.4 came out a couple of days ago - <a href="https://trac.osgeo.org/gdal/wiki/Release/2.2.4-News">https://trac.osgeo.org/gdal/wiki/Release/2.2.4-News</a> (with an ODBC fix that one of my client's needs for the ogrfdw)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>pgRouting 2.5.3 and pgRouting 2.6.0 also came out <a href="https://lists.osgeo.org/pipermail/pgrouting-users/2018-March/002384.html">https://lists.osgeo.org/pipermail/pgrouting-users/2018-March/002384.html</a> (of which I am planning to include 2.6.0)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='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>From:</b> Regina Obe [mailto:lr@pcorp.us] <br><b>Sent:</b> Wednesday, March 21, 2018 1:18 PM<br><b>To:</b> 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org><br><b>Subject:</b> RE: [postgis-users] Error upgrading to PostGIS 2.4.3<o:p></o:p></p></div></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>Yah the libxml2.dll and I assume you meant libxml2-2.dll. PostGIS needs the one called libxml2-2.dll and PostgreSQL EDB uses the one called libxml2.dll. They can be even the same dll. The libxml2-2.dll I have is dated 7/17/2017 (but like I said if you copied libxml2.dll to libxml2-2.dll that should work fine. <o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>I upgraded my PostgreSQL 9.6 to EDB 9.6.8 and the 2.4.3 I had installed was still working so libeasy is not the issue. I too also have libeay32.dll (1.0.2n, 12/12/2017)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>You copied over the binaries? You weren't using the installer? For some reason on my server, the Stackbuilder hung trying to download the installer so I just got it from:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><a href="https://winnie.postgis.net/download/windows/pg96/buildbot/postgis-bundle-pg96x64-setup-2.4.3-2.exe">https://winnie.postgis.net/download/windows/pg96/buildbot/postgis-bundle-pg96x64-setup-2.4.3-2.exe</a><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>I still haven't got around to installing on a virgin 9.6.8. To rule out it's not just because I've got some other libraries I always use already installed on my EDb instance.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='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:1.0in'><b>From:</b> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>McDonaldR<br><b>Sent:</b> Wednesday, March 21, 2018 11:54 AM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> Re: [postgis-users] Error upgrading to PostGIS 2.4.3<o:p></o:p></p></div></div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'>Hi Regina<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'>Thanks for the feedback.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'>This is my current working environment:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'>"POSTGIS="2.3.5 r16110" GEOS="3.6.2-CAPI-1.10.2 4d2925d" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.2, released 2017/09/15" LIBXML="2.7.8" LIBJSON="0.12" TOPOLOGY RASTER PostgreSQL 9.6.8, compiled by Visual C++ build 1800, 64-bit"<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'>I stopped PostgreSQL, copied over the new PostGIS binary files, restarted PostgreSQL and tried to run the upgrade.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'>I have libeay32.dll (1.0.2n, 12/12/2017) installed in bin\ as well as libxml2.dll and linxml2-2.dll (should I have both files?)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'>Ross<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:1.0in'><b><span style='font-size:10.0pt;font-family:"Tahoma",sans-serif'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma",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>Regina Obe<br><b>Sent:</b> 20 March 2018 23:36<br><b>To:</b> 'PostGIS Users Discussion'<br><b>Subject:</b> Re: [postgis-users] Error upgrading to PostGIS 2.4.3<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>Ross,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>That error often means there is a dependency missing.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>I think I did upgrade some binaries like GDAL and GEOS in last run, so if you were upgrading while PostGIS lib was in use, you might have gotten an error like<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>"Can't overwrite file" during installation and since 2.4.3 would need the newer GDAL/GEOS/Proj might fail. That would cause this problem. Fix would be shut down postgresql, restart and rerun the 2.4.3 setup.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>Could also be a packaging mistake on my part.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>I'll test on my end on a clean 64-bit 9.6.8 to rule out issue on my end. Last time I had a large number of people complaining about this, it was because EDB micro upgraded installed a libeasy32.dll that was incompatible with the curl I was shipping, so I had to recompile the curl to be compatible with whatever EDB upgraded their SSL libraries to.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>Given your 2.3.5 still works? I assume the ssl is not the issue.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>Thanks.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><span style='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:1.5in'><b>From:</b> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>McDonaldR<br><b>Sent:</b> Tuesday, March 20, 2018 2:00 PM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> [postgis-users] Error upgrading to PostGIS 2.4.3<o:p></o:p></p></div></div><p class=MsoNormal style='margin-left:1.5in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB>Hi List<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB>Maybe you can point me in the right direction. I’m running PostgreSQL 9.6.8 (64bit) on Windows 2008 R2 with PostGIS 2.3.5 installed. I have installed the 2.4.3 binaries and when I try to run <b>ALTER EXTENSION postgis UPDATE TO “2.4.3”;</b> I get the following error:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><b><span lang=EN-GB>ERROR could not load library PostgreSQL/9.6/lib/postgis-2.4.dll The specified procedure could not be found.<o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB>The file is there. I’ve checked permissions and all are valid. I’ve stopped and started the postgresql service. Am I missing something going from PostGIS 2.3.x to 2.4.x? In the past upgrades have been totally painless.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB>Any help much appreciated.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB>Thanks<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB>Ross<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.5in'><b><span lang=EN-GB style='font-size:10.0pt;font-family:"Century Gothic";color:#4F6228'>Ross McDonald | </span></b><span lang=EN-GB style='font-size:10.0pt;font-family:"Century Gothic";color:#4F6228'>GIS Data Coordinator | Angus Council, People, IT | Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT<b> | t: 01307 476419<o:p></o:p></b></span></p><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB><o:p> </o:p></span></p><div><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman",serif'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-left:1.5in'><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial",sans-serif'>This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. </span><span lang=EN-GB><o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman",serif'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-left:1.0in'><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial",sans-serif'>This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. </span><span lang=EN-GB><o:p></o:p></span></p></div></div></body></html>