[QGIS-Developer] Reading out-of-db PostgreSQL Raster

[Paolo Cavallini]

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