<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)"><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:inherit;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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'>FWIW BigSQL made their windows builds under Mingw64 as well. So what I outlined is pretty much how they do it. In fact they asked me for guidance when they were building these.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>The binaries our windows buildbot builds, worked fine on BigSQL last I tested them:<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><a href="https://postgis.net/windows_downloads/">https://postgis.net/windows_downloads/</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The main caveat is the paths are different in bigsql – so where<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://winnie.postgis.net/download/windows/pg11/buildbot/">https://winnie.postgis.net/download/windows/pg11/buildbot/</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>(in the zip the lib would go in - <em><b><span style='font-family:"inherit",serif;color:#222222;border:none windowtext 1.0pt;padding:0in;background:white'>postgresql/lib , postgresql/bin </span></b></em><em><span style='font-family:"inherit",serif;color:#222222;border:none windowtext 1.0pt;padding:0in;background:white'>) </span></em><em><span style='font-family:"inherit",serif;color:#222222;border:none windowtext 1.0pt;padding:0in;background:white;font-style:normal'>of your PostgreSQL install.</span></em><span style='font-family:"inherit",serif;color:#222222;border:none windowtext 1.0pt;padding:0in;background:white'><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'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I think BigSQL has sadly since stopped shipping (their Mac and Windows) since Amazon bought OpenSCG (main company behind BigSQL).<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'>Let me know if you run into any issues. I may have left out some dependencies I know that EDB packages to prevent people from overwriting EDB files and some of these may not be shipped with BigSQL or go by a different name.<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><p class=MsoNormal><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>John Payne<br><b>Sent:</b> Monday, August 26, 2019 12:54 PM<br><b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br><b>Subject:</b> Re: [postgis-users] netcdf files deprecated in raster2pgsql?<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Hi Regina, thanks for your answer. Your reply ended up in the wrong email folder so I didn't see it until just now. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I'm using the BigSQL distribution (i.e., PostgreSQL and associated libraries as provided by <a href="http://bigsql.org">bigsql.org</a>). <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>SELECT postgis_full_version() gives this:<o:p></o:p></p></div><div><p class=MsoNormal>"POSTGIS="2.5.0 r16836" [EXTENSION] PGSQL="110" GEOS="3.6.2-CAPI-1.10.2 0" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.2.0, released 2017/04/28" LIBXML="2.9.0" LIBJSON="0.12.1" TOPOLOGY RASTER"<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Sounds like maybe I should contact BigSQL.org with the question. I appreciate you giving me some perspective. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>John<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Wed, Aug 21, 2019 at 10:13 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-right:0in'><p class=MsoNormal>Which package system did you get your PostGIS from?<br><br>What you can load via raster2pgsql depends on what drivers your GDAL is compiled with. It might have been an omission on the part of the packager, like perhaps in past they used the standard base packages to get GDAL and because GDAL from base is always old, they might have compiled their own to ship to get newer GDAL and didn't include the kitchen sink that the base OS package includes.<br>NetCDF is not in the default compile of GDAL as it requires additional dependencies.<br><br>Hope that helps,<br>Regina<br><br>-----Original Message-----<br>From: postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] On Behalf Of J Payne<br>Sent: Wednesday, August 21, 2019 11:12 PM<br>To: <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>Subject: Re: [postgis-users] netcdf files deprecated in raster2pgsql?<br><br>Hi all,<br><br>I recently discovered that my new version of raster2pgsql doesn't work for importing netcdf files, but an older version I have on my computer does. I'm wondering if netcdf handling has been dropped/deprecated in the later version. <br><br>With postgresql version 11.0 and postgis 2.5, this fails:<br>raster2pgsql -s 4326 -c -F -t 256x256 NETCDF:"[myfile]":p mytable | psql -h localhost -U [user] -d [database]<br><br>...but this works with an older version of raster2pgsql that came with PostgreSQL 9.4:<br>/usr/local/old_pgsql-9.4/bin/raster2pgsql -s 4326 -c -F -t 256x256 NETCDF:"[myfile]":p mytable | psql -h localhost -U [user] -d [database]<br><br>I also note that "netcdf" is not included in the list of formats returned by 'raster2pgsql -G' with the new version.<br><br>Thanks,<br><br>John<br><br><br>_______________________________________________<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/mailman/listinfo/postgis-users</a><br><br>_______________________________________________<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/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div></div></body></html>