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

[Jorge Gustavo Rocha]

Hi Paolo,

If you have GDAL >= 2.4, it should work. Can you check your GDAL version?

Do you also have overviews/pyramids? The overviews should work, because
they are in db. Only the original raster is out-of-db.

Regards,

Jorge

À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
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Gabinete 3.29 (Piso 3)
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor