[GRASS-user] Migrating to new RDBMS
markus.metz.giswork at gmail.com
Tue Oct 30 14:01:32 PDT 2018
On Tue, Oct 30, 2018 at 9:41 PM Rich Shepard <rshepard at appl-ecosys.com>
> I started grass7.7.svn (r73623) and set db.connect to use driver=pg and
> database='willamette_river_hg'. Then I copied the vector files (g.copy
> vect=current_file,current_file_pg) per the migration instructions on the
> databaseintro manual page.
> Trying to run db.copy to add attribute tables to the database (except
> one that is already present) using a script with commands like this:
> db.copy from_driver=sqlite
from_table=all_species to_driver=pg to_database='willamette_river_hg'
> (on a single line)
> this is the warning generated:
> WARNING: Unable to open database
> by driver <sqlite>
> dbmi: Protocol error
> Yet, I can view the attribute table for the vector map within grass.
> Should I run db.connect to the sqlite database at the top of the
db.copy does not need db.connect. The reason for the error is that the
variable $HOME is not expanded because it is within single quotes. Use
double quotes instead of single quotes for the from_database argument and
it should work.
> grass-user mailing list
> grass-user at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the grass-user