[question] how to access or restore from the backup?

kbaum / heroku-database-backups

Heroku database backups and copies to S3

MIT License

99 stars 82 forks source link

[question] how to access or restore from the backup? #35

Closed MyraGul closed 3 months ago

MyraGul commented 4 months ago

Hi!

I have a few questions:

For every time we run this script, a new file will be stored in S3, right? It wont overwrite the old one?
Once the file is saved in S3. How do we access its content? For example, what if I want to use a backup and restore it into another heroku app? Any idea on this? because wont the file be encrypted in the S3 bucket?

Thank you.

MyraGul commented 4 months ago

@kbaum any idea on the above^

kbaum commented 4 months ago

Hi @MyraGul. It's been a while and I'm not using Heroku on a daily basis but you can expose a temporary obfuscated url in s3. I Unfortunately I think you would need to then access that file through the url and decrypt and decompress. Then you can expose it again through another temp obfuscated url and point heroku restore at this file. I can't remember the exact steps but you only need a publicly available pg dump to restore on Heroku.