<html>
<head>
<title>Re: [GRASS-user] Unable to link to postgis/postgresql</title>
<link rel="important stylesheet" href="chrome://messagebody/skin/messageBody.css">
</head>
<body>
<table border=0 cellspacing=0 cellpadding=0 width="100%" class="header-part1"><tr><td><div class="headerdisplayname" style="display:inline;">Sujet : </div>Re: [GRASS-user] Unable to link to postgis/postgresql</td></tr><tr><td><div class="headerdisplayname" style="display:inline;">De : </div>Benoit ANDRE <benoit.andre@bcgeol.be></td></tr><tr><td><div class="headerdisplayname" style="display:inline;">Date : </div>14/09/16 11:05</td></tr></table><table border=0 cellspacing=0 cellpadding=0 width="100%" class="header-part2"><tr><td><div class="headerdisplayname" style="display:inline;">Pour : </div>grass-user@lists.osgeo.org</td></tr></table><br>
<div class="moz-text-html" lang="x-unicode"><html>
<head>
<meta http-equiv="content-type" content="text/html; ">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi list, <br>
<br>
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<br>
<br>
All my other soft using Postgresql work fine (i.e. pgadmin, odoo,
caldav, carddav, <br>
<br>
<div class="moz-cite-prefix">Le 12/09/16 13:22, Stefan Lüdtke a
écrit :<br>
</div>
<blockquote class=" cite"
id="mid_3356a8a0_e1c5_f7ae_708f_64c900828edc_gfz_potsdam_de"
cite="mid:3356a8a0-e1c5-f7ae-708f-64c900828edc@gfz-potsdam.de"
type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:pkg-grass-devel@lists.alioth.debian.org"><pkg-grass-devel@lists.alioth.debian.org></a>
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: <a class="moz-txt-link-freetext" href="http://grass.osgeo.org/">http://grass.osgeo.org/</a>
I am able to get info of a certain layer using ogrinfo with the
connection string.
Any help is appreciated.
Cheers,
Stefan
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
grass-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<table border="0" cellpadding="0" cellspacing="0" height="230"
width="422">
<tbody>
<tr>
<td style="padding-top:15px; padding-left:25px;
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:12px; color:#663515" valign="top" width="25"> <br>
</td>
<td style="padding-top:15px; padding-left:25px;
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:12px; color:#663515" valign="top" width="271">
<p style="margin-bottom:5px; padding:0"> <strong
style="font-size:14px; font-family:Verdana, Arial,
Helvetica, sans-serif; color:#00b1e6"><font
color="#00b1e6">Benoit André</font></strong><br>
<strong><font color="#663515">Directeur - Gérant</font></strong>
</p>
<p style="margin-bottom:5px; margin-top:0; padding:0"> <font
color="#663515"><a
href="mailto:benoit.andre@bcgeol.be"
style="color:#00b1e6">benoit.andre@bcgeol.be</a></font><br>
<font color="#663515">Tel. <span style="color:#00b1e6">|</span>
+32 475 61 84 94</font><br>
<font color="#663515">skype <span style="color:#00b1e6">|</span>
benoit_andre_bcg</font><br>
<a href="https://be.linkedin.com/in/benoitandre"><img
src="imap://benoit%2Eandre%40bcgeol%2Ebe@mail.bcgeol.be:143/fetch%3EUID%3E.INBOX.drafts%3E811?locale=&part=1.2&filename=btn_liprofile_blue_80x15_fr_FR.png"
alt="Voir le profil de Benoit André sur LinkedIn"
border="0" height="15" width="80"></a> </p>
<p style="margin-bottom:5px; padding:0; font-size:11px"> <strong><font
color="#663515">BCG SPRL</font></strong><br>
<font color="#663515">Tél. <span style="color:#00b1e6">|</span>
+32(0)81 58 26 11</font><br>
<font color="#663515">Fax <span style="color:#00b1e6">|</span>
+32(0)81 58 26 12</font><br>
<font color="#663515">Chemin de la Foliette, 4 Bte 2<br>
B-5000 - Namur</font><br>
<font color="#663515"><a href="http://www.bcgeol.be"
style="color:#00b1e6">www.bcgeol.be</a> - <a
href="https://maps.google.be/maps/ms?msid=210366068780572446312.0004dc0b834462107c00f&msa=0&ll=50.460427,4.856445&spn=0.001279,0.002411&iwloc=0004dc0b8345e35a35a20"
style="color:#00b1e6">plan d'accès</a></font> </p>
</td>
<td valign="top" width="151"> <a
href="http://www.bcgeol.be"><img
src="imap://benoit%2Eandre%40bcgeol%2Ebe@mail.bcgeol.be:143/fetch%3EUID%3E.INBOX.drafts%3E811?locale=&part=1.3&filename=bcg_logo.gif" alt="BCG
LOGO" border="0" height="112" width="151"></a> </td>
</tr>
<tr>
<td colspan="3" height="64" valign="top"> <img
src="imap://benoit%2Eandre%40bcgeol%2Ebe@mail.bcgeol.be:143/fetch%3EUID%3E.INBOX.drafts%3E811?locale=&part=1.4&filename=BCG_bas.gif" height="64"
width="422"> </td>
</tr>
</tbody>
</table>
<p style="font-size:11px"> <font color="#663515">Suivez-nous sur
<span style="padding: 5px;"><a
href="https://www.linkedin.com/company/bureau-conseil-en-g%C3%A9ologie-sprl"><img
src="imap://benoit%2Eandre%40bcgeol%2Ebe@mail.bcgeol.be:143/fetch%3EUID%3E.INBOX.drafts%3E811?locale=&part=1.5&filename=In-2C-21px-TM.png" alt="Lien
Linkedin" border="0" height="15"></a> <a
href="https://www.facebook.com/Bureau-Conseil-en-G%C3%A9ologie-153924548320189/?ref=hl"><img
src="imap://benoit%2Eandre%40bcgeol%2Ebe@mail.bcgeol.be:143/fetch%3EUID%3E.INBOX.drafts%3E811?locale=&part=1.6&filename=icone_fb.gif" alt="Lien
Facebook" border="0" height="18"></a> </span> </font><br>
</p>
<p style="color: #008000; font-size: 9px; "> Allons plus loin dans
le respect de l'environnement : <a
href="https://www.modere.eu/?referralCode=050281"
style="color: #008000; ">N'utilisons que des produits sans
empreinte écologique<img
src="imap://benoit%2Eandre%40bcgeol%2Ebe@mail.bcgeol.be:143/fetch%3EUID%3E.INBOX.drafts%3E811?locale=&part=1.7&filename=Modere_SocialMarketer_logomark.png" alt="Logo
Modere" border="0" height="27" width="30"></a>
</p>
</div>
</body>
</html>
</div></body>
</html>
</table></div>