Migrating the Heroku Postgres database from Dev to the base plan

Question

I followed Heroku's guide on migrating my postgres database from Dev to a basic plan: https://devcenter.heroku.com/articles/migrating-from-a-dev-to-a-basic-database

Everything seems to have gone well, but I'm a little confused by the information below. Despite the fact that the new base database shows some data, it does not display any tables. The size of the data is also different. Before I remove Dev Dev, has anyone else seen the same thing? Can anyone explain what is going on here?

Ryans-MacBook-Pro:dashboard ryanberry$ heroku pg:info -a myapp(replaced with my app name) === HEROKU_POSTGRESQL_BLUE (DATABASE_URL) Plan Basic Status available Connections 4 PG Version 9.1.5 Created 2012-10-29 10:51 UTC Data Size 111.6 MB Tables 0 Fork/Follow Unavailable === HEROKU_POSTGRESQL_CHARCOAL Plan Dev Status available Connections 0 PG Version 9.1.5 Created 2012-10-20 02:26 UTC Data Size 112.4 MB Tables 30 Rows 389702/10000 (Write access revoked) Fork/Follow Unavailable 

Thanks!

Answer 1

pg: information does not display information in real time. See Heroku pg: info gives 0 tables as well as the Heroku Row schedule is incorrect for messages with similar problems.

By now, the information should display the correct number of tables.
To make sure the table structure is correct, you can connect to the database and display all the tables:

 heroku pg:psql HEROKU_POSTGRESQL_BLUE \dt 

Of course, you can also do heroku run console to check your data in rails console. Your application already uses your base plan database (HEROKU_POSTGRESQL_BLUE), so if the application works fine, everything went well.