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?
Built my first environment a couple of hours ago for a mission critical project. In this case, and a bit of overkill, we have hourly backups, and the process then spins up a VM, sets up pgsql, uploads the fresh backup, reports it as ok and then stores it, if it fails, requests a fresh backup, or calls the admin to report a problem.