[GRASS-user] Unable to link to postgis/postgresql

Wed Sep 14 02:22:57 PDT 2016

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 <pkg-grass-devel at 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
>
>
>
>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user

-- 

*Benoit André*
*Directeur - Gérant*

benoit.andre at bcgeol.be <mailto:benoit.andre at bcgeol.be>
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>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/5fbeb062/attachment-0002.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/5fbeb062/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bcg_logo.gif
Type: image/gif
Size: 4376 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/5fbeb062/attachment-0003.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BCG_bas.gif
Type: image/gif
Size: 4888 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/5fbeb062/attachment-0004.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: In-2C-21px-TM.png
Type: image/png
Size: 1242 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/5fbeb062/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: icone_fb.gif
Type: image/gif
Size: 1317 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/5fbeb062/attachment-0005.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Modere_SocialMarketer_logomark.png
Type: image/png
Size: 2910 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160914/5fbeb062/attachment-0003.png>