Do you actually test your database backup restores? (lemmy.world)

submitted 3 months ago by indidev@lemmy.world to c/devops@programming.dev

4 comments fedilink hide all child comments

Honest question. I've got automated daily pg_dump backups going to S3 and I check that the files are there, but I've never actually tried restoring one on a fresh instance to see if it works.

Feel like this is one of those things where you assume it's fine until you desperately need it and find out the dumps were corrupted for 3 months.

Anyone have a setup where restores get tested automatically? Or is that overkill for side projects?

you are viewing a single comment's thread
view the rest of the comments

[-] be_gt@feddit.nu 9 points 3 months ago* (last edited 3 months ago)

An untested backup is no backup at all. At least test once or twice per year.

But I usually do it manually by restoring into a new instance, rather that have it done on a script.

this post was submitted on 09 Jul 2026

8 points (90.0% liked)

DevOps

2237 readers

1 users here now

DevOps integrates and automates the work of software development (Dev) and IT operations (Ops) as a means for improving and shortening the systems development life cycle.

Rules:

Posts must be relevant to DevOps
No NSFW content
No hate speech, bigotry, etc
Try to keep discussions on topic
No spam of tools/companies/advertisements
It’s OK to post your own stuff part of the time, but the primary use of the community should not be promotional content.

Icon base by Lorc under CC BY 3.0 with modifications to add a gradient

founded 3 years ago

MODERATORS

Ategon@programming.dev

RandomDevOpsDude@programming.dev