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

Hi, 2016-09-27 15:25 GMT+02:00 Benoit ANDRE : > 3th : > - db.connect driver=pg database=administration > - db.login driver=pg database=administration user=benoit password=rien > host=192.168.1.200 port=5432 > > No matter if a password is necessary in my case this

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

On 27/09/16 14:52, Stefan Lüdtke wrote: Hi, if I do not set all parameters with db.login I do have empty fields in that file, even though I put that parameters in the db.connect command. If everything is in db.login, I can connect to the db (as reported earlier) and list tables. However I can

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

Hi Moritz, It works fine with your suggestion... Thank you. First : I erase ./grass7/dblogin (outside grass) 2nd : I go into grass 7.0.4 3th : - db.connect driver=pg database=administration - db.login driver=pg database=administration user=benoit password=rien host=192.168.1.200

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

Hi, if I do not set all parameters with db.login I do have empty fields in that file, even though I put that parameters in the db.connect command. If everything is in db.login, I can connect to the db (as reported earlier) and list tables. However I can neither link nor import them because they

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

Hi Benoît and Stefan, On 26/09/16 14:20, Benoit ANDRE wrote: 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

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

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...

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

I'll give it a go ... that sounds doable ;-) On 21/09/16 14:00, Markus Neteler wrote: > On Sep 21, 2016 1:50 PM, "Stefan Lüdtke" > wrote: >> >> Hi, >> >> I have not tried again in order to provide debug messages. Because I am >> not

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

On Sep 21, 2016 1:50 PM, "Stefan Lüdtke" wrote: > > Hi, > > I have not tried again in order to provide debug messages. Because I am > not sure whether they show anything new/different to the messages Benoit > ANDRE showed to us but its quite a bit of effort to compile

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

Hi, I have not tried again in order to provide debug messages. Because I am not sure whether they show anything new/different to the messages Benoit ANDRE showed to us but its quite a bit of effort to compile from svn. Is that output from my side still required?? Stefan On 21/09/16 13:42,

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

Hi Martin, I tried again with last release (7.0.5RC2) announced by Markus, but without results. Problem 's staying the same : no connection. The arguments to call 'psql' seems missing. Le 16/09/16 21:12, Stefan Lüdtke a écrit : Hi there, the suggestion below works. The other one

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

Hi there, the suggestion below works. The other one suggested later on with "dri" instead of "driver" by Martin with 7.0.5svn as well. I get a list of tables with db.tables -p. But non of them shows a list of vectors/rasters when I go for the "link" or "import" within the gui. I can select a db

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

Hi, 2016-09-14 17:43 GMT+02:00 Benoit ANDRE : > `--> db.login dri=pg datab=administration host=192.168.1.200 user=benoit > port=5432 btw, no password needed for connection? Ma -- Martin Landa http://geo.fsv.cvut.cz/gwiki/Landa http://gismentors.cz/mentors/landa

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

Hi, I will work through that during the weekend. An example is not that easy with a remote database ... Cheers, Stefan On 14/09/16 13:52, Martin Landa wrote: > Hi, > > 2016-09-14 13:40 GMT+02:00 Martin Landa : >> works. Could you try to enable debug message and post

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

Hi Martin, Here is my log : .-(/disques/divers/linux-1/archive/GIS/grass/grass-7.0/pyrite/grass-7.0.svn_src_snapshot_2016_09_10)(benoit@pyrite)- `--> db.connect dri=pg datab=administration D1/3: G_set_program_name(): db.connect D2/3:

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

Hi, 2016-09-14 13:06 GMT+02:00 Martin Landa : I tested with 7.0.5.svn: db.connect dri=pg datab=mydb db.login dri=pg datab=mydb host=myhost user=myuser pass=mypw port=5432 db.tables -p works. Could you try to enable debug message and post here relevant information:

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

Hi, 2016-09-12 13:22 GMT+02:00 Stefan Lüdtke : > 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 please try out: db.connect driver=pg

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

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

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

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,

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

Hi Moritz, thanks for the hints but non of them worked. As additional info. I have configured a couple of odbc connections I use in R. Using these connections in GRASS do not give an error but do not show any tables. Those odbc connections work as well from libreoffice. That's it from my side

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

Le Mon, 12 Sep 2016 13:22:29 +0200, 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) >