On Tue, Oct 30, 2018 at 10:54 PM Rich Shepard <[email protected]> wrote: > > On Tue, 30 Oct 2018, Markus Metz wrote: > > > db.connect only sets the default database, it does not test if it exists > > or is accessible. For PG, you need to use db.login first in order to > > actually use the PG database. > > Markus M, > > Sigh. Neither without or with a username it still fails: > > > db.login driver=pg database="willamette_river_hg" user=rshepard --o
try to set host and port with db.login. Username and password are not required if a ~/.pgpass file exists. See the manual of db.login, following the link to PostgreSQL that describes the GRASS PG driver. Markus M > WARNING: DB connection <pg/willamette_river_hg> already exists and will be > overwritten > > db.copy from_driver=sqlite from_database="$HOME/data/grassdata/willamette_basin/mercury/sqlite/sqlite.db" from_table=all_species to_driver=pg to_database="willamette_river_hg" to_table=all_species.pg > DBMI-PostgreSQL driver error: > Connection failed. > FATAL: database "willamette_river_hg" does not exist > > DBMI-PostgreSQL driver error: > Connection failed. > FATAL: database "willamette_river_hg" does not exist > > WARNING: Unable to open database <willamette_river_hg> by driver <pg> > no database is open > no database is open > WARNING: Copy table failed > > Thanks, > > Rich > _______________________________________________ > grass-user mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/grass-user
_______________________________________________ grass-user mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
