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]] On Behalf Of John Payne Sent: Monday, August 26, 2019 12:54 PM To: PostGIS Users Discussion <[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
