1

I am trying to update my database from Dev to Basic on heroku. I followed all the steps mentioned here but after heroku pg:promote HEROKU_POSTGRESQL_WHATEVER I wanted to check if my database had everything, so I just went and looked on the website and for the basic version it says

![Data Size 0 B
Tables  0
PG Version ?][1]

The basic

Basic Plan

While it should be

Dev Plan

I am not sure what went wrong.

5
  • Website aside, does the database function properly when you access it from your application? Commented Mar 3, 2013 at 19:36
  • @AndrewGorcester I havent taken it out of the maintenance mode yet. do you want me to do that and try maybe saving some data to the database? Commented Mar 3, 2013 at 19:37
  • also, now it shows the right tables (Tables:56) in both but the data size is still 0 B in the Basic plan one Commented Mar 3, 2013 at 19:44
  • It's your call, but I think it's more likely that the web panel isn't working than the database isn't working. And if the database is working and is up to the capacity of your new plan, then there's not really any problem. Presumably the web panel will update with the new info eventually. Commented Mar 3, 2013 at 19:50
  • @AndrewGorcester yes I took it off maintenance, it seems to work just fine but I am still reluctant to delete my dev plan database yet Commented Mar 3, 2013 at 19:58

1 Answer 1

4

The table and database size is computed via an asynchronous process. This can sometimes take a little while to show. If you've recently migrated then you should try connecting with heroku pg:psql then running:

VACUUM ANALYZE;

This will ensure Postgres has proper stastics then reports the tables correctly for when Heroku asks about the table size. Additionally you could manually explore your database once connected to ensure your data is there:

\dt                    --- to display tables
SELECT * FROM foo;     --- to ensure data is there on a specific table
Sign up to request clarification or add additional context in comments.

1 Comment

That makes so much sense. :) but since it was my first time migrating, so I didnt want to take any chances

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.