I logged into this site this morning and went to delete all the spam (as usual). However, I then noticed that all the legitimate comments had vanished. Argh!
It seems there is a nasty Drupal bug which leads to all comments being deleted if two people try and delete the same comments at the same time. Hopefully there will be a fix soon.
On the good side of things, I now have a better backup/restore procedure for PostgreSQL.
Comments
ouch!
Did you have a backup before?!
Regards,
Rob...
Yeah.. but..
The backup I had before was just a daily rsync of the PG data files - I thought I was dumping the DB as well, but it turned out that I wasn't (I was confusing this box with another).
It was a bit of pain restoring PostgreSQL from the data files, as it's a bit picky (you have to have the right binary version to match the data files). Eventually, I took the easy route and copied the binaries off the server, and used a backup from a day ago... and all was well.
David.
Post new comment