<HTML><BODY DEFANGED_STYLE="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">When switching from dbf to postgresql, besides these steps:<DIV><BR class="khtml-block-placeholder"></DIV><P DEFANGED_STYLE="margin: 0.0px 0.0px 15.0px 0.0px"><FONT class="Apple-style-span" color="#111111" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 15.6px;"><B>PostgreSQL database</B></SPAN></FONT></P><P DEFANGED_STYLE="margin: 0.0px 0.0px 13.0px 0.0px"><FONT class="Apple-style-span" color="#111111" face="Arial" size="4"><SPAN class="Apple-style-span" DEFANGED_STYLE="font-size: 13.3px;">To (re)set GRASS to connect to </SPAN></FONT><A href="http://grass.gdf-hannover.de/twiki/bin/view/GRASS/PostgreSQL"><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" DEFANGED_STYLE="font-size: 13.3px;"><FONT class="Apple-style-span" color="#319C35">PostgreSQL</FONT></SPAN></FONT></A><FONT class="Apple-style-span" color="#111111" face="Arial" size="4"><SPAN class="Apple-style-span" DEFANGED_STYLE="font-size: 13.3px;">, run:</SPAN></FONT></P><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10.8px/normal Courier; min-height: 13px; "><FONT class="Apple-style-span" color="#111111"><BR></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" color="#111111" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 10.8px;">#define database settings:</SPAN></FONT></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" color="#111111" face="Courier" size="3"><SPAN class="Apple-style-span" DEFANGED_STYLE="font-size: 10.8px;">db.connect driver=pg database="host=myserver.itc.it,dbname=mydb"</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10.8px/normal Courier; min-height: 13px; "><FONT class="Apple-style-span" color="#111111"><BR></FONT></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" color="#111111" face="Courier" size="3"><SPAN class="Apple-style-span" DEFANGED_STYLE="font-size: 10.8px;">#define login settings:</SPAN></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" color="#111111" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 10.8px;">db.login user=myname pass=secret</SPAN></FONT></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10.8px/normal Courier; min-height: 13px; "><FONT class="Apple-style-span" color="#111111"><BR></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" color="#111111" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 10.8px;">#list available tables</SPAN></FONT></DIV><DIV DEFANGED_STYLE="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" color="#111111" face="Courier" size="3"><SPAN class="Apple-style-span" DEFANGED_STYLE="font-size: 10.8px;">db.tables -p</SPAN></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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? </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Also, for some reason, the host argument on my system only seems to work if I use "host=localhost". Is that ok?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Thanks</DIV></BODY></HTML>