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