Dear Team, Please help me out to resolve this! We have too many deleted-posts and we need to delete that permanently but in bulk! [image]

Excellent, glad to hear that did the job for you. So for the sake of combining the answers, one can use the following in the Rails console to destroy all topics that were deleted more than 90 days ago, repeating as many times as necessary if there are more than 1000 topics: Topic.with_deleted.where(deleted_at: ...90.days.ago).limit(1000).destroy_all After that has completed, the following can be used to destroy all posts that have been orphaned from destroyed topics: Post.find_by_sql("select * from posts where topic_id not in (select id from topics)").each { |p| p.destroy } It’s worth noting that the above commands will not destroy deleted posts however, only deleted topics and their orphaned posts. To also destroy deleted posts older than 90 days, use the following, again repeating as necessary: Post.with_deleted.where(deleted_at: ...90.days.ago).limit(1000).destroy_all P.S. Out of interest, did you try destroy_all without limit(1000) and have problems or did you not try it without the limit?

[תמונה] IAmGav: (currently hidden for some reason) Ah, that might be my stumbling block. I was looking for can_permanently_delete in the admin settings and couldn’t see it.

The site setting is hidden because we do not encourage its use. That was developed for the cases when some sensitive information was posted and it must be scrubbed from the database completely. One more thing, that operation is not a bulk operation anyway. Since it is a hidden site setting, the only way to enable it is from the console.

[תמונה] RGJ: Post.with_deleted.where(‘deleted_at is not null’).update_all(raw: ‘This post has been deleted’, cooked: ‘This post has been deleted’) This is almost exactly what I need! Thank you. How would I do the syntax so that it only covers all posts deleted before xxxx date?

That would be Post.with_deleted.where("deleted_at < 'YYYY-mm-dd'").update_all(...)

Can you let us know how to enable it from the console?

Here’s the instructions: [תמונה] Enable setting to allow admins to permanently delete data Self-Hosting bookmark This is a guide on how to enable the setting for administrators to permanently delete data on a Discourse instance. person_raising_hand Required user level: Admin As of v2026.4.0 Changelog | Discourse Releases the site setting to allow admins to permanently delete data is no longer a hidden site setting. To use this feature, enable the can permanently delete setting. However, please be aware of the risks involved with this feature — as the setting name suggests, if you permanen…

[תמונה] JammyDodger: can_permanently_delete Feature Enabled from console but how i can delete deleted-posts ??? all posts present in deleted-posts

I really am no expert on this, but it seems like there’s enough snippets of information in this topic to create the code you’re looking for. The topic I linked at the start has the warnings from the creators in about this being uncharted territory, and you do it at your own risk. But they also provide the ‘destroy_all’ piece which seems useful, and suggest doing batches to start with. That topic also has a couple of examples on how to target either posts or topics which (combined with the examples @RGJ has given on how to target different specific posts) should get you pretty close. I have no experience with this though, so I’m afraid I can’t give it the greenlight as I’ve never done it. :man_shrugging:

In order to delete the old posts on our forum, I used this. It is the result of combining The proper way to completely delete hundred of topics via rails? and @RGJ’s suggestions. I chose to do this in the end, as I really wanted to remove the data from the database to protect the privacy of users. Rewriting the text to “This post has been deleted” still leaves the edit history intact and relatively easily accessible, so not good enough. As we had 20,000 topics to destroy, it took a while! Topic.with_deleted.where("deleted_at < '2021-08-28'").limit(1000).destroy_all As this left a lot of orphaned posts, I had to follow it up with: Post.where('topic_id not in (select id from topics)').limit(1000).destroy_all

I imagen that your ./launcher cleanup afterwards also free’d up some space :slight_smile:

מחק פוסטים שנמחקו לצמיתות בכמות גדולה?

תמיכה

JammyDodger 21 באוקטובר,‏ 2021,‏ 2:50pm 35

Here’s the instructions:

נושא		תגובות	צפיות
Purge/clean/delete deleted topics from database Product Support	4	511	5 ביולי,‏ 2025
I am getting 502 error while trying to delete topics created by specific user Product Support	18	1378	12 ביוני,‏ 2023
Administrative Bulk Operations Self-Hosting configuring , reference	9	14864	12 ביוני,‏ 2026
Clean up old topics Product Support	4	679	2 בפברואר,‏ 2023
Help Wiping all Posts from a Forum Product Support	18	2459	26 באוגוסט,‏ 2020

מחק פוסטים שנמחקו לצמיתות בכמות גדולה?

נושאים קשורים