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.

  • @[email protected]English
    0•6 days ago

    Thanks for explaining this! Very helpful and easy to understand. Do you have preferred programs for the two actions? I currently just rsync my servers.

    • 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