sqlite database not migrated to postgresql when pushed to heroku server (django)

Question

I pushed my app to heroku, but it seems that the database did not migrate (the database has 0 tables and 0 entries). How can I migrate it correctly?

i'm not too familiar with heroku, but was your sqlite db underversion control? How did you transfer your dev db to heroku? You could dumpdata locally and loaddata on your heroku — dm03514
– dm03514, Commented Apr 12, 2013 at 14:23
The db was under version control, but this is actually the first version as I was migrating a new app from an old computer. I'm going to try to dumpdata locally and then transfer it to the new database server. — babbaggeii
– babbaggeii, Commented Apr 12, 2013 at 15:00

Community · Accepted Answer · 2017-05-23 12:31:31Z

3

If you're using the Starter-tier databases, there is a delay in populating those stats. You can see if there are tables immediately if you psql in:

$ heroku pg:psql -a app_name
psql=> \dt
[...tables...]

Also, please see my answer here on using postgres locally instead of sqlite3 (recommended):

https://stackoverflow.com/a/15373024/95741

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Apr 12, 2013 at 15:07

catsby

11.4k3 gold badges40 silver badges38 bronze badges

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

2 Comments

babbaggeii Over a year ago

Thanks, I ran that command and it gave "No relations found". I am indeed using the starter-tier database so maybe I'll wait until tomorrow and check it again. In the meantime, I think I'll take that advice and migrate my local database to postresql, then push it again to heroku.

catsby Over a year ago

the \dt command is immediate. If it finds nothing, there's nothing there. Migrate to postgres locally and try again. import/export guide: devcenter.heroku.com/articles/heroku-postgres-import-export

Collectives™ on Stack Overflow

sqlite database not migrated to postgresql when pushed to heroku server (django)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related