[rt-users] Cleaning Attachments

Kevin Falcone falcone at bestpractical.com
Fri Sep 16 10:48:10 EDT 2011


On Fri, Sep 16, 2011 at 05:12:48PM +0300, Michael Stepanov wrote:
>    Our RT3 system has Attachments table with size about 300GB. We'd like to clean it by removing
>    old records with files. The rt-shreder can do this job properly I guess. But there is no way
>    to specify query criteria there. Even direct delete query is failed.

rt-shredder allows query criteria.

-kevin

>    Does somebody can suggest how to clean Attachments table?
> 
>    BTW, IMHO it's bad idea to store files in the database cause it isn't scalable solution and
>    it's very difficult to upgrade/backup/restore DB.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110916/f3e8da46/attachment.sig>


More information about the rt-users mailing list