How I did (not) recover from a data loss (featuring ZFS, LXD and PostgreSQL)

· feed2toot · 4 · 2 · 8

@angristan peut-être avoir un pool pour les données et un pour LXD? Perso j’ai eu un problème très similaire avec les data de prometheus corrompus sous LXD+btrfs
Utilises-tu LXD via snap? Le mécanisme de mise à jour fait souvent planter mes conteneurs...

To be able to recover a PostgreSQL cluster from disaster, use pgbarman. Easy to setup, no maintenance needed. Just perfect.

@angristan You could find out what rows the corrupted block was and get those rows from the last working dump, since they're non-critical they probably haven't changed.

@angristan Anything showing up in dmesg about hardware (sda3) errors? Seems more likely than a ZFS error.

Sign in to participate in the conversation

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!