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:[email protected]] Sent: Monday, August 26, 2019 1:18 PM To: Regina Obe <[email protected]> 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 <[email protected] <mailto:[email protected]> > 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:[email protected] <mailto:[email protected]> ] On Behalf Of John Payne Sent: Monday, August 26, 2019 12:54 PM To: PostGIS Users Discussion <[email protected] <mailto:[email protected]> > 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 <[email protected] <mailto:[email protected]> > 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:[email protected] <mailto:[email protected]> ] On Behalf Of J Payne Sent: Wednesday, August 21, 2019 11:12 PM To: [email protected] <mailto:[email protected]> 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 [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
