Hi I just wanted to clarify something regarding Topic/Post persistence as I found a fair bit of posts indicating that topic/posts are soft-deleted in the database Ref1 Ref2. Firstly let me state the requirement - For compliance reasons, at any point of time we need a backup of all posts within the last 180 Days. (This is for a financial discussion forum, hence the requirement) My idea about discourse’s basic post structure so far is that - A Topic is the first post or content to initiate a discussion, and all subsequent replies to this topic or posts in this topic are considered as posts. My understanding was that all content of the topics and posts tables in the database contain the original data with a flag indicating whether they are visible to public users or not, but as I experimented with this, I found that posts were being replaced with the content “(post deleted by author)” . So I suppose my questions are along the following - What is the current default policy for persisting post/topic data following a user/mode delete/edit Is there an admin switch to change this Could I get a reference to the tables that facilitate this other than posts/topics if any? We have a read-only database user that we plan to interface with external scripts for performing this data-crunching. Is data persisted in the context of users editing their posts? [Wishful Thinking] : Is there an automatic data backup mechanism that exports the data in human readable format? Thank you once again, I appreciate your time :slight_smile:

Can’t speak to all of this, but: There is a setting to “disallow deleting posts older than x.” The default is/was to allow users to delete their post for 1 year. You may wish to adjust this to prevent deletions at all. You may also wish to look at the “Ninja edit Window.” This allows a member to edit their post within a few minutes of the original post time without having the changes show up in the edit history. This is primarily so you can fix typos and such. For your use case, you may want to make sure every edit is visible in the post’s history.

Clarification on Topic/Post Persistence

Product Support

tmb-ltsdw (Gaurav Tamba) August 9, 2021, 4:49am 3

These are interesting workarounds and I will consider them, thank you!

Topic		Replies	Views
Deleted replies and topics - are they purged from db or do they stay forever in db? Product Support	1	580	September 28, 2023
Why is it not possible to permanently delete topics or posts? Product Support	4	1889	October 11, 2024
Permanent bulk delete of old topics Feature	8	1936	July 5, 2025
If I want to completely delete a post, I should just hide them? Product Support	12	5569	May 11, 2021
How to delete post permanently? Product Support	1	324	August 6, 2024

Clarification on Topic/Post Persistence

Related topics