[GRASS-user] database connection problems

[Shaun Langley]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20130407/1837588c/attachment.html>