I’ve been editing posts on my board, mainly in order to fix weird post formating after importing the old database and also to convert links to oneboxes – it needed a little work, but it’s done now. The problem is that many posts now have 2-5 revisions, which makes the database larger. The posts rev…

Ok, so it would be something like this, right? discourse-# \connect discourse discourse=# delete from post_revisions *; discourse=# update posts set public_version=1 where public_version>1; discourse=# update posts set version=1 where version>1;

[صورة] Morfik: The problem is that many posts now have 2-5 revisions, which makes the database larger. I would not worry about that. An image would be worth 100s (if not 1000s) of post revisions storage-wise.

Hmm, but is there a way to remove them all? I’m just curious :smiley:

If you know SQL, then it’s two queries away delete everything in the post_revisions table update version and public_version on the posts table to 1 :wink:

I think that’s the solution I’ve been looking for. :slight_smile: I’ll test how it works and see whether it’s worth doing.

هل هناك طريقة لإزالة جميع مراجعات المنشورات من جميع المشاركات؟

دعم المنتج

zogstrip 13 سبتمبر 2017، 8:23م 4

If you know SQL, then it’s two queries away

delete everything in the post_revisions table
update version and public_version on the posts table to 1

الموضوع		الردود	مرات العرض
Question about PostRevision.destroy_all Product Support	3	824	6 أكتوبر 2016
How can I remove post history? Feature	13	4716	26 أبريل 2022
How to remove post completely? Product Support	2	9258	25 أكتوبر 2023
How to get a previous version/revision of a post through the API Development rest-api	5	1548	21 فبراير 2021
Is it possible to delete posts from the database? Development	6	1919	28 يناير 2020

هل هناك طريقة لإزالة جميع مراجعات المنشورات من جميع المشاركات؟

الموضوعات ذات الصلة