[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