On Sun, May 2, 2010 at 10:12 PM, _-_ <span dir="ltr"><<a href="mailto:txp_unimatrix23@web.de">txp_unimatrix23@web.de</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">






<div text="#000000" bgcolor="#ffffff">
<p><span style="font-size: 9pt;"><span style="font-family: verdana,geneva;"><span style="background-color: transparent;"><span style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0);"> Hi there,<br>
<br>
</span></span></span></span></span></p>
<p><span style="font-size: 9pt;"><span style="font-family: verdana,geneva;"><span style="background-color: transparent;"><span style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0);">I've got a
problem with importing .osm files into a postgis database.</span></span></span></span></span></p>
<p><span style="font-size: 9pt;"><span style="font-family: verdana,geneva;"><span style="background-color: transparent;"><span style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0);">I think i set
up the database correcly is</span></span></span></span></span>, I used
the pgsql_simple_schema_0.6.sql schema from osmosis.<br>
I also used the 900913.sql file. </p></div></blockquote><div>What is the 900913.sql file for?<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff">
<p><br>
</p>
<p>When i try to import files like this:</p>
<p>osmosis --read-xml file="madagascar.osm" --write-apidb
host="localhost" database="osm5" user="postgres" password="12345"</p>
<p><br>
</p>
<p>I'll get the following output/Error messages:</p>
<p>#################################################</p>
<p>SEVERE: Thread for task 1-read-xml failed<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
create resultset.<br>
    at
org.openstreetmap.osmosis.core.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:429)<br>
    at
org.openstreetmap.osmosis.core.apidb.v0_6.impl.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:82)<br>
    at
org.openstreetmap.osmosis.core.apidb.v0_6.impl.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:55)<br>
    at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.initialize(ApidbWriter.java:288)<br>
    at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1046)<br>
    at
org.openstreetmap.osmosis.core.xml.v0_6.impl.BoundElementProcessor.end(BoundElementProcessor.java:85)<br>
    at
org.openstreetmap.osmosis.core.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:107)<br>
    at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)<br>
    at
org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown

Source)<br>
    at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown

Source)<br>
    at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown

Source)<br>
    at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown

Source)<br>
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)<br>
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)<br>
    at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)<br>
    at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)<br>
    at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown
Source)<br>
    at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)<br>
    at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)<br>
    at
org.openstreetmap.osmosis.core.xml.v0_6.XmlReader.run(XmlReader.java:108)<br>
    at java.lang.Thread.run(Thread.java:636)<br>
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"schema_migrations" does not exist<br>
    at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)<br>
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)<br>
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)<br>
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)<br>
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)<br>
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)<br>
    at
org.openstreetmap.osmosis.core.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:424)<br>
    ... 20 more<br></p></div></blockquote></div><br>You are using the wrong task to write to the database.  It doesn't support that schema.  So don't use these tasks:<br><a href="http://wiki.openstreetmap.org/wiki/Osmosis/DetailedUsage#API_Database_Tasks">http://wiki.openstreetmap.org/wiki/Osmosis/DetailedUsage#API_Database_Tasks</a><br>
<br>Use these tasks instead:<br><a href="http://wiki.openstreetmap.org/wiki/Osmosis/DetailedUsage#PostGIS_Tasks">http://wiki.openstreetmap.org/wiki/Osmosis/DetailedUsage#PostGIS_Tasks</a><br><br>Brett<br><br>