[GRASS-user] connect to postgreSQL

[Stanislav Bek]

>> 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"?
>
>Try:
>
>	db.connect driver=pg database="host=localhost,dbname=gis1"

With this, it does not work yet.

>
>to connect using TCP.
>
>Also, "netstat -ax" will list active Unix-domain sockets. If
>postmaster is accepting local (Unix-domain) connections, its socket
>will be listed there. E.g. I have:
>
>unix  2      [ ACC ]     STREAM     LISTENING     3442     /tmp/.s.PGSQL.5432
>
>If it's listening on a Unix-domain socket, check that you have the
>necessary permissions on both the socket and its parent directories.
>
>-- 
>Glynn Clements <glynn at gclements.plus.com>


So I've done:

GRASS 6.3.0 (opava):~/skripty > netstat -ax| grep post
unix  2      [ ACC ]     STREAM     LISTENING     13460    /var/run/postgresql/.s.PGSQL.5433
sudo chmod 777  /var/run/postgresql/.s.PGSQL.5433
sudo chmod 777  /var/run/postgresql/

in postgresql.conf there is a line:
#unix_socket_permissions = 0777		# begin with 0 to use octal notation

After that:  db.test test=test1 again without success.

Thank you very much for your help.
Best regards,
Stanislav