Hi All, I think this has been asked before, but I have not managed to find the answer, sorry!
I am trying to maintain an up-to date database of the UK for mapnik rendering. I have had it working fine previously using daily diffs, but am trying to get minutely updates going using osmosis using the recipe in Minutely Mapnik <http://wiki.openstreetmap.org/wiki/Minutely_Mapnik>. The thing I changed from that recipe was to add a bounding box to osm2pgsql to (I hope) strip out the changes outside of my area. To get things up to date quickly, I set maxInterval to zero in configuration.txt. It took a while (couple of days) - little virtual machine, but now it has finished my database seems to be huge - 11GB compared to the one (on a different computer) of the UK which is 5GB. 'vacuum' did not make any difference. Is there a trick I am missing to do the bounding box extraction correctly? The simple script I used to do the processing is below. Thanks Graham. #!/bin/sh WORKDIR_OSM=/usr/local/OSM/db_workdir cd $WORKDIR_OSM osmosis --read-replication-interval workingDirectory=$WORKDIR_OSM --simplify-change --write-xml-change changes.osc.gz osm2pgsql --append -d gis -m -s -S ~/default.style --bbox -11,49.5,2,61 changes.osc.gz -- Graham Jones Hartlepool, UK.
_______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev