[postgis-users] netcdf files deprecated in raster2pgsql?

Mon Aug 26 10:32:25 PDT 2019

Well Linux it looks like BigSQL  still distributes, but I suspect that might be someone who took that over.  They had sent a notice months ago about discontinuing windows and Mac.  Sorry guess I got your message confused with the other one from someone asking to build under Windows.

For Mac, I’d go with Postgres.app

https://postgresapp.com/downloads.html

They have PostgreSQL 12 beta3 and PostGIS 3.0.0alpha3 even.  Though I’m not sure if that will have the NetCDF libraries you are looking for.  I suspect not, but worth a try.

That said I’m not a mac user, so perhaps someone else on the list might be better able to answer.

Hope that helps,

Regina

From: John Payne [mailto:drjohnpayne at gmail.com] 
Sent: Monday, August 26, 2019 1:18 PM
To: Regina Obe <lr at pcorp.us>
Subject: Re: [postgis-users] netcdf files deprecated in raster2pgsql?

Ah, I should have specified that I'm working on a Mac (OS X 10.14).  I'm really sorry to hear that BigSQL has stopped shipping (although I see they have a PG12 beta release that is marked as 2019, so they must have stopped only recently.)  

Any chance you could suggest a good distribution for Linux and Mac, to replace BigSQL?   

Thanks,

John

On Mon, Aug 26, 2019 at 10:08 AM Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> > wrote:

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.

The binaries our windows buildbot builds, worked fine on BigSQL last I tested them:

https://postgis.net/windows_downloads/

The main caveat is the paths are different in bigsql – so where

https://winnie.postgis.net/download/windows/pg11/buildbot/

(in the zip the lib would go in - postgresql/lib , postgresql/bin ) of your PostgreSQL install.

I think BigSQL has sadly since stopped shipping (their Mac and Windows)  since Amazon bought OpenSCG (main company behind BigSQL).

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.

Thanks,

Regina

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org <mailto:postgis-users-bounces at lists.osgeo.org> ] On Behalf Of John Payne
Sent: Monday, August 26, 2019 12:54 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> >
Subject: Re: [postgis-users] netcdf files deprecated in raster2pgsql?

Hi Regina, thanks for your answer.  Your reply ended up in the wrong email folder so I didn't see it until just now.  

I'm using the BigSQL distribution (i.e., PostgreSQL and associated libraries as provided by bigsql.org <http://bigsql.org> ).  

SELECT postgis_full_version() gives this:

"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"

Sounds like maybe I should contact BigSQL.org with the question.  I appreciate you giving me some perspective.  

John

On Wed, Aug 21, 2019 at 10:13 PM Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> > wrote:

Which package system did you get your PostGIS from?

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.
NetCDF is not in the default compile of GDAL as it requires additional dependencies.

Hope that helps,
Regina

-----Original Message-----
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org <mailto:postgis-users-bounces at lists.osgeo.org> ] On Behalf Of J Payne
Sent: Wednesday, August 21, 2019 11:12 PM
To: postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
Subject: Re: [postgis-users] netcdf files deprecated in raster2pgsql?

Hi all,

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.  

With postgresql version 11.0 and postgis 2.5, this fails:
raster2pgsql -s 4326 -c -F -t 256x256 NETCDF:"[myfile]":p mytable | psql -h localhost -U [user] -d [database]

...but this works with an older version of raster2pgsql that came with PostgreSQL 9.4:
/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]

I also note that "netcdf" is not included in the list of formats returned by 'raster2pgsql -G' with the new version.

Thanks,

John

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190826/cc9dbed8/attachment.html>