Re^3: PM Confessional

[Tux]

Sane way of operating. It will also protect you fro the less obvious mistake of writing

delete from table where key > 0;

instead of

delete from table where key < 0;

which is only one key apart. I know someone else who did that.

This thread is not about errors someone else made, but I will still tell one from the recent past:

After months of preparing and exercising all the needed commands for the move of one production platform to a newer platform of a more modern architecture, someone (not in our company) issued the main "rsync" command (which also had a --delete) THE WRONG WAY AROUND and deleting two days of work. The restore from backup took 6 hours and regained 1½ day of work.