Opened 3 years ago

Last modified 3 years ago

#5479 new defect

osmosis can't append osm data into database

Reported by: fazlerabbi37@… Owned by: bretth
Priority: major Milestone:
Component: osmosis Version:
Keywords: Cc:


at first I upload data into database using this command- osmosis --read-pbf previous.osm.pbf --write-apidb host="localhost" database="openstreetmap" user="postgres" password="postgres" validateSchemaVersion="no" and its working fine. Next I produce a diff.osc.gz using following command- osmosis --read-pbf latest.osm.pbf --read-apidb host="localhost" database="openstreetmap" user="postgres" password="postgres" validateSchemaVersion=no --derive-change --write-xml-change file=diff.osc.gz Then I use the following command to append data into database- osmosis --read-xml-change diff.osc.gz --write-pgsql-change user="postgres" database="openstreetmap" password="postgres" validateSchemaVersion="no" It shows me following error: SEVERE: Thread for task 1-read-xml-change failed org.springframework.jdbc.BadSqlGrammarException?: PreparedStatementCallback?; bad SQL grammar [SELECT id, name FROM users WHERE id = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: column "name" does not exist

Am I doing something wrong? what is the right procedure?

Change History (1)

comment:1 Changed 3 years ago by fazlerabbi37@…

Priority: minormajor
Note: See TracTickets for help on using tickets.