Migrating Heroku Shared DBs

Replace Heroku shared databases with new Heroku Postgres Dev databases!

heroku maintenance:on
heroku addons:add pgbackups
heroku pgbackups:capture <YOUR_DATABASE_URL>
heroku addons:remove shared-database
heroku addons:add heroku-postgresql:dev
heroku pgbackups:restore <DATABASE> <BACKUP_ID>
heroku pg:promote <DATABASE>
heroku maintenance:off

Why?

Shared databases are going away. After making the move you'll enjoy:

• Postgres 9.1.3
• 1 terabyte of storage
• Data Clips
• Fork & Follow
• Direct access via any PostgreSQL client
• Daily, automated database snapshots
• Continuous Protection realtime backups