Database cleanup

I have inherited an anchore installation that has been in place for a year, and the DB directory has grown to roughly 90GB in size. There is no archival storage defined and no option for archiving older scanning artifacts to object storage. Is there a guide available for manually deleting old artifacts from the db to clear storage.

Greetings!

We support configuring an object store and also provide a migration path, see the following:

We have options for configuring image archival as well (once you have configured an object store for analysis archive):

With or without an object store we have the ability to define an image lifecycle to expire data after certain criteria:

Make sure you have enable_data_egress set to true per the following:

If you can tell me what version you are on and what versions you were on previously (deployment_history table) I can provide some additional cleanup options.

Lastly, we, Anchore Support, are here for you so do not hesitate to reach out to us via anchore.zendesk.com!