Hi list, I hope this is not a duplicate, but I could not find any solution on the web by know.
I trying to connect to a remote postgresql database, without success. What I have done: 1) db.connect driver=pg database="host=vmhydro27,dbname=cedim_rfra,port=5432" 2)db.login driver=pg database=cedim_rfra user=sluedtke password=##### host=vmhydro27 3) db.tables -p DBMI-PostgreSQL driver error: Connection failed. 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"? DBMI-PostgreSQL driver error: Connection failed. 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 <host=vmhydro27,dbname=cedim_rfra,port=5432> I tried all drivers (odbc, ogr, pg) that made sense to me, no success. It is no problem to connect QGIS, R and python to this db and visualize the data. I am using Kubuntu 16.04 with GRASS 7.04. [I] /u/bin apt-cache show grass Mon 12 Sep 2016 13:20:37 CEST Package: grass Status: install ok installed Priority: optional Section: metapackages Installed-Size: 33 Maintainer: Debian GIS Project <pkg-grass-de...@lists.alioth.debian.org> Architecture: all Version: 7.0.4-1~xenial2 Replaces: grass7, grass70 Provides: grass7, grass70 Depends: grass-core, grass-gui Recommends: grass-doc Suggests: grass-dev Conflicts: grass7, grass70 Description: Geographic Resources Analysis Support System (GRASS GIS) Commonly referred to as GRASS, this is a Geographic Information System (GIS) used for geospatial data management and analysis, image processing, graphics/map production, spatial modeling, and visualization. GRASS is currently used in academic and commercial settings around the world, as well as by many government agencies and environmental consulting companies. . Install this virtual package to get a full GRASS system. Description-md5: 927e5df9adc0c220121824a1dcc21063 Homepage: http://grass.osgeo.org/ I am able to get info of a certain layer using ogrinfo with the connection string. Any help is appreciated. Cheers, Stefan
signature.asc
Description: OpenPGP digital signature
_______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user