<div dir="ltr">Hi Regina,<div>first of all thank you very much for responding so fast.<br><div>Your assumption is correct. I installed PostgreSQL 9.4.18 using BigSQL distribution.</div><div>Your explanation is very clear to me now.</div><div>I need to use version 9.4 of PostgreSQL so, I understand I have to start by changing this one. My reference must be <h2 style="box-sizing:border-box;margin:1em 0px;line-height:1.2;display:flex;text-align:left;text-indent:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><font color="#515151" face="Maven Pro, sans-serif"><font size="2"><span style="text-transform:uppercase">h</span><span style="text-transform:uppercase">ttps://<a href="http://www.enterprisedb.com/downloads/postgres-postgresql-downloads">www.enterprisedb.com/downloads/postgres-postgresql-downloads</a></span></font></font><br></h2>Correct?</div><div>Then I can repeat PostGIS installation using the same zip file:</div><div>
<a href="https://winnie.postgis.net/">https://winnie.postgis.net/</a><wbr>download/windows/pg94/<wbr>buildbot/<span style="color:rgb(34,34,34);font-family:Calibri,sans-serif;font-size:14.6667px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">postgis-pg94-</span><wbr style="color:rgb(34,34,34);font-family:Calibri,sans-serif;font-size:14.6667px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(34,34,34);font-family:Calibri,sans-serif;font-size:14.6667px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">binaries-2.3.8devw64gcc48.zip</span></div><div><br></div><div>Correct?</div><div><br></div><div>Regards,</div><div>Mauro<br><div class="gmail_extra"><br><div class="gmail_quote">On Tue, May 29, 2018 at 5:02 PM, Regina Obe <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-US"><div class="gmail-m_-9159289127889759548WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Which distribution of PostgreSQL are you using?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">It looks to me like you are using a distribution incompatible with the EDB distribution which the 9.4 binaries I built were built for.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">For example if you are using BigSQL, only PostgreSQL 9.5 and above binaries on Winnie will work with that.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">The reason for this is<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Prior to PostgreSQL 9.5, EnterpriseDb used to compile their windows versions with FLOAT8PASSBYVAL = false<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">So to accommodate that, I built < 9.5 with FLOAT8PASSBYVAL = false<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">However BigSQL windows distributions have always been built with FLOAT8PASSBYVAL = true<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">So the 9.4 builds I built for EDB WILL NOT WORK with 9.4 BigSQL<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">In Version PostgreSQL 9.5+, EDB changed their windows builds to build with FLOAT8PASSBYVAL =true as well<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">So from that point forward, the builds are compatible.<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="http://postgis.net/windows_downloads/" target="_blank">http://postgis.net/windows_<wbr>downloads/</a><u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">(that's why I put a note on that page that for BigSQL 9.5+, you can use the binaries here if you want extra stuff. I probably maybe should have explained that better (and put a big DO NOT USE if using < 9.5 on BigSQL)<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Thanks,<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Regina<u></u><u></u></span></p><p class="gmail-m_-9159289127889759548MsoListParagraph"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal" style="margin-left:0.5in"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<wbr>lists.osgeo.org</a>] <b>On Behalf Of </b>Mauro Gregorio Binetti<br><b>Sent:</b> Tuesday, May 29, 2018 10:29 AM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Cc:</b> Mauro Gregorio Binetti <<a href="mailto:maurogregorio.binetti@exprivia.it" target="_blank">maurogregorio.binetti@<wbr>exprivia.it</a>><br><b>Subject:</b> [postgis-users] Installing PostGIS 2.3.8 over PostGres 9.4, Windows<u></u><u></u></span></p><div><div class="gmail-h5"><p class="MsoNormal" style="margin-left:0.5in"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-left:0.5in">Hi guys,<u></u><u></u></p><div><p class="MsoNormal" style="margin-left:0.5in"><span style="background:white">I have downloaded the subsequent zipfile:</span><u></u><u></u></p></div><div><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif;background:white"><a href="https://winnie.postgis.net/download/windows/pg94/buildbot/" target="_blank">https://winnie.postgis.net/<wbr>download/windows/pg94/<wbr>buildbot/</a> postgis-pg94-<wbr>binaries-2.3.8devw64gcc48.zip</span><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif"><u></u><u></u></span></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif"><u></u> <u></u></span></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif;background:white">FOr the subsequent command:</span><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif"><u></u><u></u></span></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif;background:white">"%PGBIN%\psql" -d "%THEDB%" -c "CREATE EXTENSION postgis;"</span><u></u><u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif;background:white">shown in bat file: </span><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif">makepostgisdb_using_<wbr>extensions.bat</span><u></u><u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif;background:white">I have the subsequent error:</span><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif"><u></u><u></u></span></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><b><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif">ERROR: incompatible library "C:/__APPL/pg94/../pg94/lib/<wbr>postgresql/postgis-2.3.dll": magic block mismatch</span></b><u></u><u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><b><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif">DETTAGLI: Server has FLOAT8PASSBYVAL = true, library has false.</span></b><u></u><u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><u></u> <u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><span style="font-size:11pt;line-height:106%;font-family:Calibri,sans-serif">I have modified boolean flag value to false in subsequent files:</span><u></u><u></u></p><p class="MsoNormal" style="margin-left:1in"><u></u><span style="font-size:10pt;font-family:Symbol"><span>·<span style="font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:7pt;line-height:normal;font-family:"Times New Roman""> </span></span></span><u></u>pg94\include\postgresql\<wbr>server\pg_config.h<u></u><u></u></p><p class="MsoNormal" style="margin-left:1in"><u></u><span style="font-size:10pt;font-family:Symbol"><span>·<span style="font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:7pt;line-height:normal;font-family:"Times New Roman""> </span></span></span><u></u>pg94\include\pg_config.h<u></u><u></u></p><p class="MsoNormal" style="margin-left:0.5in">but I continue to have same error.<u></u><u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%">Can you please give me some advice.<u></u><u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><u></u> <u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%">Thank you in advance.<u></u><u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%"><u></u> <u></u></p><p class="MsoNormal" style="margin-right:0in;margin-bottom:8pt;margin-left:0.5in;line-height:106%">Mauro<u></u><u></u></p></div></div></div></div></div></div><br>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div></div></div></div>