Updating Heroku Postgres from dev to basic

Question

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.

Website aside, does the database function properly when you access it from your application? — Andrew Gorcester
– Andrew Gorcester, 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? — Jonathan
– Jonathan, 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 — Jonathan
– Jonathan, 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. — Andrew Gorcester
– Andrew Gorcester, 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 — Jonathan
– Jonathan, Commented Mar 3, 2013 at 19:58

CraigKerstiens · Accepted Answer · 2013-03-04 19:58:59Z

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

answered Mar 4, 2013 at 19:58

CraigKerstiens

5,9891 gold badge27 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jonathan Over a year ago

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

Collectives™ on Stack Overflow

Updating Heroku Postgres from dev to basic

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related