Hi, I think the way described here also helps you to clean up your database from time to time
https://wiki.openstreetmap.org/wiki/User:Stephankn/knowledgebase#Cleanup_of_ways_outside_the_bounding_box Stephan On November 30, 2015 9:29:09 PM GMT+07:00, tb <[email protected]> wrote: >Hi, > >i'm running a local database of the OpenStreetMap data, and this >database is permanently updated by using osmosis and osm2pgsql >(minutely >diffs). > >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). The region i'm >interested in is defined as a polygon in a separate table, and i keep >the content of all the mapnik tables (planet_osm_point, ...line, >...polygon, ...roads) to this region by using a trigger - no problem so > >far. But unfortunately the other tables used by osm2pgsql >(planet_osm_nodes, ...ways, ...rels) getting bigger by time. > >Complete reload of the region every night is something i don't like - >so >far. > >I wonder if someone has a system like this up and running, and how this > >works. > >Is this possible in general by using osm2pgsql? > >Any help or suggestions gratefully accepted! >-tb > > >_______________________________________________ >dev mailing list >[email protected] >https://lists.openstreetmap.org/listinfo/dev
_______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
