I'm trying to establish a database connection that will store newly created
vector map's attribute tables in a remote database. However, when I run
r.to.vect, the old parameters are still active and I can't seem to override
them. Here's what I've done.
I've created a db connection using db.connect to a remote postgres database
using:
db.connect driver=pg database="host=tsetse2.geo.msu.msu,dbname=hpcc"
db.login user=langley
I can run
db.tables -p
and get a current list of tables in the database (I tried adding a new one on
the remote server and it showed up here)
I can also run
db.test test1
and get the following output:
create table grass_test1 (i1 integer, d1 double precision, c1 varchar(20))
EXECUTE: OK
insert into grass_test1 values ( 1, 123.456, 'abcd' )
EXECUTE: OK
insert into grass_test1 values ( 2, null, 'xxx' )
EXECUTE: OK
select * from grass_test1
EXECUTE: OK
RESULT: OK
select c1 from grass_test1 where d1 < 500 / 2 and i1 <> 2 and c1 ~ 'bc'
EXECUTE: OK
RESULT: OK
insert into grass_test1 values ( 3, 0.0, '_''_' )
EXECUTE: OK
alter table grass_test1 add column i2 integer
EXECUTE: OK
update grass_test1 set d1 = 18.6, i2 = 987 where i1 = 2
EXECUTE: OK
select * from grass_test1
EXECUTE: OK
2d1
< 3|0|_'_|
3a3
> 3|0|_'_|
ERROR: RESULT: ******** ERROR ********
drop table grass_test1
EXECUTE: OK
EXECUTE: OK
Yet when I run:
r.to.vect input=foo output=foo_vect
I get the following error which references the old parameter settings:
WARNING: Vector map <foo_vect> already exists and will be
overwritten
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: No such file or
directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
WARNING: Unable to open database <salangley> by driver <pg>
WARNING: Unable open database <salangley> by driver <pg>
WARNING: Unable to find table <foo_vect> linked to vector map
<foo_vect>
ERROR: Unable to delete vector map <foo_vect>
I tried to create a new database on the remote server called "salangley" but I
still get the same error. Somehow it seems to be failing to read the new db
connection parameters I've set. Can anyone help me figure out how to reset
things?
Thanks,
Shaun
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
