In our case, the destruction of the metadata is what will keep the bosses happy. They are "anti-discovery". We have a very short retention period primarily to protect users from themselves in a way that does not require admins to waste time with recovery from backup media.
Can I just do the following in sql? delete from rcpt where piler_id in (select piler_id from metadata where deleted = 1); delete from attachment where piler_id in (select piler_id from metadata where deleted = 1); delete from metadata where deleted = 1; Jeff On Wed, May 28, 2014 at 2:08 PM, Janos SUTO <[email protected]> wrote: > > Hello Jeff, > > > On 2014-05-28 20:20, Jeff Larsen wrote: >> >> I am reviewing the retention process that we have in place and the >> pilerpurge utility is getting the job done as expected. However, I >> notice in the documentation that the metadata record in the database >> simply has a column that marks the message as deleted. The metadata >> record remains. >> >> What If I don't want to retain the metadata? Is there a utility or sql >> script for cleaning up metadata for purged messages? Looking at the >> mysql database schema, I see three likely candidates for tables that >> would need purging: metadata, rcpt, and attachment. > > > you are right, these 3 tables hold message specific data, and it's up > to you what to do with deleted emails. However the metadata table keeps > track of the history of messages, so it's a good idea to keep these records, > even if the message itself is deleted. This audit trail of each emails > regarding your organisation may prove useful. > > Janos >
