Skip to main content

Connect POSTgreSQL with Django

 First install all necessary step 


$ sudo apt-get install python-pip python-dev libpq-dev postgresql postgresql-contrib
Second
$ sudo su - postgres
$ psql
Create User name with password 
$ CREATE USER user_name WITH PASSWORD 'password'; 
Create New Database
$ CREATE DATABASE database_name WITH OWNER user_name;
Give permission 
$ GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user_name;
Update settings.py 
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'database_name',
'USER': 'user_name',
'PASSWORD': 'password',
'HOST': 'localhost',
'PORT': '5432',
}
}
 Then,
python3 manage.py migrate
and finally create super user
python3 manage.py createsuperuser 

Comments