GRANT ALL PRIVILEGES ON DATABASE knapds TO system;
Don't give all rights. This is very strange in PostgreSQL Pranav Sawant <[email protected]> schrieb am So., 8. Okt. 2023, 16:24: > *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/CAKGT9mzY3BrAhi%3D%3D5TmGEtaE285BZAyjhoEx%3Dcn9AVzS0BgBkg%40mail.gmail.com.
