[GRASS-user] Finding why postgres database cannot be opened

[st_kiefer at web.de]

Hi Rich,
to connect the database tabel to your map you have to specify the postgres connection with v.db.connect as well:

v.db.connect map=stations driver=pg database="host=localhost,dbname=willamette-river-hg" table=<NameOfTheTable> key=<NameOfTheCatColumn>

Consider that the <NameOfTheTable> have to be different from the name of the mapset, i.e. must not be called "stations"!

Regards.

Stefan
 
> Rich Shepard <rshepard at appl-ecosys.com> hat am 8. November 2018 um 15:07 geschrieben:
> 
> 
> On Thu, 8 Nov 2018, st_kiefer at web.de wrote:
> 
> > if you use a postgres database (driver=pg) you have to specify the full
> > connection string to the database. You can see this in the manual for
> > db.connect (look for PostgreSQL):
> 
> Stefan,
> 
>    Each time I think that I have the path requirement differences between
> db.connect and v.db.connect understood there's aninstance when I mix them up
> unintentionally. I've changed the db.connect line in the script to use
> localhost rather than the absolute path.
> 
>    As I responded to Markus M, I don't know how to fix the absolute path
> returned by v.db.connect
> 
> > db.connect driver=pg database="host=localhost,dbname=willamette-river-hg"
> 
> > db.connect -p
> driver: pg
> database: host=localhost,dbname=willamette-river-hg
> schema: 
> group:
> 
> > v.db.connect -p map=stations
> Vector map <stations> is connected by:
> layer <1/stations> table <stations> in database
> </home/rshepard/data/grassdata/willamette_basin/willamette-river-hg> through
> driver <pg> with key <cat>
> 
>    Trying again:
> 
> > db.connect driver=pg database=$HOME/data/grassdata/willamette_basin/willamette-river-hg
> 
> > v.db.connect -p map=stations
> Vector map <stations> is connected by:
> layer <1/stations> table <stations> in database
> </home/rshepard/data/grassdata/willamette_basin/willamette-river-hg> through
> driver <pg> with key <cat>
> 
>    What am I still doing incorrectly with db.connect?
> 
> Thanks,
> 
> Rich
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user