[postgis-users] -R rasters fail to \i

[Paolo Cavallini]

Il 05/01/2017 11:58, Paolo Cavallini ha scritto:
> Hi all,
> creating an out-of-db raster fails:
> ===
> raster2pgsql -s 3003 -I -M -C -R
> /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf dtm_ext > dtm_ext.sql
> 
> \i dtm_ext.sql
> BEGIN
> Tempo: 0,234 ms
> CREATE TABLE
> Tempo: 10,956 ms
> psql:dtm_ext.sql:3: ERRORE:  XX000: rt_band_load_offline_data: Cannot
> open offline raster: /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf

Further tests revealed that it works for tif, not for adf, even with

SET postgis.enable_outdb_rasters TO True;
SET postgis.gdal_enabled_drivers TO DISABLE_ALL;

All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all&geo=IT&q=qgis,arcgis