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.

[Hsu Yao Chang]

Dear Nic Brough, 

We also found some information as listed as the address of https://confluence.atlassian.com/display/DISC/Confluence+Space+Content+cargador 

But we do not know how to run the command of perl SpaceCopy.pl , can you give us some tips or guidance ? thank you.

[Nic Brough -Adaptavist-]

Stuff that's nearly 10 years old really isn't of much use now. 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.

[Hsu Yao Chang]

Dear Sir, Is there any information about API to delete page ? Thank you.