This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Which way for whole planet update?

0

Hi, I've imported the planet file on my system about 8 months ago and would like to update my database now.

My question: Should I update my database with osmosis & osm2pgsql with --append or rather do a new full import with the latest planet file? Which way is better/faster/less complicated?

The first planet import took about 25 hours (42GB planet-file). Latest planet-file now is 45GB.

Regards

asked 11 Jun '19, 17:52

Maik28's gravatar image

Maik28
11223
accept rate: 0%


One Answer:

2

Trying to update your 8-month-old data is going to take vastly longer than a full re-import. As a rule of thumb, as soon as you're more than 2 weeks out of date, a new import is usually faster. Only reason to try an update would be if you cannot afford the database to be down for 1.5 days - but running an 8-month update will likely make your database veeeery slow for 15 days ;)

answered 12 Jun '19, 12:59

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

Source code available on GitHub .