[OSM-dev] Schema version problem with osmosis & postgresql/postgis
Benjamin Meier
b.meierr at googlemail.com
Tue May 31 14:25:15 BST 2011
Hi,
I want to setup a Postgresql/postgis DB and fill it with data from a
xml-file using osmosis. For this I'm using this tutorial:
http://wiki.openstreetmap.org/wiki/Osmosis_PostGIS_Setup
I'm using Ubuntu 10.10 with Postgresql-8.4 and osmosis-0.39
I followed the instructions from the tutorial to setup the database and
edited some paths to match with my filesystem.
sudo su - postgres
createdb osm
createlang plpgsql osm
createuser user
psql -d osm -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
psql -d osm -f
/usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql
psql -d osm -f /usr/share/postgresql/8.4/contrib/hstore.sql
psql -d osm -f
/home/benny/Desktop/DA/programme/osmosis-0.39/script/pgsimple_schema_0.6.sql
Those commands worked without errors.
When I run osmosis with:
./osmosis --read-xml file="/media/daten/osm/someplace.osm" --write-pgsql
user="user" database="osm" password="osm"
I get the error:
SCHWERWIEGEND: Thread for task 1-read-xml failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: The database
schema version of 5 does not match the expected version of 6.
at
org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:67)
at
org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:47)
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.CopyFilesetLoader.run(CopyFilesetLoader.java:78)
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlCopyWriter.complete(PostgreSqlCopyWriter.java:108)
at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:110)
I don't really understand that. Aren't the sql-scripts for creating the
DB compatible to the osmosis-version they're coming with?!
Thanks for any hint,
Benjamin
More information about the dev
mailing list