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
ay, December 4, 2023 5:24 PM
To: PostGIS Users Discussion
Cc: andy
Subject: [postgis-users] out db: not able to query the raster
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&quo
Hi Regina,
I'm running all from docker.
"/directory_docker" is pointing to a folder on my host machine.
If I run
SELECT * FROM pg_ls_dir('/directory_docker');
I get my files
pg_ls_dir
---
ou_s6_01_01_stack.sql
ou_s6_01_01_stack.tif
(2 rows)
But, if I run
SELECT *
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 "/di
users@lists.osgeo.org
Cc: Jorge Gustavo Rocha
Subject: Re: [postgis-users] out db: not able to query the raster
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,
Good morning,
I still couldn't read the tif. As written before postgis can read the
folder, and it sees the image inside.
But if I point directly to the folder, it doesn't see it.
What am I doing wrong?
Sorry to write again, but I am stuck.
Thank you
--
___
Andrea Borruso
webs
I should correct myself: I meant to say that if I point directly to the
image, postgis doesn't see it.
On Thu, 7 Dec 2023 at 08:30, andy wrote:
> Good morning,
> I still couldn't read the tif. As written before postgis can read the
> folder, and it sees the image inside.
> But if I point direct
Hi all,
I had missed some messages, sorry.
But I still can't do a query on a raster.
I'll rewrite everything I've done.
I start with docker:
docker pull postgis/postgis:16-master
docker run --name postgis16 \
-p 5432:5432 \
-v /home/user/folder:/directory_docker \
-e POSTGRES_PASSWORD=thePasswo
Hi Andrea,
I did it using docker and it works as expected.
Here is the copy and paste of what I did:
docker run --name postgis16 -p :5432 -e
POSTGRES_PASSWORD=thePassword -d postgis/postgis:16-master
docker cp
/home/jgr/geoserver/data_dir/temp/smiguel/populacao_20221001.tiff
437022e5eb
Hi Jorge,
thank you very much.
I hope it help
It helps if the way to make it works properly is to run:
ALTER DATABASE test SET postgis.enable_outdb_rasters = true;
and
ALTER DATABASE test SET postgis.gdal_enabled_drivers TO 'ENABLE_ALL';
These seem to me to be the only two differences.
I wil
Hi to all,
using
ALTER DATABASE test SET postgis.enable_outdb_rasters = true;
and
ALTER DATABASE test SET postgis.gdal_enabled_drivers TO 'ENABLE_ALL';
IT WORKS
Thank you again Jorge!
I should have read the documentation better. Sorry.
I don't know if it is useful to return an error messa
11 matches
Mail list logo