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

[Stefan Lüdtke]

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

Stefan

On 13/09/16 10:19, Moritz Lennert wrote:
> Le Mon, 12 Sep 2016 13:22:29 +0200,
> Stefan Lüdtke <sluedtke at gfz-potsdam.de> 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"
> 
> As this is the standard port, you could try without the port=5432 part
> in the database definition string.
>  
>> 2)db.login driver=pg database=cedim_rfra user=sluedtke password=#####
>> host=vmhydro27
> 
> Try with either no database info in the db.login call, or with the port
> parameter set, i.e.
> 
> db.login user=sluedtke password=######
> 
> or
> 
> db.login driver=pg database=cedim_rfra user=sluedtke password=#####
> host=vmhydro27 port=5432
> 
> Moritz
> 

-- 
Stefan Lüdtke

Section 5.4- Hydrology
Phone: +49(0)331-288-2821
Fax: +49(0)331-288-1570
Email: sluedtke at gfz-potsdam.de
___________________________________________

Helmholtz Centre Potsdam
GFZ German Research Centre for Geosciences
Foundation under public law of the federal state
of Brandenburg
Telegrafenberg, D-14473 Potsdam

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20160913/f1110044/attachment.sig>