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

[Paolo Cavallini]

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/