Finding a reasonable backup strategy for metricsdb-01
Today with @anarcat we have briefly discussed a change of retention policy for metricsdb-01 postgresql database.
If I am not mistaken the policy changed from 30 days retention to 7 days. I think that is correct but we could even find a policy that is easier to maintain over time.
I think we could assume that whatever we have on metricsdb-01 could be recreated from archives that we store on collector. The only data that escape that rule would be the tags and notes that we intend to attach to relays with tagtor. For those we could setup a timer that would dump the few tables (I think 4 in total) that store that data. The dumps wouldn't be big or slow to create, so that could be a solution.
I am not sure is there anything else we could consider, but I am open to suggestions.