[GRASS-dev] db.connect & db.login problem

[Ivan Marchesini]

Dear friends & GRASS developers,

I have just found the following problem.

in may laptop I'm running GRASS 7.0.3 installed from the ubuntu-gis
unstable repository.

in a server I have both GRASS 7.0.4 installed from the ubuntu-gis
unstable repository and grass 7.2 downloaded using svn and compiled
without errors.

In my laptop i was able to connect connect to a remote postgresql db
using the following syntax:

db.connect driver=pg database="host=xxx.xxx.xxx.xxx,dbname=mydb"
db.login driver=pg  user=myuser password=mypassword

I have verified that db.table correctly list the tables of the database


in the server I have used the same syntax but db.tables produces the following error:

BMI-PostgreSQL errore del driver:
Connection failed.
could not connect to server: File o directory non esistente
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

DBMI-PostgreSQL errore del driver:
Connection failed.
could not connect to server: File o directory non esistente
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

ERRORE: Impossibile aprire il database
        <host=xxx.xxx.xxx.xxx,dbname=mydb>

It seems that grass is looking for a postgres cluster in the local machine in place of trying to connect to the remote one.

it is important to say that
psql -d mydb -h xxx.xxx.xxx.xxx -U myuser 
works both from the server and my laptop

do you think this is a problem due to my fault or I need to open a ticket?

Many thanks

Ivan