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
