Re:Dribbble offline due to Postgres problem
by wiredfool on Wednesday May 15, 2013 @01:42AM
(#5710372)
You can't drop a database on postgres if anyone is connected to it, which is likely the case on production.
Re:Dribbble offline due to Postgres problem
by Xylakant on Wednesday May 15, 2013 @02:34AM
(#5710524)
TRUNCATE TABLE users; should work and will have similar disastrous effects.
mysql> drop database production;
No way raid/replication will save you then. Same thing for some rogue delete statement gets in the code that deletes too much data.
Raid isn't a good backup because groups of drives are known to die at once or around the same time.