<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Moritz, <br>
<br>
I tried with last release (7.0.5RC2) on my server (where postgresql
is running) and not on a remote workstation. Connection to database
is then a local connection. Here, there is no problem to work with
postgresql. The problem seems thus to be linked with a remote
acces...<br>
<br>
Benoit<br>
<br>
<div class="moz-cite-prefix">Le 14/09/16 12:26, Moritz Lennert a
écrit :<br>
</div>
<blockquote class=" cite"
id="mid_20160914122610_17fa1d47_moritz_ulb"
cite="mid:20160914122610.17fa1d47@moritz-ulb" type="cite">
<pre wrap="">This really is a serious issue.
Would it be possible for you to provide a reproducible example ? Ideally
starting out from the North Caroline data. Something that creates a new
postgresql database, redefined db.connect to link to that, g.copy a few
maps and then see if the connection problem still happens ?
Ideally this should go into a bug ticket and IMHO it should definitely
be a blocker for the upcoming releases as I would consider this basic
functionality.
Moritz
Le Wed, 14 Sep 2016 11:22:57 +0200,
Benoit ANDRE <a class="moz-txt-link-rfc2396E" href="mailto:benoit.andre@bcgeol.be"><benoit.andre@bcgeol.be></a> a écrit :
</pre>
<blockquote class=" cite" id="Cite_2354602" type="cite">
<pre wrap="">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 :
</pre>
<blockquote class=" cite" id="Cite_3560956" 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
_______________________________________________
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>
</blockquote>
</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="cid:part2.02060505.03080008@bcgeol.be"
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="cid:part6.01020401.07000001@bcgeol.be" alt="BCG
LOGO" border="0" height="112" width="151"></a> </td>
</tr>
<tr>
<td colspan="3" height="64" valign="top"> <img
src="cid:part8.03040804.00030807@bcgeol.be" 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="cid:part9.08090703.01080501@bcgeol.be" 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="cid:part11.04020108.03070504@bcgeol.be" 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="cid:part13.06090506.06080906@bcgeol.be" alt="Logo
Modere" border="0" height="27" width="30"></a>
</p>
</div>
</body>
</html>