Postgres connection error

[Pranav Sawant]

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

[Mike Dewhirst]

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)

--
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...@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.

[Sebastian Jung]

GRANT ALL PRIVILEGES ON DATABASE knapds TO system;

Don't give all rights. This is very strange in PostgreSQL

--

[Pranav Sawant]

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 

[Nana Bright Atsiatorme]

ENGINE': 'django.db.backends.postgresql_psycopg2',

        'NAME': 'knapds',

        'USER': 'system',

        'PASSWORD': 'password',

        'HOST': 'localhost',

        'PORT': 5432,

Install pgadmin and run with the  setup with the credentials above 

Make sure the it running the apply the migrations

The error is from the port number 

[Joyce Mumbi]

Hello i have problem in deploying my back-end work could you kindly help me out Thank you

Sender notified by Mailtrack

10/10/23, 06:45:45 PM

--
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...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEdj-JFtG3Yx4D0TvjTGjMTJJeZ-pquJ9CF5D0EHoMdjgULkhQ%40mail.gmail.com.

[ASAMOAH EMMANUEL]

I often come across this issue, run this code but before you do, log in into the postgres shell with a database with all privileges, let's say postgre user and switch with your new database created and run: GRANT CREATE ON SCHEMA public TO your_user;

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPTUz5ngaXhZzQ9cFNxEFAU4kPKtZpGQ%2Bjkhk2Sh2wiAYp_ukg%40mail.gmail.com.