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 > _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
