space data maintain

Hsu Yao Chang

Dear all, 

Would it be possible use command or sql to delete postgresql data and attachment of space data by week or day ? For example, if we want to delete space data of last week (included attachment, comment, like ...), can we use sql command to delete postgresql data and attachment folder ? Thank you.

Nic Brough -Adaptavist-

In theory, yes, if you have Confluence completely shut down and you do a full reindex after restarting.

In practice, don't.  Unless you have a very good understanding of exactly which tables you need to remove items from, you are going to break it.

I'd strongly recommend using the API to delete - find/write an addon, or use one of the scripting options to do it over REST.