Hello Janos. greate idea to set retention timestamp. Only 1 question - am I correctly understand and we speaking about [piler].[metadata] table? I have to select(and delete) all messages *to* special person, wich comes *from* special domain.
Thanks in advance, Max 2015-07-24 15:22 GMT+03:00 Janos SUTO <[email protected]>: > > Hello Max, > > On 2015-07-24 13:40, Максим Дуков wrote: > >> Hello to everybody. >> Sure, i remember that main goal of archive - to save all emails. But >> i have strong request from my boss to delete some emails. I know >> criterias for select necessary emails - but what's next? Find and >> delete eml files from piler folder? What should i do with mysql db and >> > > that's definitely an option, though you must be very careful not to remove > still referenced files. > > sphinx? Or just drop records in mysql will be enought? >> > > The purge feature is to the rescue. You may set the retained column to the > past > (don't set it to 0, better to pick a timestamp from yesterday), then run > pilerpurge, > and it will remove *all* aged messages. Again: all aged messages. > > If you prefer to use the gui, then grab the latest master branch, and set > the following in config-site.php: > > $config['ENABLE_DELETE'] = 1; > > Then when the next time you login, the gui will warn you that it's no > longer > compliant (since you delete based ad hoc demands, instead following an > established > corporate policy), however it enables auditors to mark messages to be > deleted*. > > *: actually the gui doesn't delete anything, it merely sets the retained > column for the selected messages, and the next purge job will do the dirty > work. > > Janos > >
