<div dir="ltr">Yes Regina, it's a must due to the actual customer installation. <div>Thank you very much for your suggestions. I solved every problem!</div><div><br></div><div>Regards,</div><div>Mauro</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, May 29, 2018 at 6:52 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div class="m_-4831846396056565539WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Mauro,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Is there a reason you want to use PostgreSQL 9.4 and not something newer?  PostgreSQL 9.4 is pretty old at this point.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">If you can I would suggest using a newer version.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Note that BigSQL PostgreSQL 9.4 has its own PostGIS too.  I'm not sure which versions are offered for 9.4.  It does lack SFCGAL in it.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">If you do from command shell (cd'd into bigsql folder)<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">pgc list<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">it will give a list of extension options.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Then it should be as simple as<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">pgc install postgis23<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">But if you want to use 9.4 and the 2.3.8dev binaries, then YES, you'd need to use this one<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><h2 style="margin-right:0in;margin-bottom:12.0pt;margin-left:.5in;background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#515151;text-transform:uppercase">https://</span><a href="http://www.enterprisedb.com/downloads/postgres-postgresql-downloads" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;text-transform:uppercase">www.enterprisedb.com/<wbr>downloads/postgres-postgresql-<wbr>downloads</span></a><u></u><u></u></h2><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><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:<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 12:19 PM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><wbr>><span class=""><br><b>Cc:</b> Mauro Gregorio Binetti <<a href="mailto:maurogregorio.binetti@exprivia.it" target="_blank">maurogregorio.binetti@<wbr>exprivia.it</a>><br></span><b>Subject:</b> Re: [postgis-users] Installing PostGIS 2.3.8 over PostGres 9.4, Windows<u></u><u></u></span></p><div><div class="h5"><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-left:.5in">Hi Regina,<u></u><u></u></p><div><p class="MsoNormal" style="margin-left:.5in">first of all thank you very much for responding so fast.<u></u><u></u></p><div><p class="MsoNormal" style="margin-left:.5in">Your assumption is correct. I installed PostgreSQL 9.4.18 using BigSQL distribution.<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">Your explanation is very clear to me now.<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">I need to use version 9.4 of PostgreSQL so, I understand I have to start by changing this one. My reference must be <u></u><u></u></p><h2 style="margin-right:0in;margin-bottom:12.0pt;margin-left:.5in;background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#515151;text-transform:uppercase">https://</span><a href="http://www.enterprisedb.com/downloads/postgres-postgresql-downloads" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;text-transform:uppercase">www.enterprisedb.com/<wbr>downloads/postgres-postgresql-<wbr>downloads</span></a><u></u><u></u></h2><p class="MsoNormal" style="margin-left:.5in">Correct?<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">Then I can repeat PostGIS installation using the same zip file:<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><a href="https://winnie.postgis.net/" target="_blank">https://winnie.postgis.net/</a>dow<wbr>nload/windows/pg94/buildbot/<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#222222;background:white">po<wbr>stgis-pg94-binaries-2.3.<wbr>8devw64gcc48.zip</span><u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">Correct?<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">Regards,<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">Mauro<u></u><u></u></p><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-left:.5in">On Tue, May 29, 2018 at 5:02 PM, Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<u></u><u></u></p><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"><div><div><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Which distribution of PostgreSQL are you using?</span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">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.</span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">For example if you are using BigSQL, only PostgreSQL 9.5 and above binaries on Winnie will work with that.</span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">The reason for this is</span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Prior to PostgreSQL 9.5, EnterpriseDb used to compile their windows versions with FLOAT8PASSBYVAL =  false</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">So to accommodate that, I built < 9.5 with FLOAT8PASSBYVAL = false</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">However BigSQL windows distributions have always been built with FLOAT8PASSBYVAL = true</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">So the 9.4 builds I built for EDB WILL NOT WORK with 9.4 BigSQL</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">In Version PostgreSQL 9.5+, EDB changed their windows builds to build with FLOAT8PASSBYVAL =true as well</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">So from that point forward, the builds are compatible.</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><a href="http://postgis.net/windows_downloads/" target="_blank"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">http://postgis.net/windows_<wbr>downloads/</span></a><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">(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)</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks,</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Regina</span><u></u><u></u></p><p class="m_-4831846396056565539gmail-m-9159289127889759548msolistparagraph" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><u></u><u></u></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 [mailto:</span><a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">postgis-users-bounces@<wbr>lists.osgeo.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">] <b>On Behalf Of </b>Mauro Gregorio Binetti<br><b>Sent:</b> Tuesday, May 29, 2018 10:29 AM<br><b>To:</b> </span><a href="mailto:postgis-users@lists.osgeo.org" target="_blank"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">postgis-users@lists.osgeo.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><br><b>Cc:</b> Mauro Gregorio Binetti <</span><a href="mailto:maurogregorio.binetti@exprivia.it" target="_blank"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">maurogregorio.binetti@<wbr>exprivia.it</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">><br><b>Subject:</b> [postgis-users] Installing PostGIS 2.3.8 over PostGres 9.4, Windows</span><u></u><u></u></p><div><div><p class="MsoNormal" style="margin-left:1.0in"> <u></u><u></u></p><div><p class="MsoNormal" style="margin-left:1.0in">Hi guys,<u></u><u></u></p><div><p class="MsoNormal" style="margin-left:1.0in"><span style="background:white">I have downloaded the subsequent zipfile:</span><u></u><u></u></p></div><div><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"><a href="https://winnie.postgis.net/download/windows/pg94/buildbot/" target="_blank"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;background:white">https://winnie.postgis.net/<wbr>download/windows/pg94/<wbr>buildbot/</span></a><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;background:white"> postgis-pg94-<wbr>binaries-2.3.8devw64gcc48.zip</span><u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif"> </span><u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;background:white">FOr the subsequent command:</span><u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"><span style="font-size:11.0pt;line-height:105%;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-bottom:8.0pt;margin-left:1.0in;line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;background:white">shown in bat file: </span><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif">makepostgisdb_using_<wbr>extensions.bat</span><u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;background:white">I have the subsequent error:</span><u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"><b><span style="font-size:11.0pt;line-height:105%;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-bottom:8.0pt;margin-left:1.0in;line-height:105%"><b><span style="font-size:11.0pt;line-height:105%;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-bottom:8.0pt;margin-left:1.0in;line-height:105%"> <u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"><span style="font-size:11.0pt;line-height:105%;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:1.5in"><span style="font-size:10.0pt;font-family:Symbol">·</span><span style="font-size:7.0pt">        </span>pg94\include\postgresql\<wbr>server\pg_config.h<u></u><u></u></p><p class="MsoNormal" style="margin-left:1.5in"><span style="font-size:10.0pt;font-family:Symbol">·</span><span style="font-size:7.0pt">        </span>pg94\include\pg_config.h<u></u><u></u></p><p class="MsoNormal" style="margin-left:1.0in">but I continue to have same error.<u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%">Can you please give me some advice.<u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"> <u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%">Thank you in advance.<u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%"> <u></u><u></u></p><p class="MsoNormal" style="margin-bottom:8.0pt;margin-left:1.0in;line-height:105%">Mauro<u></u><u></u></p></div></div></div></div></div></div><p class="MsoNormal" style="margin-left:.5in"><br>______________________________<wbr>_________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><u></u><u></u></p></blockquote></div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div></div></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>