[GRASS-user] Migrating to new RDBMS

[Moritz Lennert]

On 31/10/18 15:56, Rich Shepard wrote:
> 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?

This sounds like Stefan might be on the right path: are you sure your 
Postgresql server accepts connections from the network ? What is 
'listen_addresses' set to in your postgresql.conf ? And is password 
authentication enabled in pg_hba.conf ?

Moritz