# מוחק לחלוטין גרסאות קודמות של פוסט או הודעה

**URL:** https://meta.discourse.org/t/completely-deleting-previous-versions-of-a-post-or-message/205948
**Category:** Support
**Created:** [13 באוקטובר,‏ 2021,‏ 12:44pm UTC](https://meta.discourse.org/t/completely-deleting-previous-versions-of-a-post-or-message/205948 "2021-10-13T12:44:20Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![Ivan\_Rapekas](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ivan_rapekas/32/248924_2.png) [@Ivan\_Rapekas](https://meta.discourse.org/u/Ivan_Rapekas)
#### Post date: [21 בפברואר,‏ 2023,‏ 6:48am UTC](https://meta.discourse.org/t/completely-deleting-previous-versions-of-a-post-or-message/205948/4 "2023-02-21T06:48:40Z")

</div>

Hi, it seems that feature merged is not the similar that title contains. With [data explorer](https://meta.discourse.org/t/32566?silent=true) I found that some version of certain wiki topic had a big attachment which I’d like to destroy.

Just want to say _how to delete an attachment from version the post_ on self-hosted instances. Unfortunately method from [Search attachments by storage name](https://meta.discourse.org/t/search-attachments-by-storage-name/209945) cannot be applied in this case (unable to get sha1 from filename).

First find sha1 using SQL:

```plaintext
sudo /var/discourse/launcher enter app
su - discourse
psql
SELECT filesize, original_filename, sha1 FROM uploads WHERE filesize > 3000000 order BY filesize desc;

```

then you get sha1. Next, close the connection to db, exit from user to root and open rails command line:

```plaintext
ctrl+d
ctrl+d
rails c
pry(main)> Upload.find_by(sha1: '<sha1>')

```

Finally you get url of the attachment pointing to the filesystem location. The question of the topic is still opened.

---

_[View the full topic](https://meta.discourse.org/t/completely-deleting-previous-versions-of-a-post-or-message/205948)._