cannot connect Django to postgres

Question

I am trying to connect my django app to postgres but it gives the following error.

connection to server at "127.0.0.1", port 5432 failed: FATAL:  database "testDB" does not exist

the postgres server is running I have checked it also restarted the server still I get the same error

my database settings.

  DATABASES = {
      'default': {
          'ENGINE': 'django.db.backends.postgresql',
          'NAME': 'testDB',
          'USER': 'postgres',
          'PASSWORD': 'xxxxx',
          'HOST': '127.0.0.1',
          'PORT': '5432',
      }
  }

I tried to check if the server is running and it is running, also restarted the server but still the same error.

The error message seems pretty clear. Did you attempt to create a database with that name? — jjanes
– jjanes, Commented Nov 4, 2022 at 14:39

Anton · Accepted Answer · 2022-11-04 15:36:48Z

1

database "testDB" does not exist

If you want to connect to database "testDB", it should exist. But it isn't.

Try to create db with name "testDB" by command like, like this,

create database 'testDB';

or in pgadmin.

answered Nov 4, 2022 at 15:36

Anton

1301 gold badge1 silver badge7 bronze badges

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

1 Comment

Tejas P Over a year ago

I thought it would be automatically created. (Beginners doubt)

Ayman · Accepted Answer · 2022-11-04 13:51:40Z

0

did your Postgres DB hosted in the correct IP? , Check the info there is a mistake surely

answered Nov 4, 2022 at 13:51

Ayman

3632 silver badges9 bronze badges

1 Comment

Tejas P Over a year ago

yes the IP is correct

Collectives™ on Stack Overflow

cannot connect Django to postgres

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related