Skip to content

Instantly share code, notes, and snippets.

@shu0115
Created January 15, 2014 06:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shu0115/8431573 to your computer and use it in GitHub Desktop.
Save shu0115/8431573 to your computer and use it in GitHub Desktop.
heroku pg:info
heroku addons:add heroku-postgresql:standard-yanari
heroku pg:info
----------
=== HEROKU_POSTGRESQL_COPPER_URL (DATABASE_URL)
Plan: Standard Yanari
Status: Available
Data Size: 6.4 MB
Tables: 0
PG Version: 9.3.2
Connections: 3
Fork/Follow: Temporarily Unavailable
Rollback: Temporarily Unavailable
Created: 2014-01-15 05:40 UTC
Maintenance: not required
=== HEROKU_POSTGRESQL_CRIMSON_URL
Plan: Hobby-dev
Status: available
Connections: 2
PG Version: 9.3.2
Created: 2014-01-08 05:26 UTC
Data Size: 6.7 MB
Tables: 5
Rows: 0/10000 (In compliance)
Fork/Follow: Unsupported
Rollback: Unsupported
----------
heroku addons:remove HEROKU_POSTGRESQL_CRIMSON_URL
heroku pg:wait
----------
Waiting for database HEROKU_POSTGRESQL_COPPER_URL... available
----------
heroku maintenance:on
heroku ps:scale worker=0
heroku pgbackups:capture --expire
heroku pgbackups:restore HEROKU_POSTGRESQL_COPPER_URL
heroku pg:promote HEROKU_POSTGRESQL_COPPER_URL
heroku maintenance:off
heroku ps:scale worker=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment