[GRASSLIST:8782] switching to postgres

Kirk R. Wythers kwythers at umn.edu
Thu Oct 27 14:23:23 EDT 2005


When switching from dbf to postgresql, besides these steps:

PostgreSQL database

To (re)set GRASS to connect to PostgreSQL, run:


#define database settings:
db.connect driver=pg database="host=myserver.itc.it,dbname=mydb"

#define login settings:
db.login user=myname pass=secret

#list available tables
db.tables -p


Do the database and tables need to be created in with CREATE DATABASE  
and CREATE TABLE in postgresql before you set the connection with  
db.connect and v.db.connect?

Also, for some reason, the host argument on my system only seems to  
work if I use "host=localhost". Is that ok?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20051027/d1085f23/attachment.html


More information about the grass-user mailing list