[Tile-serving] osm2pgsql DB keeps corrupting on power loss

Stephen D junkmail at scd31.com
Wed Jul 31 20:39:48 UTC 2019


Hi,

I've been running a tileserver for about a month. It's running on 
Postgres, and it's the full planet database. I've had 2 power failures, 
and after both of them the database entered a very weird state. The hard 
drive shows as suddenly having a bunch of free space, and some of the 
tables drop from dozens/hundreds of GB to just a few KB/MB. I have fsync 
on so I'm not sure why this is happening. Any ideas?

Thanks!




More information about the Tile-serving mailing list