User avatar
pathetic piss kitten @kitten@elizabeth.cat
1y
tech question what would you think is a proper retention policy for database backups?

like, will I ever want to restore a backup older than a week?
❤️1
4
0
1
1
User avatar
LimeAi neocat_flag_trans @limeai@tech.lgbt
1y
re: tech question @kitten
Well its a redundant system, so how much redundancy you need/want?
Consider, for example: 7 daily backups, 4 weekly backups, and 12 monthly backups, all rotating.

This gives you roughly a year's worth of backups for the cost of 21 total backups. Very unlikely you'll ever need the oldest backup, but at least you have something there instead of nothing.

I think the (relatively speaking) older stuff will become more important as it grows in size, so perhaps you won't care about a two month old backup now, but might in two year's time.
1
0
1
0
User avatar
LimeAi neocat_flag_trans @limeai@tech.lgbt
1y
re: tech question @kitten
I appreciate this doesn't answer your question, so uhhh.... sorry neocat_angel_pleading
1
0
0
0
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1y
re: tech question @limeai it's okay, it's helpful anyway!
0
0
2
0
User avatar
theking killed the radio star @theking@mskey.nekomimi.party
1y
tech question @kitten uhh, wait, database in what context?
2
0
0
0
User avatar
theking killed the radio star @theking@mskey.nekomimi.party
1y
tech question @kitten for like, personal instance, a week is good imo, but maybe a month old backup is good too rarely
0
0
0
0
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1y
tech question @theking PostgreSQL (?) for this instance and for a nextcloud server
❤️1
1
0
1
1
User avatar
theking killed the radio star @theking@mskey.nekomimi.party
1y
tech question @kitten nextcloud is a nas type thing right? Might want to go longer for that in case you delete a file you need later?
1
0
0
0
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1y
tech question @theking sorry, for nextcloud I meant its database. the actual files in it are backed up separately
❤️1
1
0
1
1
User avatar
theking killed the radio star @theking@mskey.nekomimi.party
1y
tech question @kitten oh, idk what the DB for that would have, but I would think it should match the file backups?
:neocat_think:1
0
0
0
1
User avatar
Fiona @airtower@woem.men
1y
tech question @kitten I assume that depends a lot on what kind of data is in the DB, how long would it take to notice damage/corruption/errors? Also if you primarily want to guard against failing disks etc., or also an offline backup to recover from security incidents. neocat_think
:neocat_think:1
0
0
0
1
User avatar
Leah Neukirchen @leah@blahaj.social
1y
tech question @kitten probably not completely, but sometimes you unknowingly corrupt data and wish you had an old version of some table.
1
0
0
0
User avatar
pathetic piss kitten @kitten@elizabeth.cat
1y
tech question @leah ​:neocat_think:​
0
0
0
0