<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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.<div><br></div><div>I've created a db connection using db.connect to a remote postgres database using: <div><div><br></div><div><i>db.connect driver=pg database="host=tsetse2.geo.msu.msu,dbname=hpcc"</i></div><div><i>db.login user=langley</i></div><div><br></div><div>I can run </div><div><br></div><div><i>db.tables -p</i></div><div><br></div><div>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)</div><div><br></div><div>I can also run </div><div><br></div><div><i>db.test test1</i></div><div><br></div><div>and get the following output:</div><div><br></div><div><div><i>create table grass_test1 (i1 integer, d1 double precision, c1 varchar(20))</i></div><div><i>EXECUTE: OK</i></div><div><i>insert into grass_test1 values ( 1, 123.456, 'abcd' )</i></div><div><i>EXECUTE: OK</i></div><div><i>insert into grass_test1 values ( 2, null, 'xxx' )</i></div><div><i>EXECUTE: OK</i></div><div><i>select * from grass_test1</i></div><div><i>EXECUTE: OK</i></div><div><i>RESULT: OK</i></div><div><i>select c1 from grass_test1 where d1 < 500 / 2 and i1 <> 2 and c1 ~ 'bc'</i></div><div><i>EXECUTE: OK</i></div><div><i>RESULT: OK</i></div><div><i>insert into grass_test1 values ( 3, 0.0, '_''_' )</i></div><div><i>EXECUTE: OK</i></div><div><i>alter table grass_test1 add column i2 integer</i></div><div><i>EXECUTE: OK</i></div><div><i>update grass_test1 set d1 = 18.6, i2 = 987 where i1 = 2</i></div><div><i>EXECUTE: OK</i></div><div><i>select * from grass_test1</i></div><div><i>EXECUTE: OK</i></div><div><i>2d1</i></div><div><i>< 3|0|_'_|</i></div><div><i>3a3</i></div><div><i>> 3|0|_'_|</i></div><div><i>ERROR: RESULT: ******** ERROR ********</i></div><div><i>drop table grass_test1</i></div><div><i>EXECUTE: OK</i></div><div><i><br></i></div><div><i>EXECUTE: OK</i></div></div><div><br></div><div><br></div><div><br></div><div>Yet when I run:</div><div><br></div><div>r.to.vect input=foo output=foo_vect</div><div><br></div><div>I get the following error which references the old parameter settings:</div><div><br></div><div><div><i>WARNING: Vector map <foo_vect> already exists and will be</i></div><div><i> overwritten</i></div><div><i>DBMI-Postgres driver error:</i></div><div><i>Cannot connect to Postgres: could not connect to server: No such file or directory</i></div><div><i><span class="Apple-tab-span" style="white-space:pre"> </span>Is the server running locally and accepting</i></div><div><i><span class="Apple-tab-span" style="white-space:pre"> </span>connections on Unix domain socket "/tmp/.s.PGSQL.5432"?</i></div><div><i><br></i></div><div><i><br></i></div><div><i>WARNING: Unable to open database <salangley> by driver <pg></i></div><div><i>WARNING: Unable open database <salangley> by driver <pg></i></div><div><i>WARNING: Unable to find table <foo_vect> linked to vector map</i></div><div><i> <foo_vect></i></div><div><i>ERROR: Unable to delete vector map <foo_vect></i></div></div><div><br></div><div><br></div><div><br></div><div>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?</div><div><br></div><div>Thanks,</div><div>Shaun</div><div><br></div></div></div></body></html>