Using PostgreSQL database with Django

In default, Django uses SQLite database & Django automatically creates a SQLite database for our project. But today, I like to use the PostgreSQL database in my application & the required steps are given below.

Connect to Postgres Database Server

sudo -u postgres psql

Creating Database

CREATE DATABASE mydb;

Creating User

CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';

Modifying Connection Parameters for Django

ALTER ROLE myuser SET client_encoding TO 'utf8';
ALTER ROLE myuser SET default_transaction_isolation TO 'read committed';
ALTER ROLE myuser SET timezone TO 'UTC';

Granting Permission To The User

GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;

Exit the SQL prompt

\q

Update Django configuration

Open the settings.py file of our project and scroll to the database section. It looks like below one.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

Update these settings with our PostgreSQL database details.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'mydb',
        'USER': 'myuser',
        'PASSWORD': 'mypass',
        'HOST': 'localhost',
        'PORT': '',
    }
}

Verify the database connection

In the directory where manage.py script exists, run the below command.

python manage.py migrate

If there are no errors, database migration will happen. Else errors will be displayed.

Recent Posts

1. Automating Code Linting with GitHub Actions for WordPress Plugins
2. Comprehensive Guide to Linting PHP, JavaScript, and CSS in WordPress Plugins Using Composer
3. The Ultimate Guide to Indexing in Database Design
4. Understanding 'update_meta_cache' in WordPress - When to Use It, When Not to, and Its Impact on Database Queries
5. A Guide to Configuring JavaScript and SCSS Paths in WordPress Plugins with @wordpress/scripts

This article was published on October 8, 2022

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.