Fix django.db.utils.operationalerror: fe_sendauth: no password supplied
In settings.py
check DATABASES
configuration:
- If your local passwordless Postgres database had access configured via Unix-socket, just remove
HOST
,PORT
,PASSWORD
in database:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'your_db_name',
'USER': 'postgres',
# 'PASSWORD': 'Password for postgres user',
# 'HOST': 'localhost',
# 'PORT': '5432',
}
}
- If your Postgres bound to host and there is no password required for the user, remove
PASSWORD
:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'your_db_name',
'USER': 'postgres',
# 'PASSWORD': 'Password for postgres user',
'HOST': 'localhost',
'PORT': '5432',
}
}
- If you have a user with a password – define it:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'your_db_name',
'USER': 'postgres',
'PASSWORD': 'Password for postgres user',
'HOST': 'localhost',
'PORT': '5432',
}
}
This is it. Please answer in the comments whether it works for you.