search

PostgresApp / PostgresApp

The easiest way to get started with PostgreSQL on the Mac
https://postgresapp.com
Other
7.2k stars 372 forks source link

Support NetCDF #731

Open iGN5117 opened 10 months ago

iGN5117 commented 10 months ago

Can you please release a version with latest gdal so that reading netcdf files via raster2pgsal is possible?

jakob commented 10 months ago

Have you tried using the PostgreSQL 16 Beta? I think it comes with a newer version of GDAL.

Also, it would be super helpful if you could provide us with sample files and sample code to demonstrate the problem. We don't use PostGIS ourselves, we just package it, so that would make it a lot easier for us to check if we built everything correctly.

jakob commented 10 months ago

Sorry, I was wrong, both PG 15 and 16 build with GDAL 3.5.2

Could this be related to #724?

tbussmann commented 10 months ago

you were not completely wrong on pg16 - updating GDAL is still on my ToDo list for the PostgreSQL 16 release. However, the missing support for the NetCDF format is not caused by the version of GDAL itself but by a specific build dependency (libnetcdf) for this format that we do not include. I'll have a look if adding this would be feasible...

iGN5117 commented 10 months ago

It would be amazing if adding this would be feasible, Thank you so much in advance!

tbussmann commented 8 months ago

The upcoming release will support the netCDF format in GDAL / OGR with PostgreSQL 16. The libnetcdf library was compiled without HDF5 support, the the FORMAT=NC4 and NC4C options will not be available. These can be added later, if necessary.

Please give some feedback if this driver is working for you as I don't have any workflow to test it myself. Even better if you could provide small sample data to check if the build works as expected.