Skip to content

Instantly share code, notes, and snippets.

@mchung
Created January 17, 2012 08:41
Show Gist options
  • Save mchung/1625690 to your computer and use it in GitHub Desktop.
Save mchung/1625690 to your computer and use it in GitHub Desktop.
Migrating data from Postgres 8.3 to Postgres 9.1 on Heroku
project $ heroku db:pull
Loaded Taps v0.3.23
Auto-detected local database: postgres://postgres@127.0.0.1/pg91-dev?encoding=utf8
Warning: Data in the database 'postgres://postgres@127.0.0.1/pg91-dev?encoding=utf8' will be overwritten and will not be recoverable.
[snip]
project $ heroku pg:promote HEROKU_SHARED_POSTGRESQL_PURPLE
project $ heroku db:push
Loaded Taps v0.3.23
Auto-detected local database: postgres://postgres@127.0.0.1/pg91-dev?encoding=utf8
Warning: Data in the app 'heroku-pg91' will be overwritten and will not be recoverable.
[snip]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment