[GRASS-user] connect to postgreSQL

[Stanislav Bek]

Hi,

I have problem to connect to postgreSQL server from grass.

GRASS 6.3.0 (opava):~ > psql -l
        List of databases
   Name    |  Owner   | Encoding 
-----------+----------+----------
 gis1      | bekas    | UTF8
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
(4 rows)

GRASS 6.3.0 (opava):~ > db.connect driver=pg database=gis1 

GRASS 6.3.0 (opava):~ > db.test test=test1
create table grass_test1 (i1 integer, d1 double precision, c1 varchar(20))
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?


ERROR: Unable to open database <gis1>
ERROR: EXECUTE: ******** ERROR ********

etc.

I use PostgreSQL 8.3.3.

Don't you have an idea why it is not working?

Best regards,
Stanislav