Hello Jesse I think your right about the performance issue. Im now in favor of letting dbmail-adduser like it is.
Jacques Jesse Norell a écrit : > Hello, > > Another issue is performance - likely most account removals are > done via human interaction during business hours. If users have > large mail boxes, it would just slow the database down to go through > and remove all their mail then. It works very well for us to just > remove the users entry and have dbmail-maintenance do all the more > disk intensive work in off-hours. I'd think make it optional for > dbmail-adduser (which we don't use for that, but others do). > > ---- Original Message ---- > From: Paul Stevens <[email protected]> > To: [email protected] > Subject: Re: [Dbmail] dbmail-adduser not cleaning up the tables > Sent: Thu, 19 Jun 2003 21:19:52 +0200 > > > [EMAIL PROTECTED] wrote: > > > The topic has been on air a cuple of days. For most of the work, you use > > > dbmail-adduser d follow by a dbmail-maintenance -f. Only alias is there to > > > clean up, and I have post a little script to do so a couple of days ago. > > > > The earlier thread was also started by Jacques, so I interpreted this > > apparently repeated request as a wish-list type bugreport. > > > > To answer the question: yes dbmail-adduser could well be changed to > > cleanup all data associated with an account, but there was no consensus > > on whether such would be a good design decision. > > > > Like most of the other replies in the earlier thread I feel that this > > can be well resolved either through database contraints or through > > dbmail-maintenance. > > > > I for one can imagine well some situations where I would want to remove > > an account, but still retain at least the messages and messageblks for > > historical purposes. Perhaps you would want to assign such orphaned > > messages to some bucket-type dummy user. Afaik many organisations are > > required to maintain archives of email same as of paper documents for > > several years. > > > > regards, > > > > > > > > > > Alejandro > > > > > > > > >>Could dbmail-adduser be modified to clean up all the > > >>tables (aliases,mailboxes,messages,messageblks) and aliases > > >>"deliver_to" > > >>when deleting a user. > > >>I do it with a script but i think that should be done by dbmail-adduser > > >>for > > >>all of use. > > >> > > >>Why delete a user and leave all is data in the tables. > > >> > > >>Thanks > > >>Jacques > > >> > > >>_______________________________________________ > > >>Dbmail mailing list > > >>[email protected] > > >>https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >> > > > > > > > > > _______________________________________________ > > > Dbmail mailing list > > > [email protected] > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > > -- > > ________________________________________________________________ > > Paul Stevens mailto:[EMAIL PROTECTED] > > NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] > > The Netherlands________________________________http://www.nfg.nl > > > > _______________________________________________ > > Dbmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > -- End Original Message -- > > -- > Jesse Norell > jesse (at) kci.net > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
