[GRASS-user] v.in.db command using PostgreSQL database

[ante_anzulovic]

Hi,

I'm having a problem with extracting vector data from my PostgreSQL database.
using native WinGRASS and also GRASS 6.2.1 installed on Cygwin, on both versions I get same results

this is the set of commands that works fine:

>db.connect driver=pg database="host=localhost,dbname=projekt"
>db.login user=zmija pass=********
>db.connect -p
driver:pg
database:host=localhost,dbname=projekt
schema:(null)
group:(null)

So, now I have a valid connection to my database, GRASSecognizes it, and I checked with other
commands (db.columns, db.tables).

I have to extract vector data from database, but after using the command:

> v.in.db driver=pg database="host=localhost, dbname=projekt" 
table=public.teren x=xorig y=yorig z=zorig key=ID out=teren2 --overwrite

WARNING: The vector 'teren2' already exists and will be overwritten.
DBMI-Postgres driver error:
Cannot connect to Postgres: fe_sendauth: no password supplied

WARNING: Cannot open database 'host=localhost, dbname=projekt' ERROR: Cannot open database
<host=localhost,dbname=projekt> by driver <pg>

the driver couldn't be bad because it's used for connecting to database, and that works
how can I supply a password to v.in.db if it requires it, and I already did db.login, result being:
WARNING: The password was stored in file

please help...

Ante


-- 
Iskon.DUO - vrtoglavo brz ADSL do 10 Mbps u paketu s telefonom za 99 kn/mj.
Saznajte vise na www.iskon.hr ili putem telefona 0800 1000.