The table above shows add-ons and the attachments to the current app (tech-essentials) or other apps.
daichisaito@DaichinoMacBook-Pro:~/Developing/RubyPractice/tech-essentials (master)
$ heroku pg:info
=== DATABASE_URL
Plan: Hobby-dev
Status: Available
Connections: 0/20
PG Version: 12.4
Created: 2020-04-25 02:16 UTC
Data Size: 14.1 MB
Tables: 32
Rows: 10447/10000 (Above limits, access disruption imminent)
Fork/Follow: Unsupported
Rollback: Unsupported
Continuous Protection: Off
Add-on: postgresql-amorphous-25823
=== HEROKU_POSTGRESQL_ROSE_URL
Plan: Hobby-basic
Status: Available
Connections: 0/20
PG Version: 12.4
Created: 2020-10-03 08:00 UTC
Data Size: 7.9 MB
Tables: 0
Rows: 0/10000000 (In compliance) - refreshing
Fork/Follow: Unsupported
Rollback: Unsupported
Continuous Protection: Off
Add-on: postgresql-objective-52067
daichisaito@DaichinoMacBook-Pro:~/Developing/RubyPractice/tech-essentials (master)
$ heroku pg:copy postgres://vlefdagacngega:edef864700b3823e7e524f4ae7c918904d76c42c68589c7facef71eff8fd1cbb@ec2-54-175-117-212.compute-1.amazonaws.com:5432/d92c1ep4086tg0 HEROKU_POSTGRESQL_ROSE
▸ WARNING: Destructive action
▸ This command will remove all data from ROSE
▸ Data from database d92c1ep4086tg0 on ec2-54-175-117-212.compute-1.amazonaws.com:5432 will then be transferred to ROSE
▸ To proceed, type tech-essentials or re-run this command with --confirm tech-essentials
> tech-essentials
Starting copy of database d92c1ep4086tg0 on ec2-54-175-117-212.compute-1.amazonaws.com:5432 to ROSE... done
Copying... done
$ heroku pg:promote HEROKU_POSTGRESQL_ROSE
Ensuring an alternate alias for existing DATABASE_URL... HEROKU_POSTGRESQL_TEAL_URL
Promoting postgresql-objective-52067 to DATABASE_URL on ⬢ tech-essentials... done
daichisaito@DaichinoMacBook-Pro:~/Developing/RubyPractice/tech-essentials (master)