...
More details on this process: https://devcenter.heroku.com/articles/heroku-postgres-import-export#import
3.
...
Preservation (logical) backups to s3
We supplement the above with a rake task, rake scihist:copy_database_to_s3
, which will regularly on a one-off Heroku dyno, via the scheduler. This uploads a logical (plain vanilla SQL) database to s3, where it can wait to be harvested and put onto tape.
This workflow serves more for preservation goals more than for disaster recovery: logical .sql
files offer portability (they’re UTF8), and are useful in a variety of situations, unlike the physical backups.
...