Hi Andrea,
I always put the raster somewhere below Postgresql data_directory.
psql
show data_directory;
I hope it helps.
Saluti,
Jorge
On 04/12/23 22:23, andy via postgis-users wrote:
Hi,
if I run "SELECT (ST_BandMetaData(rast)).* FROM rasters_outdb LIMIT
1;", in the field path I have "/directory_docker/ou_s6_01_01_stack.tif"
If I run "ls -l /directory_docker/ou_s6_01_01_stack.tif" I have
-rwxr--r-- 1 1000 1000 2100227 Dec 4 08:32
/directory_docker/ou_s6_01_01_stack.tif
But when I run "SELECT ST_Value(rast, 1, 1) FROM rasters_outdb;" I get
ERROR: rt_band_load_offline_data: Cannot open offline raster:
/directory_docker/ou_s6_01_01_stack.tif
Why is it offline? It's there.
I'm using postgis/postgis:16-master
I have created the sql file to load it in postgres, running
raster2pgsql -I -C -M -F -t auto -R
/directory_docker/ou_s6_01_01_stack.tif public.rasters_outdb
How to read the pixel values using a PG SQL query?
Thank you
--
___________________
Andrea Borruso
website: https://medium.com/tantotanto
38° 7' 48" N, 13° 21' 9" E, EPSG:4326
___________________
"cercare e saper riconoscere chi e cosa,
in mezzo all’inferno, non è inferno,
e farlo durare, e dargli spazio"
Italo Calvino
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
