Hooray for backups

Splicer at

This is the second time in two days I've had to restore from backup because I'd made an error while upgrading software. Yesterday my attempt to upgrade Node took down the Awkwardly site, and today upgrading from PostgreSQL 9 to PostgreSQL 11 took down my personal cloud.

This was a rookie mistake, too. After upgrading two other PostgreSQL installations (successfully, without incident) I restored third new instance to find my data missing. Turns out I typed pg_dump when I meant to type pg_dumpall.

Everyone makes errors from time to time, but chasing after "what went wrong" is stressful and tiring.

McClane, AJ Jordan, Ben Sturmfels likes this.