Re: [Dbmail] Restoring emails
A separate table would be superfluous I think. I just have a cron job that runs dbmail-maintenance on a periodic basis, right now it's weekly, but I may change it to daily or hourly as more accounts get placed on the server. If you need to list the deleted messages an appropriate SELECT statement could be conceived of pretty easily. On Wed, 2002-12-04 at 17:11, Richard Barrington wrote: > FWIW, running dbmail-maintenance -d and then -p on my system resulted in > 0 messages being deleted. A check of my tables showed none listed with > other than 0 status... That was with RC4 Postgresql. It looks like the > various flags are being used, rather than the status. > > I think the idea of keeping old messages around is good from a user's > point of view, but bad from an admin/resource point of view - how many > GB of spam will be sitting on machines? I guess I'd like to see a less > "admin-intensive" method of dealing with it... Maybe moving the deleted > messages to a separate table, so that could be backed up or emptied as > required. Any solutions are welcome :-). > > On Thu, 2002-12-05 at 06:39, Roel Rozendaal - IC&S wrote: > > Well, it depends. Messages aren't actually deleted until you run > > dbmail-maintenance - twice. Let's see how it works: > > each message has an extra attribute called 'status'. For the moment, it > > can have the following values: > > > > 0 - new message > > 1 - message has been read > > 2 - message has been deleted (pop) or deleted&expunged (imap) by user > > 3 - message is set for deletion > > > > the change from 2 --> 3 is done by running dbmail-maintenance -d > > the change from 3 to actual deletion is done by running > > dbmail-maintenance -p > >
Re: [Dbmail] Restoring emails
FWIW, running dbmail-maintenance -d and then -p on my system resulted in 0 messages being deleted. A check of my tables showed none listed with other than 0 status... That was with RC4 Postgresql. It looks like the various flags are being used, rather than the status. I think the idea of keeping old messages around is good from a user's point of view, but bad from an admin/resource point of view - how many GB of spam will be sitting on machines? I guess I'd like to see a less "admin-intensive" method of dealing with it... Maybe moving the deleted messages to a separate table, so that could be backed up or emptied as required. Any solutions are welcome :-). On Thu, 2002-12-05 at 06:39, Roel Rozendaal - IC&S wrote: > Well, it depends. Messages aren't actually deleted until you run > dbmail-maintenance - twice. Let's see how it works: > each message has an extra attribute called 'status'. For the moment, it > can have the following values: > > 0 - new message > 1 - message has been read > 2 - message has been deleted (pop) or deleted&expunged (imap) by user > 3 - message is set for deletion > > the change from 2 --> 3 is done by running dbmail-maintenance -d > the change from 3 to actual deletion is done by running > dbmail-maintenance -p > -- Richard Barrington <[EMAIL PROTECTED]>
Re: [Dbmail] Restoring emails
Well, it depends. Messages aren't actually deleted until you run dbmail-maintenance - twice. Let's see how it works: each message has an extra attribute called 'status'. For the moment, it can have the following values: 0 - new message 1 - message has been read 2 - message has been deleted (pop) or deleted&expunged (imap) by user 3 - message is set for deletion the change from 2 --> 3 is done by running dbmail-maintenance -d the change from 3 to actual deletion is done by running dbmail-maintenance -p So if you never run dbmail-maintance -p, all message are left on the server. Restoring them for a user is as simple as an UPDATE query on the messages.status field. (If any of you is interested: could be handy to have dbmail-maintenance leave deleted mesages for a certain amount of time. Shouldn't be that hard to implement, could require a database layout update.) If the message is deleted, you should indeed use a backup. regards roel Richard Barrington heeft op woensdag, 4 dec 2002 om 10:37 (Europe/Amsterdam) het volgende geschreven: I think so. You could check through the message tables, but if "Expunge" is doing it's job, there shouldn't be anything left. I guess the solution is to pull the data from the backup (easy-ish with postgresql), and reinsert the missing messages. Perhaps the best way is to script it. Hi Everyone, Sorry if it seems like I'm posting so much to the list. As I'm starting to go through dbmail I'm trying to find out how easy it is to restore any user's email for any given day? Is this more an SQL backup/restore question? ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Restoring emails
I think so. You could check through the message tables, but if "Expunge" is doing it's job, there shouldn't be anything left. I guess the solution is to pull the data from the backup (easy-ish with postgresql), and reinsert the missing messages. Perhaps the best way is to script it. >Hi Everyone, > Sorry if it seems like I'm posting so much to the list. As I'm starting to go >through dbmail I'm trying to find out how easy it is to restore any user's email >for any given day? > Is this more an SQL backup/restore question?
[Dbmail] Restoring emails
Hi Everyone, Sorry if it seems like I'm posting so much to the list. As I'm starting to go through dbmail I'm trying to find out how easy it is to restore any user's email for any given day? Is this more an SQL backup/restore question? Thanks, Harry -- Harry Hoffman ITSS Systems Team Leader University of Auckland [EMAIL PROTECTED] [EMAIL PROTECTED] STANDARD DISCLAIMER: ** *This universe shipped by weight, not volume.* *Some expansion may have occured in shipping.* * - This mail sent through IMP: http://horde.org/imp/