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/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/