Hi All, <div><br></div><div>I have a little application that uses XAPI to download city sized lumps of OSM data, which it puts into a posgresql database for rendering. It is becoming increasingly unreliable because of the problems with XAPI servers, so I am wondering what it would take to host my own database of the whole planet and keep it up to date to improve reliability.</div>
<div><br></div><div>My current home server (an old laptop, 2 core intel based with about 2GB ram running Ubuntu 10.10) works nicely doing daily updates for the UK only, but took several days when I tried to upload Europe, so I haven't tried to do the whole world on it.</div>
<div>I wondered what sort of hardware people think is required to import and maintain a database of the whole planet? </div><div><br></div><div>The other thing is that it is using posgresql 8.4, but I think 8.3 is supposed to be faster - is the difference significant enough for it to be worth me changing to 8.3?</div>
<div><br></div><div>I also worry about my carbon footprint, so minimum power consumption is important too (that's why I like my old laptop as a server - <30W for what is a fairly powerful computer.</div><div><br></div>
<div>Any thoughts would be appreciated!</div><div><br></div><div>Regards</div><div><br></div><div><br></div><div>Graham.</div><div><br></div><div><br></div><div><br>-- <br>Graham Jones<div>Hartlepool, UK.</div><br>
</div>