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

Regina Obe lr at pcorp.us
Thu Jan 5 06:44:22 PST 2017


You sure your postgres service account can access that file?

rt_band_load_offline_data: Cannot open offline raster: /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf

 sounds like a permission error.

One way to confirm it's not the .hdf driver is to try to load one tile (not using out of db, in db).  If it goes then I think it's probably a permission issue.

-----Original Message-----
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Paolo Cavallini
Sent: Thursday, January 05, 2017 5:59 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] -R rasters fail to \i

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

less dtm_ext.sql

BEGIN;
CREATE TABLE "dtm_ext" ("rid" serial PRIMARY KEY,"rast" raster); INSERT INTO "dtm_ext" ("rast") VALUES (ST_Transform('0100000100000000000000594000000000000059C09D13253B3BB9374114AE473165C9524100000000000000000000000000000000BB0B00007A08A109CAFFFF7FFF002F686F6D652F70616F6C6F2F5363726976616E69612F706F73746769732F446174692F64746D2F6864722E61646600'::raster,
3003));
CREATE INDEX ON "dtm_ext" USING gist (st_convexhull("rast")); ANALYZE "dtm_ext"; SELECT AddRasterConstraints('','dtm_ext','rast',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,TRUE);
END;
VACUUM ANALYZE "dtm_ext";

\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
CONTESTO: funzione SQL "st_transform" istruzione 1
POSIZIONE:  rt_pg_error, rtpostgis.c:211
Tempo: 1,695 ms
psql:dtm_ext.sql:4: ERRORE:  25P02: la transazione corrente   interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione
POSIZIONE:  exec_simple_query, postgres.c:994
Tempo: 2,872 ms
psql:dtm_ext.sql:5: ERRORE:  25P02: la transazione corrente   interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione
POSIZIONE:  exec_simple_query, postgres.c:994
Tempo: 0,125 ms
psql:dtm_ext.sql:6: ERRORE:  25P02: la transazione corrente   interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione
POSIZIONE:  exec_simple_query, postgres.c:994
Tempo: 0,138 ms
ROLLBACK
Tempo: 0,135 ms
psql:dtm_ext.sql:8: ERRORE:  42P01: la relazione "dtm_ext" non esiste
POSIZIONE:  RangeVarGetRelidExtended, namespace.c:420
Tempo: 12,499 ms
===
Previously the same command was working fine.
postgresql-9.6-postgis-2.3 from Debian sid.

Thanks for any hint.
--
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
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users



More information about the postgis-users mailing list