[GRASS-user] Migrating to new RDBMS

[Rich Shepard]

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