News for hackers. Stuff that matters.
Re:Dribbble offline due to Postgres problem by hijinks on Wednesday May 15, 2013 @12:47AM (#5710219)
Replication and Raid isn't a backup because what if i do this in mysql

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.

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.
Re:Dribbble offline due to Postgres problem by wiredfool on Wednesday May 15, 2013 @11:42AM (#5712713)
You can revoke truncate from public.
Re:Dribbble offline due to Postgres problem by Xylakant on Wednesday May 15, 2013 @01:19PM (#5713414)
Oh, sure. I'll just do "DELETE FROM users" and forget about the WHERE clause. Same effect.