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
Il 05/01/2017 15:44, Regina Obe ha scritto:
> 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 dr
b, in db). If it goes then I think it's probably a permission
issue.
-Original Message-
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Paolo Cavallini
Sent: Thursday, January 05, 2017 5:59 AM
To: postgis-users@lists.osgeo.org
Subject: [postgis-users]
Hi,
maybe the postgres user cannot access the offline band ?
Check permissions on /home/paolo/Scrivania/postgis/Dati/dtm .
2017-01-05 11:58 GMT+01:00 Paolo Cavallini :
> Hi all,
> creating an out-of-db raster fails:
> ===
> raster2pgsql -s 3003 -I -M -C -R
> /home/paolo/Scrivania/postgis/Dati/dt
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('01000
