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
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 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
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
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
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,
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
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
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: h
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 line
10 matches
Mail list logo
