[OSM-dev] Minutely Database Update of Planet Extract

[Graham Jones]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20110125/3713eca0/attachment.html>