How to properly connect PostgreSQL with Django? [duplicate]

Question

I'm working on a Django project and using PostgreSQL as my database. I updated my settings.py as follows:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'mydatabase',
        'USER': 'myuser',
        'PASSWORD': 'mypassword',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

However, when I run python manage.py migrate, I get the following error:

django.db.utils.OperationalError: could not connect to server: Connection refused

I have PostgreSQL installed and running. I also verified that my credentials are correct. What could be the issue?

Installed psycopg2 pip) to your dev environment, and ensure you freeze it to your requirements.txt file — Blaisemart
– Blaisemart, Commented Mar 30 at 8:15

Blaisemart · Accepted Answer · 2025-03-30 08:39:05Z

0

Have you installed psycopg2, **pip install psycopg2 ==2.9.9** to your dev environment, and ensure you freeze it to your requirements.txt file? You can try using 127.0.0.1 as your HOST instead of localhost, and ensure that you disable firewalls. Ensure you have created your database via using psql command and grant all privileges. Then you can go ahead and run your python manage.py migrate.

If the error persist which i doubt if you had set everything correctly, then run on your postgres bash (terminal) to diagnose further.

bash 

psql -U <myuser> -d <mydatabase> -h localhost -p 5432

edited Mar 30 at 8:39

answered Mar 30 at 8:22

Blaisemart

4744 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

snakecharmerb Mar 30 at 8:34

ConnectionRefused implies that Django has tried to connect to the Postgres server, so it sounds like psycopg2 is already installed

Collectives™ on Stack Overflow

How to properly connect PostgreSQL with Django? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related