Post Acj5QF3tp1Fa1UNmJU by nthcdr@emacs.ch
 (DIR) More posts by nthcdr@emacs.ch
 (DIR) Post #AciKtNRz17qQak2RaC by louis@emacs.ch
       2023-12-11T22:43:56Z
       
       0 likes, 0 repeats
       
       Holy shit, I just TRUNCATE'ed a table on a production server with 12 million rows ... PANIC MODE ON
       
 (DIR) Post #AciLPyc8NXo77TKaUS by jameshowell@emacs.ch
       2023-12-11T22:49:51Z
       
       0 likes, 0 repeats
       
       @louis OH GOD PLEASE TELL US IT'S ONLY WORK STUFF AND NOT EMACS.CH😆​
       
 (DIR) Post #AciM4YpFAHFz0ioaES by louis@emacs.ch
       2023-12-11T22:57:08Z
       
       0 likes, 1 repeats
       
       @jameshowell No, only work stuff 🙂  Table recovered, thanks backup, thanks pg_restore.Learning: never, ever, even remotely, have a r/w connection to a production server in your DB IDE... 😜​
       
 (DIR) Post #AciPHd4Yz8uZoGu5bs by sigue@universeodon.com
       2023-12-11T23:33:08Z
       
       0 likes, 0 repeats
       
       @louis heh, I still remember the look on my co-worker's face when he accidentally deleted the /etc directory on a few hundred servers due to no trailing / in an rsync command inside a for loop.Power tools FTW. 😆
       
 (DIR) Post #AciPKEpxY5UHVtJiL2 by sachac@emacs.ch
       2023-12-11T23:33:32Z
       
       0 likes, 0 repeats
       
       @louis @jameshowell Yiiiiiikes. Thank goodness for backups.
       
 (DIR) Post #AciPyPWFFipIE6Fdwm by jameshowell@emacs.ch
       2023-12-11T23:40:56Z
       
       0 likes, 0 repeats
       
       Backups: always alwaysWhat @louis did: never ever
       
 (DIR) Post #Acj5QF3tp1Fa1UNmJU by nthcdr@emacs.ch
       2023-12-12T07:25:20Z
       
       0 likes, 0 repeats
       
       @louis Must have been sweaty! Remeber kids even Batman has his backup!
       
 (DIR) Post #AcnT9cX0U78lQCRbGa by dekkzz76@emacs.ch
       2023-12-13T18:12:14Z
       
       0 likes, 0 repeats
       
       @louis so panic mode off now?how did you manage the cock up in the first place
       
 (DIR) Post #AcnT9dJvYEGvrvKfWC by louis@emacs.ch
       2023-12-14T10:10:05Z
       
       0 likes, 0 repeats
       
       @dekkzz76 Restore did only take a few minutes so that was easy to fix.I was just connected to the wrong database server when I truncate the table and didn't realise.
       
 (DIR) Post #AcoKRmIKDeR2U77Vnk by dekkzz76@emacs.ch
       2023-12-14T17:30:54Z
       
       0 likes, 0 repeats
       
       @louis awww no all nighter?
       
 (DIR) Post #AcoKRn7j8XYH3XAYvA by louis@emacs.ch
       2023-12-14T20:07:12Z
       
       0 likes, 0 repeats
       
       @dekkzz76 No, I have backups and can easily access them. Restoring a table or even the full database is therefore not a very big deal.I spend my nights currently programming stored procedures, so no risk involved there 🙂