Went to do a test restore of one of my databases and I noticed the dump files over the last few months were all 0kb. Glad I caught it this way and not because I needed to restore. Put it on your calendar, schedule a test restore of your critical stuff a couple times a year. I know y’all are busy but it is worth the time and effort. A backup you can’t actually restore isn’t a backup at all.

  • capital
    2•6 days ago

    I use restic to back up files to Wasabi.

    It’s all scripted but the steps are:

    1. Back up
    2. Prune based on rules
    3. Perform a repository consistency check and do further checks (takes longer) on 1% of the repo
    4. Choose 1 random file from the current backup set and get the hash of the current file
    5. Restore that file to a temporary location and hash it.
    6. Compare hashes
    7. Send push alert to me with success/failure and a summary