Web Development

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 grow360-eu
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!