[GRASS-user] Unable to link to postgis/postgresql

[Moritz Lennert]

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 <benoit.andre at bcgeol.be> 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
> > <pkg-grass-devel at lists.alioth.debian.org> 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
> > grass-user at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/grass-user  
>