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
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
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
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
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
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
Yah the data directory is less likely to have screwed up permissions that the
postgres account can’t access. So I would go with Jorge’s idea.
That said I would think that having permission with r r r should do the trick
and the fact you can get a directory listing suggests the postgres
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
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
10 matches
Mail list logo