migrating a heroku database

Developer from somewhere

Put app in maintenance:

heroku maintenance:on -a some-app

Create backup

heroku pgbackups:capture --expire -a some-app

Add new db addon, and check color in heroku config, and restore from backup:

heroku pgbackups:restore HEROKU_POSTGRESQL_COLOUR -a some-app

After everything’s been done, promote it to be the main DB:

heroku pg:promote HEROKU_POSTGRESQL_COLOUR -a some-app

Remove maintenance, and restart app:

heroku maintenance:off -a some-app
heroku restart -a some-app