Does anyone actually test their database restores on a schedule?
Every backup thread ends with "an untested backup is not a backup," everyone upvotes, and then (in my experience) nobody has an automated restore test anywhere.
Genuinely curious about the state of practice:
- Do you restore-test on a schedule, or only when something breaks / an audit demands it?
- If you automated it, what did you build? (ephemeral instance? scripts like pgbackrest_auto? CI job?)
- If you didn't, what stopped you? (time? nowhere safe to restore to? nobody asked?)
- For those with SOC 2/ISO: did the audit change anything, or did you just produce a doc that says you test quarterly?
Trying to understand if this gap is real or if I just keep landing in teams that are bad at it.