Forums

Crashed my Postgresql by deleting all tables

Hello,

i think i just crashed my Postgresql Database, by deleting all Tables.

When i run my Django Migrations i get the following Error:

django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table (no schema has been selected to create in LINE 1: CREATE TABLE "django_migrations" ("id" serial NOT NULL PRIMA...

What can i do, to fix this?

Thanks in advance.

deleted-user-6619097 | 3 posts | June 28, 2021, 5:24 p.m. | permalink

Your best bet is probably to delete the database entirely and use Django to create a new one. If the database already exists, Django expects that the migration tables will be present.

Staff glenn | 9498 posts | PythonAnywhere staff | June 28, 2021, 6:10 p.m. | permalink

Nice. Worked. Thanks a lot

deleted-user-6619097 | 3 posts | June 28, 2021, 9:02 p.m. | permalink

Glad to hear that you made it work!

Staff fjl | 4352 posts | PythonAnywhere staff | June 29, 2021, 9:23 a.m. | permalink