Following a great idea from their friends at GitLab, Soup.io loses all postings since 2015 because of malfunctioning backups. They write:
We had a big database crash, and the backups we had were corrupted.
The only working backup was from 2015.
Also, TIL soup.io still exists. Meanwhile, Gitlab posted a blameless postmortem. You can read it online, and they write:
Improving Recovery Procedures
9. Automated testing of recovering PostgreSQL database backups (#1102)
Does your database backup successfully restore? Are you sure? Are you testing this?
Remember these words of wisdom:
Nobody wants backup.
Everybody wants restore.
— Martin Seeger