Hi, On 11/30/2015 03:29 PM, tb wrote: > Now i'm interested in keeping just a region like a city or a small state > updated the same way (on a much smaller system).
... > But unfortunately the other tables used by osm2pgsql > (planet_osm_nodes, ...ways, ...rels) getting bigger by time. Option 1: Use bounding box option with osm2pgsql import, and run the cleanup queries documented here: http://wiki.openstreetmap.org/wiki/User:Stephankn/knowledgebase#Cleanup_of_ways_outside_the_bounding_box Option 2: Instead of applying diffs to the database directly, do this: * download worldwide diffs * apply them to an extract (file containing only your regional data) with osmosis * have osmosis cut out your polygon of interest from the resulting updated file (since applying diffs will have added stuff outside your region) * have osmosis compare a diff between your previous local extract and the new, updated local extract * update your database with that diff The three osmosis steps can be done in one if you're adventurous. Bye Frederik -- Frederik Ramm ## eMail [email protected] ## N49°00'09" E008°23'33" _______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
