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

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

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