Is there a way to add models to postgres without deleting all the tables in postgres?

Question

Django I am trying to add a new table/model from Django models to my existing postgres database with tables already but the only solution is to start from scratch again

Solution: Delete migrations, delete all the tables in the postgres database. python manage.py makemigrations, python manage.py migrate

Error: The table does not exist when browsing the drf api or the postgres database after trying to makemigrations and migrate with the new models.

If you ran migrations, the table would exist. There is no need to delete all the tables. — Daniel Roseman
– Daniel Roseman, Commented Oct 31, 2019 at 15:23

Daniel Finch · Accepted Answer · 2019-10-31 15:15:53Z

0

Adding additional tables (as a result of creating new models) does not require you to start from scratch or delete any existing data. It would be helpful to have examples of the migrations which fail to apply.

answered Oct 31, 2019 at 15:15

Daniel Finch

4448 silver badges25 bronze badges

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

Comments

mon io · Accepted Answer · 2019-11-01 23:08:28Z

0

It looks like your migration files and migrations in the database (djang_migrations table - i hope it is correct table name) are not compatible.

If you are sure that your tables in db and your models are the same (existing migration files mirrors your database tables) and you want SomeModel (for this example) model to be created you can try to:

Clear your django_migrations table - remember to make backup of this table
manage.py migrate --fake (it will only create some rows in django_migrations table)
manage.py makemigrations (it should create migration file for SomeModel model)
manage.py migrate (it will create new table)

Hope it will help :)

answered Nov 1, 2019 at 23:08

mon io

7525 silver badges8 bronze badges

Collectives™ on Stack Overflow

Is there a way to add models to postgres without deleting all the tables in postgres?

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