Hi list,
Always the same problem with a remote Postgresql connection, with grass
7.0.4 and above (7.2 and 7.3). With grass 7.0.0, the connection to
postgresql is perfect. I don't try with 7.0.1, 7.0.2 and 7.0.3
All my other soft using Postgresql work fine (i.e. pgadmin, odoo,
caldav, carddav, libreoffice, ...)
The problem is the for all the PC on my network (server under Centos 7,
workstations under Fedora 19, 21 or 22)
Le 12/09/16 13:22, Stefan Lüdtke a écrit :
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 <[email protected]>
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
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
--
*Benoit André*
*Directeur - Gérant*
[email protected] <mailto:[email protected]>
Tel. | +32 475 61 84 94
skype | benoit_andre_bcg
Voir le profil de Benoit André sur LinkedIn
<https://be.linkedin.com/in/benoitandre>
*BCG SPRL*
Tél. | +32(0)81 58 26 11
Fax | +32(0)81 58 26 12
Chemin de la Foliette, 4 Bte 2
B-5000 - Namur
www.bcgeol.be <http://www.bcgeol.be> - plan d'accès
<https://maps.google.be/maps/ms?msid=210366068780572446312.0004dc0b834462107c00f&msa=0&ll=50.460427,4.856445&spn=0.001279,0.002411&iwloc=0004dc0b8345e35a35a20>
BCG LOGO <http://www.bcgeol.be>
Suivez-nous sur Lien Linkedin
<https://www.linkedin.com/company/bureau-conseil-en-g%C3%A9ologie-sprl>
Lien Facebook
<https://www.facebook.com/Bureau-Conseil-en-G%C3%A9ologie-153924548320189/?ref=hl>
Allons plus loin dans le respect de l'environnement : N'utilisons que
des produits sans empreinte écologiqueLogo Modere
<https://www.modere.eu/?referralCode=050281>
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
