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

[Andy Townsend]

I guess the first question is what filesystem?

It's not a problem I've seen (on any of ext4 on a vm in vmware or virtualbox, or ext4 on tin).

There's always the "get a UPS" option :)




	  Original Message  



From: junkmail at scd31.com
Sent: 31 July 2019 21:40
To: tile-serving at openstreetmap.org
Subject: [Tile-serving] osm2pgsql DB keeps corrupting on power loss


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!


_______________________________________________
Tile-serving mailing list
Tile-serving at openstreetmap.org
https://lists.openstreetmap.org/listinfo/tile-serving