<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:12pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><div>I'm using Osmosis to import a recent UK extract of the planet file into a database, and I used the simple schema here: <a rel="nofollow" target="_blank" href="http://svn.openstreetmap.org/applications/utils/osmosis/script/pgsql_simple_schema_0.6.sql">http://svn.openstreetmap.org/applications/utils/osmosis/script/pgsql_simple_schema_0.6.sql</a><br><br>This took around 1 hour.<br><br>I then found that this schema didn't give way geometries so re-ran the query, adding a geometry column 'linestring' so that way objects would be created.<br><br>This import has taken 24 hours so far and
isn't yet finished. Is this normal or has something gone wrong? It would be useful to have some sort of counter to find out how far into the process osmosis is - for example roughly what line of the XML it is on, as a
percentage of the whole file.<br><br>Admittedly I am going against advice and using .bz2 files, but it appears postgresql is causing all the overhead.<br><br>Thanks<br><br>Steve<br></div></div><br>
</div></div></div><br>
</body></html>