[OSM-dev] problem with osmosis to apply changeset to postgresql db

[Oon Arfiandwi]

Hi OSM dev,

I need help to understand how to keep the OSM data update.
I deployed OSM data to postgresql db from asia.osm.pbf (for example
from date 10 des).
at 17des, i try to update my postgresql db, please correct my
step-by-step below:

1. download asia.17des.osm.pbf
2. sort asia.10des.osm.pbf to asia.10des.sorted.osm.pbf (--sort
type="TypeThenId")
3. sort asia.17des.osm.pbf to asia.17des.sorted.osm.pbf
4. read from both sorted.osm.pbf then --derive-change
--write-xml-change file="asiadiff.osc"

here's the main problem,
I don't know how to apply the changeset "asiadiff.osc" to my existing
postgresql database.
any help?


I have tried to write the change to pbf and it success:
osmosis --read-xml-change file="asiadiff.osc" --read-pbf
file="asia.10des.sorted.osm.pbf" --apply-change --write-pbf
file="newchange.pbf"

but these steps all error:
osmosis --read-xml-change file="asiadiff.osc" --read-pbf
file="asia.10des.sorted.osm.pbf" --apply-change --write-apidb
dbType="postgresql" database="osm" user="osm" password="xxx"
osmosis --read-xml-change file="asiadiff.osc" --read-pbf
file="asia.10des.sorted.osm.pbf" --apply-change --write-apidb-change
dbType="postgresql" database="osm" user="osm" password="xxx"
osmosis --read-xml-change file="asiadiff.osc" --read-pbf
file="asia.10des.sorted.osm.pbf" --write-apidb-change
dbType="postgresql" database="osm" user="osm" password="xxx"
osmosis --read-xml-change file="asiadiff.osc" --write-apidb-change
dbType="postgresql" database="osm" user="osm" password="xxx"


ps: I use osmosis-0.40.1


thank you for any help.


-- 
sincerely,
Oon Arfiandwi