On Wed, 31 Oct 2018, Moritz Lennert wrote:
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,
Thank you. I use hyphens in multi-word file names while applications such
as grass and R use underscores. When I get them mixed up I have a tendency
to not see the discrepancy which is obvious to others.
Now I need to fix an issue with db.connect. Perhaps others will see what
I'm overlooking.
db.connect -p
driver: pg
database: willamette-river-hg
schema:
group:
Which suggests that grass sees the database. But, when I try to copy a
table from sqlite to pg the application fails to find the database:
The script:
db.connect driver=pg database="willamette-river-hg"
db.login driver=pg database="willamette-river-hg" host='salmo' port=5432 --o
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
The result:
$HOME/documents/white-papers/geochemistry/willamette-river-mercury/scripts/grass-to-postgres.sh
WARNING: DB connection <pg/willamette-river-hg> already exists and will be
overwritten
DBMI-PostgreSQL driver error:
Connection failed.
could not connect to server: Connection refused
Is the server running on host "salmo" (192.168.55.1) and accepting
TCP/IP connections on port 5432?
Contents of ~/.pgpass:
localhost:5432:*:rshepard:
Replacing localhost with salmo makes no difference.
Best regards,
Rich
_______________________________________________
grass-user mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/grass-user
