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

Matteo Toro ciccpaol at libero.it
Tue Aug 4 11:50:02 EDT 2009


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
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"

ERROR 1: PostgreSQL driver doesn't currently support database creation.
Please create database with the `createdb' command.
ERROR: Cannot open OGR data source 'PG:host=localhost dbname=spearpg
       user=grass password=grass'

what's going on?

i'm using ubuntu 8.04 and grass 6.3, while postgresql is 8.3 version

thanks a lot



More information about the grass-user mailing list