[Tile-serving] Having trouble getting osm2pgsql to work

[Stephen D]

Just noticed this: 2019-06-25 07:40:57.872 ADT [14178] PANIC: could not 
write to file "pg_xlog/xlogtemp.14178": No space left on device

Which is odd, because the SSD maxed out at 55% full.

On 2019-06-25 8:17 a.m., Stephen D wrote:
> 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?
>
>
> _______________________________________________
> Tile-serving mailing list
> Tile-serving at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/tile-serving