Re: [postgis-users] out db: not able to query the raster

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

Re: [postgis-users] out db: not able to query the raster

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

Re: [postgis-users] out db: not able to query the raster

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

[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" 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

Re: [postgis-users] raster2pgsql gives me segmentation fault

Hi Regina, you are very kind. On Mon, 4 Dec 2023 at 18:40, Regina Obe wrote: > What does SELECT version() return? > PostgreSQL 13.11 (Debian 13.11-0+deb11u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit > Also have you tried it with in-db. (without the -R

Re: [postgis-users] out db: not able to query the raster

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 *

Re: [postgis-users] out db: not able to query the raster

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

Re: [postgis-users] out db: not able to query the raster

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

[postgis-users] raster2pgsql gives me segmentation fault

Hi, I'm using RELEASE: 3.3.2 GDAL_VERSION=36 (4975da8) in debian. When I run this command raster2pgsql -I -C -M -F -t auto -R ou_s6_01_01_stack.tif public.rasters_outdb I have in the stdout the first part without errors, but after about 80 records I have error. Below are some output example

Re: [postgis-users] raster2pgsql gives me segmentation fault

Thank you Regina. I'm using "POSTGIS="3.1.1 aaf4c79" [EXTENSION] PGSQL="130" GEOS="3.9.4-CAPI-1.14.4" PROJ="7.2.1" GDAL="GDAL 3.2.2, released 2021/03/05" LIBXML="2.9.10" LIBJSON="0.15" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER" -- ___ Andrea Borruso website: