[GRASSLIST:9623] DB connect problems

Hi, All
please help in solving the Database connectivity problems in GRASS

v.db.connect
Problem: 1. While connecting a table (‘ap’) created in database ('geodata) PostgreSQL with a vector map in GRASS

The errors are :
a. Cannot connect to Postgres: FATAL: dabase “$computer/geodata/geodata/pg/” does not exist
b. Cannot open database “$computer/geodata/geodata/pg/” by driver ‘pg’

c. The table does not exist as database /$computer/geodata/geodata/pg/"

db.connect
db.connect driver=pg database=$GISDBASE/$LOCATION_NAME/$MAPSET/pg group=geodata

after the selection of driver ‘pg’ with the above step, while creating table in v.digit

the! errors are:
a. Cannot open database “$GISDBASE/$LOCATION_NAME/$MAPSET/pg” by driver
by driver pgDBMI-postgres driver
b. cannot connect to postgres: FATAL : database
“//home/geodata/GrassDataAp/apll/rtc/pg” does not exist.
Ravi Kumar


Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

RAVI KUMAR wrote:

Hi, All
please help in solving the Database connectivity problems in GRASS

*v.db.connect*
Problem: 1. While connecting a table ('ap') created in database
('geodata) PostgreSQL with a vector map in GRASS

The errors are :
a. Cannot connect to Postgres: FATAL: dabase
"$computer/geodata/geodata/pg/" does not exist
b. Cannot open database "$computer/geodata/geodata/pg/" by driver 'pg'

c. The table <ap> does not exist as database
/$computer/geodata/geodata/pg/"

*db.connect*
db.connect driver=pg database=$GISDBASE/$LOCATION_NAME/$MAPSET/pg
group=geodata

after the selection of driver 'pg' with the above step, while creating
table in v.digit

the! errors are:
a. Cannot open database "$GISDBASE/$LOCATION_NAME/$MAPSET/pg" by driver
     by driver pgDBMI-postgres driver
b. cannot connect to postgres: FATAL : database
      "//home/geodata/GrassDataAp/apll/rtc/pg" does not exist.
*Ravi Kumar*

****
**Ravi,

you have to use *single* quotes to protect the variables above. Please
see the manual pages for details.

Markus
***
*