Django.db.utils.operationalerror: could not connect to server: connection refused

Question

Problem :

I am not very sure how can I fix the below issue

I have really no idea about why am I facing below error while trying to do the runserver:

Performing system checks...

System check identified no issues (0 silenced).

Unhandled exception in thread started by <function wrapper at 0x1085589b0>

Traceback (most recent call last):

  File "/Library/Python/2.7/site-packages/django/utils/autoreload.py", line 333, in wrapper

    fn(*args, **kwargs)

  File "/Library/Python/2.7/site-packages/django/core/management/commands/runserver.py", line 218, in inner_run

    self.check_migrations()

 

And when I try to connect to my postgres I face below error:

psql: could not connect to server: No such file or directory

        Is the server running locally and accepting

        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Answer 1

It can be some of the below issues:

1. The PostgreSQL is not running. You need to check it with the sudo service postgresql status

2. The PostgresSQl is not running on the port no 5432. You need to check it by typing sudo netstat -nl | grep postgres

3. You have something wrong while trying to connect to the db like your username,your password or your databasename. You need to check that they are what the postgres ask for you to connect it and that is your db_name that you want to access to.