To add to an already complete list, I use postgres because of the integrity, transactions, and its level of sql92 compliance.

I use it to store a parsed iptables logile, my mp3 collection, addressbook etc etc.

I back it up each night, and can restore it in a glance if i do something stupid.. I've not had one failure with it, and with the DBI, its just "That Easy (tm)"