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 command to: osmosis --read-xml-change file="asiadiff.osc" --write-pgsql-change database="gis" user="osm" password="x" host="localhost" or osmosis --read-xml-change file="asiadiff.osc" --write-pgsimp-change database="gis" user="osm" password="x" host="localhost" but still no luck, I got another exception: "org.postgresql.util.PSQLException: ERROR: relation "schema_info" does not exist" any other references? thank you. -- sincerely, Oon Arfiandwi On Mon, Dec 19, 2011 at 4:19 AM, Frederik Ramm <frede...@remote.org> wrote: > Hi, > > The correct way to apply file C to your database is > > osmosis --read-xml-change asiadiff.osc --write-apidb-change > dbType="postgresql" database="osm" user="osm" password="xxx" > > Be aware that an APIDB database records object history, i.e. it can have old > versions of each object, but the approach you are following does not give > you the full history - if an object was at version 1 on 10 December and at > version 5 on 17 December, then after updating your database will only > contain versions 1 and 5, not versions 1,2,3,4,5. > > > Bye > Frederik > _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev