Peter Körner schrieb:
Tim Alder schrieb:
Please have also my wish-list in mind for the time of re-import: shop, lit, cycleway, operator, surveillance, website, wikipedia
I just started the new import. I used this style definition: http://cassini.toolserver.org/~mazder/wikimedia.extended.style
The import was canceled after 6 hours when it started to generate the indexes. I'm doing an import with a new prefix (--prefix planet_osm_new) and afterwards rename the current tables to planet_osm_old and the new ones to planet_osm.
ALTER TABLE planet_osm_line RENAME TO planet_osm_old_line; ALTER TABLE planet_osm_new_line RENAME TO planet_osm_line;
Unfortunately in Postgresql this does not rename the primary keys or the indices, so i had to do this manually:
ALTER TABLE planet_osm_line_pkey RENAME TO planet_osm_old_line_pkey; ALTER TABLE planet_osm_new_line_pkey RENAME TO planet_osm_line_pkey; ALTER TABLE planet_osm_line_index RENAME TO planet_osm_old_line_index; ALTER TABLE planet_osm_new_line_index RENAME TO planet_osm_line_index;
I missed some. Now I added all the renames to the planet-update script (/sql/planet.osm/planet-update) and it's running again.
With the increased Cache level I expect it to be much faster than before, but we'll see.
Peter