[Tile-serving] Having trouble getting osm2pgsql to work
Stephen D
junkmail at scd31.com
Tue Jun 25 11:17:41 UTC 2019
I am having trouble getting my import to go smoothly. It was working
fine(although very slow - 112000 seconds just to finish the
planet_osm_point index, which was IO bottlenecked, even though it was
only using about a hundred IOPS on an SSD)
The index generation failed - postgres complained about something being
corrupted. It was either SSD or memory, but I think it was memory. It
scrolled too high up the screen so I can't check. The SSD is brand new
and the memory is ECC so that's very strange to me.
I tried running renderd to see how slow it would be with only some of
the indexes, but it turns out postgres was running in recovery mode so
it wouldn't let renderd make queries.
How can I prevent this from happening again?
More information about the Tile-serving
mailing list