How To Use PostgreSQL with Django on Ubuntu

Step 1 — Installing the Components and using them

sudo apt update
sudo apt install python3-pip python3-dev libpq-dev postgresql postgresql-contrib

sudo -u postgres psql

CREATE DATABASE database_name;

CREATE USER user_name WITH PASSWORD '12345678';

ALTER ROLE user_name SET client_encoding TO 'utf8';

ALTER ROLE user_name SET timezone TO 'UTC';

GRANT ALL PRIVILEGES ON DATABASE database_name TO user_name;

\q

Step 2— Change Django settings

pip install django psycopg2

In Django settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'database_name',
        'USER': 'user_name',
        'PASSWORD': '12345678',
        'HOST': 'localhost',
        'PORT': '',
    }
}

Make migrations

python manage.py makemigrations
python manage.py migrate

You will see successful migrations

Thanks