[GRASS-user] Migrating to new RDBMS

[Moritz Lennert]

On 30/10/18 22:37, Rich Shepard wrote:
> On Tue, 30 Oct 2018, Rich Shepard wrote:
> 
>> I was thinking of working within grass rather than at the bash prompt.
>> You're right: I know the difference between double and single quotes but
>> blew it on this instance.
> 
>     I'm still missing something.
> 
>     From the grass shell the command, db.connect driver=pg
> database=willamette_river_hg, apparently completes because there's no
> warning or error displayed.
> 
>     However, the db.copy command still cannot find the database:
> 
> GRASS 7.7.svn (willamette_basin):~/data/grassdata/willamette_basin > 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
> 
>     I access the database with psql from the bash prompt with no issues:
> 
> $ psql willamette-river-hg
> psql (10.3)
> Type "help" for help.
> 
> willamette-river-hg=#

You database seems to be called 'willamette-river-hg', i.e. all hyphens, 
whereas you are trying to db.copy to 'willamette_river_hg', i.e. one 
hyphen, one underscore.

Moritz