herokudb

heroku addons:add pgbackups
heroku addons:add heroku-postgresql:basic

heroku pg:wait
heroku pgbackups:capture --expire
heroku pgbackups:restore HEROKU_POSTGRESQL_COLOUR
heroku pg:promote HEROKU_POSTGRESQL_COLOUR
heroku addons:remove HEROKU_POSTGRESQL_COLOUR

------

restoring backups to local

heroku pgbackups:capture
curl -o latest.dump `heroku pgbackups:url`
pg_restore --verbose --clean --no-acl --no-owner -d mydb latest.dump