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