<html>
<head>
<title>Re: [GRASS-user] Grass 7 and 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] Grass 7 and 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>02/09/16 12:47</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>Moritz Lennert <mlennert@club.worldonline.be>, 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">
Moritz, <br>
<br>
First, I move from 6 to 7 with <i>v.build</i> or <i>v.build.all</i>
(depends on locations)<br>
<br>
Here, connections are already gone...<br>
<br>
I connect with : <br>
<i>db.connect driver=pg
database="host=192.168.1.200,dbname=administration"</i><br>
<br>
<i>db.connect -p</i> :<br>
driver: pg<br>
database: host=192.168.1.200,dbname=administration<br>
schema: public<br>
group:<br>
<br>
<i>db.login --overwrite user=benoit</i><br>
ATTENTION: DB connection
<pg/host=192.168.1.200,dbname=administration><br>
already exists and will be overwritten<br>
<br>
<br>
When I try a <i>db.tables -p</i>, I get :<br>
DBMI-PostgreSQL erreur de pilote :<br>
Connection failed.<br>
n'a pas pu se connecter au serveur : Aucun fichier ou dossier de ce
type<br>
Le serveur est-il actif localement et accepte-t-il les
connexions sur la<br>
socket Unix « /var/run/postgresql/.s.PGSQL.5432 » ?<br>
<br>
<br>
DBMI-PostgreSQL erreur de pilote :<br>
Connection failed.<br>
n'a pas pu se connecter au serveur : Aucun fichier ou dossier de ce
type<br>
Le serveur est-il actif localement et accepte-t-il les
connexions sur la<br>
socket Unix « /var/run/postgresql/.s.PGSQL.5432 » ?<br>
<br>
<br>
ERREUR :Unable to open database
<host=192.168.1.200,dbname=administration><br>
<br>
<br>
<i>v.db.connect</i> (dialog box) isn't usable, because the field
'Name of attribute table' is empty...<br>
<br>
Il I try : <i>v.db.connect -o map=survey_bcg@benoit
table=survey_bcg key=cat layer=1</i> (for facility, table name is
the same as map name), result is<br>
<br>
<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">Le 02/09/16 12:04, Moritz Lennert a
écrit :<br>
</div>
<blockquote class=" cite"
id="mid_be716cc3_24b2_2652_4fc8_cbe8187480d8_club_worldonline_be"
cite="mid:be716cc3-24b2-2652-4fc8-cbe8187480d8@club.worldonline.be"
type="cite">On 02/09/16 11:38, Benoit ANDRE wrote:
<br>
<blockquote class=" cite" id="Cite_4624150" type="cite">Hi all,
<br>
<br>
Our GIS infrastructure is based on Grass 6.4.4, postrgresql 9.x
and
<br>
Qgis. Those all together are perfectly working.
<br>
<br>
We want to update from 6.4.4 to 7.0.4. But we are confronted to
a
<br>
problem with the database : connection to postgresql is no more
possible
<br>
for all our maps (but still working with 6.4.4, and all the
other soft
<br>
overlying on postgresql). The message is the 'normal' message
wen the
<br>
connection is no possible (in french) :
<br>
<br>
/DBMI-PostgreSQL erreur de pilote ://
<br>
//Connection failed.//
<br>
//n'a pas pu se connecter au serveur : Aucun fichier ou dossier
de ce type//
<br>
// Le serveur est-il actif localement et accepte-t-il les
connexions
<br>
sur la//
<br>
// socket Unix « /var/run/postgresql/.s.PGSQL.5432 » ?/
<br>
<br>
I really don't understand the problem.
<br>
<br>
Any idea ?
<br>
</blockquote>
<br>
We need a bit more information to be able to help you. What
command leads to this error ? What did you do to move from grass6
to grass7 ? How is the data connection defined ('v.db.connect -p'
and 'db.connect -p') ?
<br>
<br>
Moritz
<br>
</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%3E796?locale=&part=1.2"
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%3E796?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%3E796?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%3E796?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%3E796?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%3E796?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>