It's a valid point and mail will be warehoused on a certain interval.
But we'd like to keep relatively recently deleted mail online.
Restoration is trivial then, since it's just setting the deleted_at
timestamp col back to null for a particular daterange.
Erik
Marc Dirix wrote:
On Mon, Jan 14, 2008 at 05:50:34AM -0800, Erik Osterman wrote:
Hi,
I'm looking for a way to keep all email ever received whether deleted or
not. As it stands, I don't see that this is possible with dbmail. The
reason is two fold: users frequently delete messages that need to be
restored; we're legally required to maintain a copy of all email. Storing a
copy of all email is not an alternative. There's just too much data
(several TB).
I would never/ever keep deleted mails in the production database
If, as you state, this database turns out to be several TB your
mailsystem will get a severe performance penalty because of database
size. (Even at several GB this is noticable using standard hardware).
Better it is, to export deleted messages per user to an mbox file.
And run dbmail-util, to delete them from the database, afterwards.
Marc
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
