YOUR BACKUPS ARE GREEN. THAT DOES NOT MEAN YOU CAN RESTORE

Summary from the TLDR Data newsletter

Successful PostgreSQL backups can still fail to restore because of missing transaction logs, copied corruption, or lost encryption keys.