[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