[OSM-talk] Using osm2pgsql to keep up with dailies?

Martijn van Oosterhout kleptog at gmail.com
Sun Aug 3 11:53:49 BST 2008


On Sun, Aug 3, 2008 at 2:24 AM, Michal Migurski <mike at stamen.com> wrote:
> I just did my first successful import of planet.osm using osm2pgsql.
> Excellent.
>
> Now I have a bunch of daily and hourly diffs I'd like to use to keep
> the DB up to date, but osm2pgsql doesn't seem to understand the
> <delete/> and <modify/> elements.

Which version is this?

> What to do? Periodic downloads of planet aren't going to work for what
> I'd like to use it for. I'm using the Debian Lenny package, not sure
> exactly of the version.

Well, we need to know the version because it's a fairly recent
feature. You did use --slim and -a, right?

Note that tests so far have shown that its not very fast at applying
diffs. There's probably a lot of room for improvement but I wrote the
code and havn't been able to load up the whole DB myself, so I'm
completely unsure about where the speed is going. If you can try it on
a minute diff first that would be nice, then at least we have an idea
how much time it will take...

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/




More information about the talk mailing list