Re: [AMaViS-user] VERP addressing and maddr in SQL

Alan,

> I've been running with SQl enabled for a few weeks now.
>
> Looking at the maddr table it has thousands of VERP addressed mail records.
>
> I've searched for information on maintaining this table but have yet to
> find it.
>
> Is it intended that Admins delete these records manually or should some
> other process maintain this table?

These records are not deleted automatically, they should be removed
by some periodic maintenance script, e.g. by SQL clauses at the end
of docs file README.sql.

Specifically, the clause:

DELETE FROM maddr
WHERE NOT EXISTS (SELECT sid FROM msgs WHERE sid=id)
AND NOT EXISTS (SELECT rid FROM msgrcpt WHERE rid=id);

removes all unused records from table maddr.

Mark


-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/