Re: Postgres connection error

2023-10-08 Thread 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 On Monday, October 9, 2023 at 4:00:57 AM UTC+5:30 Mike Dewhirst wrote: > There is a step missing somew

Re: Postgres connection error

2023-10-08 Thread Sebastian Jung
GRANT ALL PRIVILEGES ON DATABASE knapds TO system; Don't give all rights. This is very strange in PostgreSQL Pranav Sawant 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 DAT

RE: Postgres connection error

2023-10-08 Thread 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

Postgres connection error

2023-10-08 Thread 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 commit