GRANT ALL PRIVILEGES ON DATABASE knapds TO system;
Don't give all rights. This is very strange in PostgreSQL
Pranav Sawant <pranavsawant2...@gmail.com> 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 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
> <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 django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAKGT9mzY3BrAhi%3D%3D5TmGEtaE285BZAyjhoEx%3Dcn9AVzS0BgBkg%40mail.gmail.com.
