Django Heroku and postgresql

Question

I am new to publishing django apps on heroku. I have read their tutorials and figured I would start simple by modifying their template django project.

So far everything was good.

Then I made an app as one does, made a model and ran

python3 manage.py makemigrations my_app
python3 manage.py migrate

and things seemed ok.

I then pushed to heroku and there were no immediate complaints.

However, now when I try to make save a new model I get the error:

ProgrammingError at /my_app/
relation "my_app_myappmodel" does not exist
LINE 1: INSERT INTO "my_app_myappmodel" ("field1", "field2", "field3") VALUES...

odd...

So I run this locally and everything works fine.

I have tried cleaning my migrations, faking my migrations, squashing my migrations, etc (as other S.O. posts suggest)

Nothing works.

What is up and how do I fix it?

how much migrations did you have, may be you can add code here? — user8060120
– user8060120, Commented Sep 13, 2017 at 13:54
@AamirAdnan how is that different than running migrate locally and pushing the git repo — SumNeuron
– SumNeuron, Commented Sep 13, 2017 at 13:59

Daniel Roseman · Accepted Answer · 2017-09-13 14:01:15Z

4

You need to actually run the migrations on Heroku once you have pushed the code generated by makemigrations. You do this via heroku run manage.py migrate.

answered Sep 13, 2017 at 14:01

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

Comments

tushortz · Accepted Answer · 2017-09-13 14:11:50Z

2

run the following command from your terminal

heroku run python manage.py migrate

or you can also do:

in your local settings.py, change your DATABASES variable to use the heroku one then run from the terminal

python manage.py makemigrations
python manage.py migrate

but you should not normally locally make changes to the heroku production database (as in option 2) except if you are really desperate or don't care

edited Sep 13, 2017 at 14:11

answered Sep 13, 2017 at 14:02

tushortz

5,5453 gold badges22 silver badges33 bronze badges

Collectives™ on Stack Overflow

Django Heroku and postgresql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related