Database Reference
In-Depth Information
Downloading a backup
Downloading backups is a very common action when you want to migrate data between
applications, upgrade plans, or simply export data.
The simplest way to download a backup is via the web interface at Heroku Postgres in
ht-
tps://postgres.heroku.com
.
In the backup list, there is a link to download each backup, but
it's also very common to download the backup via the Heroku client with the
pg-
backups:url
command:
$ heroku pgbackups:url --app your-app-name
"https://s3.amazonaws.com/hkpgbackups/app25633057@heroku.com/
b004.dump?AWSAccessKeyId=AKIAJNFEZJDWEFCGIL7A&Expires=1406498011&Signature=fICrkAEAQUxClStvBKgMM%2FspYkI%3D"
This command will always provide the appropriate URL to download the most recent
backup. If you want another backup, you can pass the
backup ID
:
$ heroku pgbackups:url b002 --app your-app-name
And finally, to download you can use commands such as
curl
or
wget
with the
pg-
backups:url
command:
$ curl -o latest.dump `heroku pgbackups:url --app
your-app-name`
