[GRASS-user] Migrating to new RDBMS
mlennert at club.worldonline.be
Wed Oct 31 08:24:09 PDT 2018
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.
> 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
> 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:
> WARNING: DB connection <pg/willamette-river-hg> already exists and will be
> 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 ?
More information about the grass-user