How to use PostgreSQL Database in Django?

Last Updated : 21 Feb, 2023

This article revolves around how can you change your default Django SQLite-server to PostgreSQL. PostgreSQL and SQLite are the most widely used RDBMS relational database management systems. They are both open-source and free. There are some major differences that you should be consider when you are choosing a database for your applications.

Also checkout – Difference between SQLite and PostgreSQL

Setting up PostgreSQL in Django

First create a virtual env so to do that first install virtualenv using this command

pip install virtualenv

then we will create a virtualenv named gfg using

virtualenv gfg

to enter in the virtual environment create use

now we will install Django here so I am using Django 2.2

pip install django==2.2.*

To get Python working with Postgres, you will need to install the “psycopg2” module.

pip install psycopg2

now lets create a django project named geeks

django-admin startproject geeks

to check your django is running smoothly

python manage.py runserver

Now, go to the below link and download and set up PostgreSQL. create a database name gfg in your Postgres server. Now its time to switch from SQLite to PostgreSQL.

Folder structure –

open the settings.py file

now change database settings with this template code

DATABASES = {    'default': {        'ENGINE': 'django.db.backends.postgresql',        'NAME': ‘<database_name>’,        'USER': '<database_username>',        'PASSWORD': '<password>',        'HOST': '<database_hostname_or_ip>',        'PORT': '<database_port>',    } }

Run these commands

python manage.py makemigrations python manage.py migrate

now lets create the default superuser:

 python manage.py createsuperuser

now again run your server with

python manage.py runserver

go to this route and add the credential you did while creating superuser

http://127.0.0.1:8000/admin/

and if you are successfully able to log in, you have successfully switched to PostgreSQL

How to Dump and Restore PostgreSQL Database?

jagritacharya2019

Improve

Article Tags :

Practice Tags :

python

Django is a Python-based web framework that allows you to quickly create efficient web applications. It is also called batteries included framework because Django provides built-in features for everything including Django Admin Interface, default database â€“ SQLlite3, etc. Installation Let's first un

2 min read

How to Run Django's Test Using In-Memory Database

By default, Django creates a test database in the file system, but it's possible to run tests using an in-memory database, which can make our tests faster because it avoids disk I/O operations. In this article, weâ€™ll explore how to run Django tests with an in-memory database, the advantages of this

6 min read

How to Create and Use Signals in Django ?

In this article, we'll dive into the powerful world of Django signals, exploring how to create and use them effectively to streamline communication and event handling in your web applications. Signals in DjangoSignals are used to perform any action on modification of a model instance. The signals ar

6 min read

How to Dump and Restore PostgreSQL Database?

PostgreSQL remains among the most efficient and widely applied open-source relational database management systems. It provides the superior function of saving, configuring, and extracting information most effectively. In the process of migrating data, creating backups, or transferring databases betw

6 min read

PostgreSQL - Restore Database

Restoring a PostgreSQL database is an essential process for data recovery, especially when dealing with data loss, corruption, or unintentional errors. The ability to efficiently restore a database ensures that an organization can maintain data integrity, availability, and consistency. In this artic

5 min read

Python | Database management in PostgreSQL

PostgreSQL is an open source object-relational database management system. It is well known for its reliability, robustness, and performance. PostgreSQL has a variety of libraries of API (Application programmable interface) that are available for a variety of popular programming languages such as Py

6 min read

How to use User model in Django?

The Djangoâ€™s built-in authentication system is great. For the most part we can use it out-of-the-box, saving a lot of development and testing effort. It fits most of the use cases and is very safe. But sometimes we need to do some fine adjustment so to fit our Web application. Commonly we want to st

3 min read

How to Add Cart in a Web Page using Django?

Adding a shopping cart to a web page using Django is a crucial step when building an e-commerce website or any other application that involves online transactions. A shopping cart allows users to collect and manage items they want to purchase before proceeding to checkout. In this tutorial, we'll wa

6 min read

PostgreSQL - Loading a Database

In this article we will look into the process of loading a PostgreSQL database into the PostgreSQL database server. Before moving forward we just need to make sure of two things: PostgreSQL database server is installed on your system. A sample database. For the purpose of this article, we will be us

3 min read

Save a image file on a Postgres database - Python

In this article, we are going to see how to save image files on a postgresql database using Python.Â Psycopg2 is a driver, that is used, for interacting, with Postgres data, using the Python scripting language. It is, used to perform, CRUD operations on Postgres data.Â Data handled in applications c

4 min read

How to use PostgreSQL Database in Django?

Setting up PostgreSQL in Django

Similar Reads