Hi Regina,<div>Thank you and thank you for the suggestions. We pushed 2.3.0 yesterday and will be looking in to the other items. I agree, ogr_fdw should be pretty easy. The idea of making our distribution more compatible with the standard PostGIS options makes sense. </div><div><br></div><div>One area we know we need is more docs on building extensions under mingw64 so that it's easier for users to add their own. This should help PostGIS users as well as general developers.</div><div><br></div><div>Thanks</div><div>Dave</div><div><br><br>On Friday, October 7, 2016, Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> 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><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">David,<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">Done.<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">Added here – <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"><a href="http://postgis.net/install/" target="_blank">http://postgis.net/install/</a>  (at bottom. Also added EDB since that was missing)<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">Couple of observations installing the BigSQL 9.6 windows 64-bit<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><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><span>1)<span style="font:7.0pt "Times New Roman"">      </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I got PostGIS 2.3.0rc1 instead of the released PostGIS 2.3.0.<u></u><u></u></span></p><p><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><span>2)<span style="font:7.0pt "Times New Roman"">      </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">It would be really neat if you distributed ogr_fdw as well, which should be fairly trivial compile since you are packaging GDAL and it's so useful for spatial ETL stuff - <a href="https://github.com/pramsey/pgsql-ogr-fdw" target="_blank">https://github.com/pramsey/<wbr>pgsql-ogr-fdw</a>  <u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Which gets me to my next couple of points<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I mentioned BigSQL here:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://postgis.net/windows_downloads/" target="_blank">http://postgis.net/windows_<wbr>downloads/</a><u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><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:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Ideally I would like to provide details of how people can add PostGIS related components missing in BigSQL windows distribution to theirs or try out some interim builds of things,<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">so that this page isn't so EDB weighted.<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Not sure if that would be kosher with you folks or not.  The optimal goal being that we are completely compatible and our components are swappable.<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I think they are for the most part now, except for the SFCGAL/ogr_fdw can't just be swapped in without completely replacing your PostGIS since our GDALs are compiled with different features and your <u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">PostGIS isn't compiled with SFCGAL support.<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">For the most part for example, the pgRouting on that page installs fine on the BigSQL distribution if I pay careful attention to the difference in path locations you have vs. the EDB distribution.<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I think I had tried PostGIS too and was able to swap out yours with the one I compiled that includes SFCGAL support last I tried with your PostgreSQL 9.6beta<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I'm currently using mingw64 gcc 4.8.3 but still planning to upgrade to the gcc 4.9.2 that you guys use for building, so our versions should be even more compatible in the future.<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks,<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Regina<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.25in"><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:.25in"><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"><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-devel [mailto:<a href="javascript:_e(%7B%7D,'cvml','postgis-devel-bounces@lists.osgeo.org');" target="_blank">postgis-devel-bounces@<wbr>lists.osgeo.org</a>] <b>On Behalf Of </b>Rader, David<br><b>Sent:</b> Friday, October 07, 2016 1:38 PM<br><b>To:</b> <a href="javascript:_e(%7B%7D,'cvml','postgis-devel@lists.osgeo.org');" target="_blank">postgis-devel@lists.osgeo.org</a><br><b>Subject:</b> Re: [postgis-devel] Note to Package Maintainers<u></u><u></u></span></p><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><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"><div><div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">---------- Forwarded message ----------<br>From: <b>Regina Obe</b> <<a href="javascript:_e(%7B%7D,'cvml','lr@pcorp.us');" target="_blank">lr@pcorp.us</a>><br>Date: Thu, Oct 6, 2016 at 9:32 AM<br>Subject: [postgis-devel] Note to Package Maintainers<br>To: PostGIS Development Discussion <<a href="javascript:_e(%7B%7D,'cvml','postgis-devel@lists.osgeo.org');" target="_blank">postgis-devel@lists.osgeo.org</a><wbr>><br><br><br>The PostGIS PSC would like to setup a list of package maintainers we'd use<br>primarily for release preannouncements where we deem necessary.<br>This list can take one of two forms, but not sure which people would be most<br>comfortable with:<br><br>1) A specific mailing list for PostGIS Packagers<u></u><u></u></p></div></div></div></div></blockquote><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">We (OpenSCG/BigSQL distribution) would like the packagers list. <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"> <u></u><u></u></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"><div><div><div><div><p class="MsoNormal" style="margin-right:0in;margin-bottom:12.0pt;margin-left:.5in"><br>We would also like to update this page:<br><br><a href="http://postgis.net/install/" target="_blank">http://postgis.net/install/</a><br><br>To include all PostGIS packagers that people use as well as link to their<br>bug tracker if any.<br><br>Any thoughts on above or updates to the page you'd like to provide us?<u></u><u></u></p></div></div></div></div></blockquote><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">We would like to add the BigSQL distribution to the install page as well - we provide an easy install path for Windows, OS X, and Windows users. We have been supporting PostGIS through this distribution since the beginning of the year - the instructions are here:<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><a href="http://www.bigsql.org/docs/postgis/postgis.jsp" target="_blank">http://www.bigsql.org/docs/<wbr>postgis/postgis.jsp</a><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">Please let us know what other info you would need to be able to add this stable version to the install page?<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"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">Thanks<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">Dave<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"> <u></u><u></u></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"><div><div><div><div><p class="MsoNormal" style="margin-left:.5in"><br>Thanks,<br>Regina Obe<br>PostGIS PSC Member<br><a href="http://postgis.net" target="_blank">http://postgis.net</a><br><br><br><br><br>______________________________<wbr>_________________<br>postgis-devel mailing list<br><a href="javascript:_e(%7B%7D,'cvml','postgis-devel@lists.osgeo.org');" target="_blank">postgis-devel@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/postgis-devel" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/postgis-devel</a><u></u><u></u></p></div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div></div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div></blockquote></div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><div><div><div><div><div><div><div><div><div><p class="MsoNormal" style="margin-left:.5in">--<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">David Rader<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><a href="javascript:_e(%7B%7D,'cvml','davidr@openscg.com');" target="_blank">davidr@openscg.com</a><u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div></div></div></div></div></div></div></div></div></div></div></div></div></blockquote></div><br><br>-- <br><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>--</div><div>David Rader<br></div><div><a href="mailto:davidr@openscg.com" target="_blank">davidr@openscg.com</a></div></div></div></div></div></div></div></div></div></div></div></div><br>