search

PuzzleTechHub / myus

A public hassle free puzzlehunt hosting tool
https://www.puzzlehuntmy.us/
MIT License
1 stars 9 forks source link

Database backup policy #27

Open TheOriginalSoni opened 7 months ago

TheOriginalSoni commented 7 months ago

It would be nice to figure out some simple backup policy on Postgres end.

While some clearcut features are not established, SQL backend will be the only way to fix certain problems, like deleting test hunts. Plus, Myus will become a single point of failure to multiple hunts this way.

Would be good to figure out some sort of "Daily/Weekly backups" automatically.

TheOriginalSoni commented 7 months ago

Scheduled "a" backup using Heroku's daily backup system. Yet to test if it works. It will run at 1200 hrs UTC everyday.

heroku pg:backups:schedule DATABASE_URL --at '12:00 Etc/UTC' --app myus-prod

According to the instructions, this means we'll have backup running daily and then retained for 7 days.

TheOriginalSoni commented 7 months ago

Probably will be good to either set up some sort of monthly manual backup system, or a completely separate backup procedure using Supabase. That way we're kinda proofed against hunts vanishing or the data going poof for any more than a day