...
Heroku retains daily backups for 7 days, and weekly backups for 4 weeks.
Options
Rake task: Replace the Ansible-managed scriptpostgres-backup.sh
with a rake task run regularly on a one-off Heroku dyno. This would obtain the latest database URL and then push it up to s3, where it can wait to be harvested by the Dubnium script.
Pro: minimal change from our existing workflow; easy to check on by ensuring the date on the appropriate S3 bucket.
Con: requires a part of our code to have S3 credentials that allows it to write to our backup directory; requires the Heroku CLI to be accessible to the rake task (so it can obtain the URL of the latest dump).