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

[Brett Henderson]

Hi Oon,

On 20 December 2011 03:14, Oon Arfiandwi <robot at 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 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?
>

How have you created your database?  Specifically, which scripts did you
use to create the database tables?  The OpenStreetMap project has a number
of different incompatible schemas using PostgreSQL PostGIS extensions all
optimised for different purposes.
http://wiki.openstreetmap.org/wiki/List_of_Database_Schemas

If you wish to use the pgsql tasks in Osmosis you will need to use the
pgsnapshot_*.sql scripts from the scripts directory of the Osmosis
distribution.  More details are available here:
http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage#PostGIS_Tasks_.28Snapshot_Schema.29

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20111221/3f7f7cfe/attachment.html>