[Mailman-Users] working on an insanely huge moderation requestlist

[Mark Sapiro]

Patrick Bogen wrote:

>On 8/30/06, Attila Kinali <attila at kinali.ch> wrote:
>> I've read about discard and that i can just delete everything
>> in the queue. But i'd rather like to go trough the list
>> and be able to aprove some of the held mails. Is there any
>> way i can work on the queue? Another possibility would be
>
>Most of the mails in the queue are probably so old that it doesn't
>even make sense to approve them. That said, you can probably convince
>'find' to remove all of the queue files older than a certain date,
>which should help reduce your queue to a managable level, at which
>point you can handle it through the web interface.


It is best to remove the data/heldmsg-* files with bin/discard as this
will also clean up the request.pck and pending.pck files.

You can use bin/dumpdb to dump the heldmsg-* files. You could probably
script something to make a mbox file or a mail directory. It wouldn't
be difficult to pipe the dumpdb output through sed to make a 'message'.

That said and as Patrick suggests, I would make a list of those
heldmsg-* files older than a week or two (or more if you prefer) and
blindly delete those with bin/discard and handle the rest through the
admindb interface.

-- 
Mark Sapiro <msapiro at value.net>       The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan