[OSM-dev] Osmosis import to postgis - speed

Karl Newman siliconfiend at gmail.com
Sat Dec 6 00:37:10 GMT 2008


On Fri, Dec 5, 2008 at 4:11 PM, S Knox <roxyknox at yahoo.co.uk> wrote:

>
> I'm using Osmosis to import a recent UK extract of the planet file into a
> database, and I used the simple schema here:
> http://svn.openstreetmap.org/applications/utils/osmosis/script/pgsql_simple_schema_0.6.sql
>
> This took around 1 hour.
>
> 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.
>
> 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.
>

Try this:
http://wiki.openstreetmap.org/wiki/Osmosis/DetailedUsage#--log-progress_.28--lp.29Osmosis
works on streams, so it can't know what percentage of the total is
complete.

You can use an external bzip to decompress the file to stdout and then pipe
it to Osmosis. Type a hyphen as the filename for Osmosis to indicate it
should read from stdin.

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20081205/1a3858c7/attachment.html>


More information about the dev mailing list