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

2011-12-27 Thread Brett Henderson
On 27 December 2011 08:10, Oon Arfiandwi ro...@ijo.me wrote: Hi brett, On Wed, Dec 21, 2011 at 5:04 AM, Brett Henderson br...@bretth.com wrote: On 20 December 2011 03:14, Oon Arfiandwi ro...@ijo.me wrote: I just try to apply osmosis command below, the problem is: Caused by:

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

2011-12-26 Thread Oon Arfiandwi
Hi brett, On Wed, Dec 21, 2011 at 5:04 AM, Brett Henderson br...@bretth.com wrote: On 20 December 2011 03:14, Oon Arfiandwi ro...@ijo.me wrote: I just try to apply osmosis command below, the problem is: Caused by: org.postgresql.util.PSQLException: ERROR: relation schema_migrations does not

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

2011-12-20 Thread Brett Henderson
Hi Oon, On 20 December 2011 03:14, Oon Arfiandwi ro...@ijo.me wrote: Hi Frederik, I just try to apply osmosis command below, the problem is: Caused by: org.postgresql.util.PSQLException: ERROR: relation schema_migrations does not exist I read a solution about schema_migrations relation

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

2011-12-19 Thread Oon Arfiandwi
Hi Frederik, I just try to apply osmosis command below, the problem is: Caused by: org.postgresql.util.PSQLException: ERROR: relation schema_migrations does not exist I read a solution about schema_migrations relation here: http://forum.openstreetmap.org/viewtopic.php?id=7396 then I change the

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

2011-12-18 Thread 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

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

2011-12-18 Thread Frederik Ramm
Hi, On 12/18/2011 09:23 PM, Oon Arfiandwi wrote: 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 There is a logic problem here. You have an OSM file O1 (10 December) and an

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

2011-12-18 Thread Oon Arfiandwi
Hi Frederik, Thank you for your explanation. Before I apply command as below, I have one more question about your statement. If you don't need historic versions at all, then you might as well import the 17 December file anew instead of computing and applying an update. I'm interesting to

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

2011-12-18 Thread Frederik Ramm
Hi, On 12/19/2011 06:23 AM, Oon Arfiandwi wrote: Any explation how I can update my database without creating changeset? (And without any downtime) Did you mean I have to drop the database/tables that consist of the 10 December data then reinsert all data from the 17 December file? Yes. If