Thank you for assistance. I just checked and saw that owner of my database was postgres, and thats why it was not giving create permission to other users so i changed the owner and it worked
On Monday, October 9, 2023 at 4:00:57 AM UTC+5:30 Mike Dewhirst wrote: > There is a step missing somewhere if migrations has incorrect permissions. > > If Django is correctly installed - as it seems to be - then your settings > must be deficient somewhere. The first migration ought to create Django's > own tables etc even if you haven't written any of your own models. > > I would start again and follow the docs exactly. Perhaps follow the > tutorial. > > Also, you can happily keep things super-simple if you plan to throw > everything away and start fresh after learning the ropes. > > Good luck > > Mike > > > > -- > (Unsigned mail from my phone) > > > > -------- Original message -------- > From: Pranav Sawant <[email protected]> > Date: 9/10/23 01:24 (GMT+10:00) > To: Django users <[email protected]> > Subject: Postgres connection error > > *Hey all, I am new to django* > *and i want to connect to postgresql * > > *what I have doing:* > > *At postgres plsql* > CREATE DATABASE knapds; CREATE USER system WITH PASSWORD 'password'; ALTER > ROLE system SET client_encoding TO 'utf8'; ALTER ROLE system SET > default_transaction_isolation TO 'read committed'; ALTER ROLE system SET > timezone TO 'Africa/Johannesburg'; GRANT ALL PRIVILEGES ON DATABASE knapds > TO system; \q > *in settings.py:* > > 'ENGINE': 'django.db.backends.postgresql_psycopg2', > 'NAME': 'knapds', > 'USER': 'system', > 'PASSWORD': 'password', > 'HOST': 'localhost', > 'PORT': '', > > *and I am getting this error:* > > django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create > the django_migrations table (permission denied for schema public > LINE 1: CREATE TABLE "django_migrations" ("id" bigint NOT NULL PRIMA... > > Please help > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/a9eeca40-befa-4a0b-b1fc-db78924e6218n%40googlegroups.com > > <https://groups.google.com/d/msgid/django-users/a9eeca40-befa-4a0b-b1fc-db78924e6218n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/d1183f24-b0a6-4345-8ca5-831e29c02a36n%40googlegroups.com.
