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

Oon Arfiandwi robot at ijo.me
Mon Dec 19 16:14:59 GMT 2011


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 <frederik at 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
>



More information about the dev mailing list