Heroku Postgresでプランを「Hobby Dev」から「Hobby Basic」にアップグレードしたメモ

前提

以下の続き。実際の作業のメモ。
Heroku Postgresで「PG::InsufficientPrivilege: ERROR: permission denied for relation」エラー - Qiita https://qiita.com/kure/items/ba96d5b31f5e85cfb511

新DB（Hobby Basic）を新規作成→データコピー→旧DB（Hobby Dev）を削除、な流れ

メモ

現状確認

kure@ubuntu ~/ % heroku pg:info                          
=== DATABASE_URL
Plan:                  Hobby-dev
Status:                Available
Connections:           1/20
PG Version:            10.6
Created:               2018-09-27 00:32 UTC
Data Size:             37.8 MB
Tables:                6
Rows:                  20255/10000 (Write access revoked)
Fork/Follow:           Unsupported
Rollback:              Unsupported
Continuous Protection: Off
Add-on:                postgresql-elliptical-xxxxx

新DB作成

結果「HEROKU_POSTGRESQL_COBALT_URL」が出来た。
色の名前が適当に付くらしい。

kure@ubuntu ~/x % heroku addons:create heroku-postgresql:hobby-basic
Creating heroku-postgresql:hobby-basic on ⬢ x... $9/month
Database has been created and is available
 ! This database is empty. If upgrading, you can transfer
 ! data from another database with pg:copy
Created postgresql-shaped-26200 as HEROKU_POSTGRESQL_COBALT_URL
Use heroku addons:docs heroku-postgresql to view documentation
kure@ubuntu ~/ % heroku pg:info                                    
=== DATABASE_URL
Plan:                  Hobby-dev
Status:                Available
Connections:           1/20
PG Version:            10.6
Created:               2018-09-27 00:32 UTC
Data Size:             37.8 MB
Tables:                6
Rows:                  20251/10000 (Write access revoked)
Fork/Follow:           Unsupported
Rollback:              Unsupported
Continuous Protection: Off
Add-on:                postgresql-elliptical-

=== HEROKU_POSTGRESQL_COBALT_URL
Plan:                  Hobby-basic
Status:                Available
Connections:           0/20
PG Version:            10.6
Created:               2018-12-23 14:39 UTC
Data Size:             7.7 MB
Tables:                0
Rows:                  0/10000000 (In compliance) - refreshing
Fork/Follow:           Unsupported
Rollback:              Unsupported
Continuous Protection: Off
Add-on:                postgresql-shaped-

データコピー

数秒で完了。

kure@ubuntu ~/ % heroku maintenance:on
Enabling maintenance mode for ⬢ xxxx... done
kure@ubuntu ~/ % heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_COBALT_URL
 ▸    WARNING: Destructive action
 ▸    This command will remove all data from COBALT
 ▸    Data from DATABASE will then be transferred to COBALT
 ▸    To proceed, type xxxxx or re-run this command with --confirm
 ▸    xxxx

> 
Starting copy of DATABASE to COBALT... done
Copying... done

利用するDBを変更

kure@ubuntu ~/ % heroku pg:promote HEROKU_POSTGRESQL_COBALT_URL
Ensuring an alternate alias for existing DATABASE_URL... HEROKU_POSTGRESQL_JADE_URL
Promoting postgresql-shaped-26200 to DATABASE_URL on ⬢ ... done
kure@ubuntu ~/ % heroku pg:info                                          
=== DATABASE_URL, HEROKU_POSTGRESQL_COBALT_URL
Plan:                  Hobby-basic
Status:                Available
Connections:           0/20
PG Version:            10.6
Created:               2018-12-23 14:39 UTC
Data Size:             34.5 MB
Tables:                6
Rows:                  20303/10000000 (In compliance)
Fork/Follow:           Unsupported
Rollback:              Unsupported
Continuous Protection: Off
Add-on:                postgresql-shaped-

=== HEROKU_POSTGRESQL_JADE_URL
Plan:                  Hobby-dev
Status:                Available
Connections:           1/20
PG Version:            10.6
Created:               2018-09-27 00:32 UTC
Data Size:             37.8 MB
Tables:                6
Rows:                  20247/10000 (Write access revoked)
Fork/Follow:           Unsupported
Rollback:              Unsupported
Continuous Protection: Off
Add-on:                postgresql-elliptical-

旧DBを削除

kure@ubuntu ~/x % heroku maintenance:off
Disabling maintenance mode for ⬢ ... done
kure@ubuntu ~/x % heroku addons:destroy HEROKU_POSTGRESQL_JADE_URL
 ▸    WARNING: Destructive Action
 ▸    This command will affect the app 
 ▸    To proceed, type x or re-run this command with --confirm
 ▸    x

> x
Destroying postgresql-elliptical-x on ⬢ ... done
kure@ubuntu ~/x % heroku pg:info                                  
=== DATABASE_URL, HEROKU_POSTGRESQL_COBALT_URL
Plan:                  Hobby-basic
Status:                Available
Connections:           0/20
PG Version:            10.6
Created:               2018-12-23 14:39 UTC
Data Size:             34.6 MB
Tables:                6
Rows:                  20303/10000000 (In compliance)
Fork/Follow:           Unsupported
Rollback:              Unsupported
Continuous Protection: Off
Add-on:                postgresql-shaped-x

参考