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 luckMike--(Unsigned mail from my phone)
-------- Original message --------From: Pranav Sawant 
<pranavsawant2...@gmail.com> Date: 9/10/23  01:24  (GMT+10:00) To: Django users 
<django-users@googlegroups.com> Subject: Postgres connection error Hey all, I 
am new to djangoand i want to connect to postgresql what I have doing:At 
postgres plsqlCREATE 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 publicLINE 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 django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/a9eeca40-befa-4a0b-b1fc-db78924e6218n%40googlegroups.com.

-- 
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 django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/65232d78.050a0220.d36b2.8891SMTPIN_ADDED_MISSING%40gmr-mx.google.com.

Reply via email to