/me stupid: postgresql did not have read access to the file. sorry for the noise
Il 06/11/19 08:18, Paolo Cavallini ha scritto: > Hi Jorge, > > Il 05/11/19 21:34, Jorge Gustavo Rocha ha scritto: > >> If you have GDAL >= 2.4, it should work. Can you check your GDAL version? > > 2.4.2+dfsg-2 > >> Do you also have overviews/pyramids? The overviews should work, because >> they are in db. Only the original raster is out-of-db. > > sure, all "normal" rasters, incluging the pyramids, are correctly shown. > > thanks for the feedback. > >> Às 20:24 de 05/11/19, Paolo Cavallini escreveu: >>> Hi all, >>> loading PostGIS rasters from the browser works very well, thanks Ale! >>> However, those loaded with the -R option (out of db rasters) throw an error: >>> >>> Warning: Logged warning: RasterIO error: >>> PostGISRasterRasterBand::IRasterIO(): ERROR: rt_band_load_offline_data: >>> Cannot open offline raster: >>> /home/paolo/Documents/Didattica/Corsi_Formazione_Faunalia/PostGIS/data/dtm_nord.tif >>> >>> I have enabled out-of-db rasters: >>> >>> POSTGIS_ENABLE_OUTDB_RASTERS=1 >>> POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL >>> >>> The same data are readable from psql >>> select * from dtm_ext ; >>> ┌─────┬─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── >>> │ rid │ >>> >>> ├─────┼─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── >>> │ 1 │ 01000001... >>> >>> Is this a known limitation, or do I need some additional config? >>> >>> Thanks. >>> >> >> J. Gustavo >> > -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ _______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
