Last Updated: February 25, 2016
·
1.631K
· johnnyrodgers

Backup and download your DB on Heroku

Yet another well thought-out tool from the folks at Heroku!

Add the pgbackups addon to your account if you don't have it:

$ heroku addons:add pgbackups

You can check if you have it by running:

$ heroku addons

Backup your database:

$ heroku pgbackups:capture
$ heroku pgbackups:capture --expire # to delete oldest backup

Get URL for the backup you just created:

$ heroku pgbackups:url

Full documentation: https://devcenter.heroku.com/articles/pgbackups