raster2pgsql error required password

Question

i'm trying to import raster to postgis using this command ;

raster2pgsql -I -C -s 4326 -t 100x100 -M "C:\DATA TRIAL APOLLO\mosaik129_130.ecw" -F public.mosaik129_130 | psql -d apollo_db

but then error message :

ERROR: unable to read raster file: C:\DATA TRIAL APOLLO\mosaik129_130.ecw

and it's requiring a password, even on my windows account, i'm not setting any password.

does anyone have solutions?

Try to use -w switch(no password), may be together with -U (user). — Zoltan
– Zoltan, Commented Jun 7, 2018 at 4:30
still doesn't work. i input : raster2pgsql -I -C -s 4326 -t 100x100 -M "C:\DATA TRIAL APOLLO\mosaik129_130.ecw" -F public.mosaik129_130 | psql -d apollo_db -w switch. and it goes : ERROR: unable to read raster file: C:\DATA TRIAL APOLLO\mosaik129_130.ecw psql: fe_sendauth: no password supplied — Lia
– Lia, Commented Jun 7, 2018 at 6:25
It's requiring you to supply a password for the database, not windows. If you have ever used anything else to connect to the database then you probably know what information to supply. Regarding "unable to read raster file" though, are you sure that your gdal supports .ecw files ? — GHRF
– GHRF, Commented Jun 7, 2018 at 7:50
i also try using other raster format (.tif). but the result is still the same ERROR: unable to read raster file. i also already input the postgresql database password, it's still error like this : psql: FATAL: password authentication failed for user "amal" i already check pgpass.conf, input the password stated there, and still goes failed. and for windows account, i'm not setting any password. — Lia
– Lia, Commented Jun 7, 2018 at 8:05
Please Edit the question in response to requests for clarification. It's not fair to those who would answer to need to mine the comments for critical information. — Vince
– Vince, Commented Jun 7, 2018 at 10:35

Mostafa Fallah · Accepted Answer · 2020-05-29 14:53:01Z

1

You have two problem. But The main problem is ECW format that you need to install GDAL Plugin for it. Please have a look here

answered May 29, 2020 at 14:53

Mostafa Fallah

1418 bronze badges

HeikkiVesanto · Accepted Answer · 2024-08-29 13:52:49Z

0

It is asking for the password to your PostgreSQL database for user amal.

You need to supply it like:

raster2pgsql -I -C -s 4326 -t 100x100 -M "C:\DATA TRIAL APOLLO\mosaik129_130.ecw" -F public.mosaik129_130 | PGPASSWORD=yourpass psql -d apollo_db

PGPASSWORD=yourpass added

If your database doesn't have a user called amal, you need to either supply a username as well in psql part of the query or create one.

answered Aug 28, 2024 at 8:33

HeikkiVesanto♦

17.1k3 gold badges49 silver badges82 bronze badges

2 Answers 2