Re: Postgres connection error

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

On Tue, Oct 10, 2023 at 3:47 PM Joyce Mumbi 
wrote:

> Hello i have problem in deploying my back-end work could you kindly help
> me out Thank you
>
>
>
> [image: Mailtrack]
> 
>  Sender
> notified by
> Mailtrack
> 
>  10/10/23,
> 06:45:45 PM
>
> On Mon, 9 Oct 2023 at 17:15, Nana Bright Atsiatorme <
> nanabrightatsiato...@gmail.com> wrote:
>
>> 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
>>
>>
>>
>>
>> --
>> 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/CAEdj-JFtG3Yx4D0TvjTGjMTJJeZ-pquJ9CF5D0EHoMdjgULkhQ%40mail.gmail.com
>> 
>> .
>>
> --
> 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/CAPTUz5ngaXhZzQ9cFNxEFAU4kPKtZpGQ%2Bjkhk2Sh2wiAYp_ukg%40mail.gmail.com
> 
> .
>

-- 
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/CABFHQYxF8oa9wOZvsXGqCdeL_WKip%2B9dHCRaw458Vh7K9d6j%3Dw%40mail.gmail.com.

Re: Postgres connection error

[Joyce Mumbi]

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



[image: Mailtrack]

Sender
notified by
Mailtrack

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

On Mon, 9 Oct 2023 at 17:15, Nana Bright Atsiatorme <
nanabrightatsiato...@gmail.com> wrote:

> 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
>
>
>
>
> --
> 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/CAEdj-JFtG3Yx4D0TvjTGjMTJJeZ-pquJ9CF5D0EHoMdjgULkhQ%40mail.gmail.com
> 
> .
>

-- 
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/CAPTUz5ngaXhZzQ9cFNxEFAU4kPKtZpGQ%2Bjkhk2Sh2wiAYp_ukg%40mail.gmail.com.

Re: Postgres connection error

[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

-- 
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/CAEdj-JFtG3Yx4D0TvjTGjMTJJeZ-pquJ9CF5D0EHoMdjgULkhQ%40mail.gmail.com.

Re: Postgres connection error

[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 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)
>
>
>
>  Original message 
> From: Pranav Sawant  
> Date: 9/10/23 01:24 (GMT+10:00) 
> To: Django users  
> Subject: Postgres connection error 
>
> *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...@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
>  
> 
> .
>

-- 
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/d1183f24-b0a6-4345-8ca5-831e29c02a36n%40googlegroups.com.

Re: Postgres connection error

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

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

RE: Postgres connection error

[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 luckMike--(Unsigned mail from my phone)
 Original message From: Pranav Sawant 
 Date: 9/10/23  01:24  (GMT+10:00) To: Django users 
 Subject: Postgres connection error Hey all, I 
am new to djangoand i want to connect to postgresql what I have doing:At 
postgres plsqlCREATE 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 publicLINE 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.

-- 
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/65232d78.050a0220.d36b2.8891SMTPIN_ADDED_MISSING%40gmr-mx.google.com.