[GRASS-user] dumping vectorial data from grass to postgis

[Markus Neteler]

On Tue, Aug 4, 2009 at 5:50 PM, Matteo Toro<ciccpaol at libero.it> wrote:
> hi everybody,
>
> i fixed my previous problem updating to grass 6.3.
> Now i'm in this trouble, while trying to move data from grass to postgis:
>
> createdb spearpg -O grass -h localhost -U grass
> createlang plpgsql spearpg -U grass
> psql spearpg -U grass -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
> psql spearpg -U grass -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
> GRASS 6.3.0 (spearfish60):~ > g.copy vect=fields,fields2
> WARNING: <fields2> already exists

(here you perhaps want to use the overwrite flag --o)

> GRASS 6.3.0 (spearfish60):~ > v.out.ogr -c input=fields2 type=area 'dsn=PG:host=localhost dbname=spearpg user=grass password=grass' olayer=fields2postgis layer=1 format=PostgreSQL
> ERROR 1: PQconnectdb failed.
> FATAL:  password authentication failed for user "grass"

Please see
http://grass.itc.it/grass64/manuals/html64_user/grass-pg.html

Did you use db.login?

Markus