Hi Moritz,
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...
Benoit
Le 14/09/16 12:26, Moritz Lennert a écrit :
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 <[email protected]> a écrit :
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
