[OSM-dev] Update osm2pgsql patch mode

[Matt Amos]

Martijn van Oosterhout wrote:
> On Fri, Aug 29, 2008 at 5:23 PM, Robert (Jamie) Munro <rjmunro at arjam.net> wrote:
>> Great progress - that's now about 14 times real time.
>>
>> How much disc space does the whole operation require?
> 
> On this system 42.5GB. Transient may be more, not sure.

on this system it took 22.8h for the initial planet import, and it is 
currently consuming 44Gb. from munin graphs it seems that max usage was 
roughly 9Gb more.

when i try to load the next day's osc i get the following error:

Reading in file: /home/osm/planets/20080827-20080828.osc.gz
Processing: Node(50k) Way(0k) Relation(0k)insert_node failed: ERROR: 
duplicate key value violates unique constraint "planet_osm_nodes_pkey"
(7)
Arguments were: 291466881, 6319926.5639616642, -13695169.0319488477, (null),
Error occurred, cleaning up

the node with that ID seems to have been created just after midnight and 
appears in the both the planet dump and daily diff. is there any way 
around this, or should i just import the hourly diffs from 1am instead?

cheers,

matt