[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