[GRASS-user] GRASS & PostgreSQL - simplist workings

[Dylan Beaudette]

On Friday 28 July 2006 04:28, M S wrote:
> what is the simplest way to get GRASS connected to a PostgreSQL database? 
> I have built a postgres database and created a table.
>
> I suspect that i have two problems:
> 1) my pg_hba.conf file (or not starting postmaster with -i flag?  it is
> currently started from an init.d script, but i thought i located where in
> that startup script file postmaster is fired up and have tried -i)
> 2) my command line connection may be faulty.
>
> my pg_hba.conf file for host has "host  all  all  192.168.0.0/16  trust"
>
> my connection attempt via GRASS is: v.db.connect -o map=sites driver=pg
> database="host=localhost,dbname=sites" table=distances
>
> which yeilds the following error:
> DBMI-Postgres driver error:
> Cannot connect to Postgres: FATAL: missing or erroneous pg_hba.conf file.
>
> i have also tried using the db.login command too.

have a look at these links:

http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html
http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html

c/o postgis mailing list. 

-- 
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341