# Any api to purge old deleted posts / uploads

**URL:** https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495
**Category:** Support
**Created:** [November 6, 2017, 8:59am UTC](https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495 "2017-11-06T08:59:10Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [November 6, 2017, 10:35pm UTC](https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495/3 "2017-11-06T22:35:57Z")

</div>

Not sure how you _bulk deleted_ the old posts/topics but this should fix it

```plaintext
# ssh into server
cd /var/discourse
./launcher enter app
rails db
DELETE FROM post_uploads WHERE post_id IN (SELECT id FROM posts WHERE deleted_at IS NOT NULL)

```

---

_[View the full topic](https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495)._