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 *
Are you running postgres inside the docker container or are you using your own?
I wasn’t clear if you are just using the raster2pgsql from docker or you are
using the postgresql as well.
It’s possible inside the container it doesn’t know the path as such.
Try this query in your
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
What does SELECT version() return?
Also have you tried it with in-db. (without the -R switch). Could be some sort
of permission issue. If it still breaks with in-db, that would rule out out-db
as the culprit.
I know the out-db logic we have is still not that popular so much less tested
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:
Which version of PostGIS and PostgreSQL are you running?
SELECT postgis_full_version(), version();
Also is the data publicly accessible so we can test it out?
If you can try it with https://github.com/postgis/docker-postgis as Imre
suggested, that would be great too.
I also assume
> raster2pgsql gives me segmentation fault
> I'm using RELEASE: 3.3.2 GDAL_VERSION=36 (4975da8) in debian.
Hello Andrea,
If you are familiar with Docker, you could potentially test with the
"postgis/postgis:16-master" Docker image
( https://github.com/postgis/docker-postgis )
to see if your
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
Hi Scott, hi Imre,
sorry, I didn't notice the weekend. My bad.
Cheers
Paul
> On Dec 3, 2023, at 19:48, Scott Pasnikowski via postgis-users
> wrote:
>
> Its is not dead. I asked install questions and they were answered promptly.
>
>
>> On Dec 3, 2023, at 4:34 AM, Imre Samu via
10 matches
Mail list logo