[GRASSLIST:8058] GRASS - PGSQL - PostGIS

[Martin Wegmann]

Hello, 

since a few days I am back on the GRASS-Postgresql issue, this time using 
GRASS 6, Postgis, Postgresql 7.4 (deb repository), however I am stumbling 
over a few problems:

so far I did: 

install GRASS
install Postgresql 7.4.7
> createuser
> createdb grass_pg

install PostGIS (deb unstable)
> createlang plpgsql grass_pg   

inside GRASS
>db.login driver=pg database=grass_pg
> db.connect driver=pg database=grass_pg 
>v.db.connect map=soils driver=pg database=grass_pg table=test_tb key=cat 
layer=1 -o 
>GRASS_INFO_WARNING(6534,1): Table <test_tb> does not exist in database 
<grass_pg>
>GRASS_INFO_WARNING(6534,2): The table <test_tb> is now part of vector map 
<soils2> and may be deleted or overwritten by GRASS modules.

>v.to.db map=soils2 type=point,line,boundary,centroid layer=1 qlayer=1 
option=cat units=meters
DBMI-Postgres driver error:
Cannot select:
SELECT cat FROM test_tb
ERROR:  relation "test_tb" does not exist
Updating database ... Segmentation fault

which point did I miss? 

However I would love to have a tutorial how to use GRASS in conjunction with 
Postgresql which tells me which software I do need and how I initialise this 
cross-package functionality. I haven't found a link to a tutorial, in case I 
missed it, I would be glad if you can send a link. 

regards, Martin




-- 
Martin Wegmann

DLR - German Aerospace Center
German Remote Sensing Data Center
@
Dept.of Geography
Remote Sensing and Biodiversity Unit
&&
Dept. of Animal Ecology and Tropical Biology
University of Wuerzburg
Am Hubland
97074 Würzburg

phone: +49-(0)931 - 888 4797
mobile: +49-(0)175 2091725
fax:   +49-(0)931 - 888 4961
http://www.biota-africa.org
http://www.biogis.de