Why early-in-career?
I accidentally rm -rf'd the @euskalencounter postgresql DB once, by exiting one ssh level too many from a testing VM out into the prod host.
Thankfully there were hourly backups (which I'd set up), so I took the chance to upgrade postgresql :-)https://twitter.com/delroth_/status/1256041866354712577 …
Hah. We actually do GDPR deletes ourselves. I think we've gotten... two so far. That said, we don't have log backups, so if we screw one of those up the DB can be rolled back (until the backups expire) but the log entries are tombstoned for good.
-
-
aha. i guess that's a key difference – i don't do database backups. if something happens and i don't address it within 24 hours i guess i'm quite boned. but that hasn't happened in 10 years. usually when shit hits the fan it is noticed pretty quickly!
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
emoji into the zsh prompt of prod hosts.
The only data lost was a user that had registered themselves in the time between the backup and the accident. We have structured logs which include everything but the password, so I manually re-created them.