Django OperationalError - Can't connect to database?

Question

PostgreSQL

Hello! Can you tell me why when setting up a postgresql database on a production server, after specifying the correct data in DATABASES (settings.py), when trying to migrate, an error about incorrect data still pops up?

Password authentication failed for user TEST

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'myproject',
        'USER': 'myprojectuser',
        'PASSWORD': 'password',
        'HOST': '127.0.0.1',
        'PORT': ''5432,
    }
}

Answer 1

The answer turned out to be banal - you need to write the database name and username in the configuration in lowercase. Kick)

Answer 2

Password authentication failed for user TEST

explicitly indicates that the TEST user with such a password and by such a host cannot connect to the database, check this data and the settings of postgres itself