Purge/clean/delete deleted topics from database

[Isambard]

Continuing the discussion from Introducing permanently delete post functionality:

I have a forum where there was a big cleanup. But when reviewing the database backup, it is still polluted with the old soft-deleted data.

Is there some kind of rake command that can be run to purge deleted items from the database?

[trusktr (Joseph Orbegoso Pea (Joe Pea))]

Please Discourse team, make this easier.

The reason I’m active right now is because I am cleaning up my site from thousands upong thousands of topics and posts created by Google auth’ed.

I don’t want the content to be soft-deleted, I want to bulk-permanently delete all the thousands of topics and posts.

I also don’t want to write code or CLI commands.

[Neil_Evans]

I have been looking into this too - as I batch-imported a load of topics, but the formatting was wrong - so I want to batch-delete them and try again.

I can soft-delete in bulk from the UI, but they are still in the database. Surely soft-deleted items get deleted eventually, otherwise the database will grow forever??

[JammyDodger]

@Neil_Evans

Surely soft-deleted items get deleted eventually, otherwise the database will grow forever??

Unfortunately there isn’t currently any automatic cleanup of soft-deleted posts, and no manual bulk option in the UI either. The rails console is still the way to approach this if you need to do it.

There are a few topics with some info in about how others have approached it. I think this one may be a good example to get both topics and posts (though will need a tweak to tailor it for your own use case) How to delete thousands of Personal Messages? - #7 by RGJ. And remember to take a backup before trying anything destructive in the rails console as accidents can happen.

I think this is the relevant Feature request with the most recent activity if you’d like to add your vote and voice to it:

Permanent bulk delete of old topics

Our forum is near by reaching first year of usage. Some of our category / topic is used for daily work, We have lot of topics which is irrelevant in perspective of holding for long time. Is there any feature or plan to implement some kind of deleting or archiving old topics. Is there way to BULK delete topics using some kind of SQL queries. Cloud I do something like in XX category delete all topics (post) older then date 1.1.2015. Why I’ll love to delete posts is because I do not want to …

[Neil_Evans]

Thanks for the feedback - much appreciated!

FYI - I find it amazing that a platform with so many great features doesn’t have any real data retention control. This could represent a regulatory compliance risk for some companies. At a bare minimum, you should at least be able to specify a retention period (in years) for soft-deleted items- as this would help with compliance and capacity management.

I will raise a feature request as suggested