Database backup policy

[TheOriginalSoni]

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]

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]

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