Backup databases are one of the most important things you can do for your applications. It allows you to restore your database in case of problems in updating your database or simply due to some hacking.
Back up a Heroku database
$ heroku pg:backups:capture
Starting backup of postgresql-diagonal-12345... done
Use Ctrl-C at any time to stop monitoring progress; the backup will continue running.
Use heroku pg:backups:info to check progress.
Stop a running backup with heroku pg:backups:cancel.
Backing up EMBER to b001... done
Download a Heroku database dump
heroku pg:backups:download
Getting backup from your-app... done, #1
Downloading latest.dump.. 100% 00:00 6.84MB
Backup database of a particular app
$ heroku pg:backups capture --app your-app
Starting backup of postgresql-diagonal-12345... done
Use Ctrl-C at any time to stop monitoring progress; the backup will continue running.
Use heroku pg:backups:info to check progress.
Stop a running backup with heroku pg:backups:cancel.
Backing up EMBER to b001... done
To get the link of your dump
This will return the a url for your to download
heroku pg:backups public-url b001 -a your-app
https://feratu.s3.amazonaws.com/76784543jkjskdjfsdjdkljklgjsdlfjgsdfgsdf/gsdfgjsdjgksdfgsd/gsdjfgklsdjgfslkfgjsdg/gsjdfgkjsdlfgjsdfgjsdfgjkAmz=fjaklsfjalksfjklj
Done!