PostgreSQL：致命：用户“ douglas”的密码验证失败。

问题描述：

我正在尝试将数据库从sqlite迁移到postgresql ...所以我键入了以下内容：

I am trying to migrate a DB from sqlite to postgresql...so I typed:

sudo -u postgres psql
postgres=# ALTER USER postgres WITH PASSWORD 'newpassword';

，输出返回 ALTER ROLE

，但是当我键入 python manage.py migration 时，我总是收到相同的错误：

but when I type python manage.py migrate I receive always the same error:

django.db.utils.OperationalError：致命：用户 douglas的密码身份验证
失败

django.db.utils.OperationalError: FATAL: password authentication failed for user "douglas"

这是我的settings.py的数据库部分。

This is the database sections of my settings.py.

# Old, using mysqlite
"""
DATABASES = {
    #'default': {
    #    'ENGINE': 'django.db.backends.sqlite3',
    #    'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    #}
    'default': dj_database_url.config(default='postgres://localhost:5432/postgres_db_name'),
}
"""

# New, using postgres
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'douglas_db',
        'USER': 'douglas',
        'PASSWORD': 'vamointer',
        'HOST': '127.0.0.1',
        'PORT': '5432',
    }
}

注意：当我运行 使用密码更改用户postgres 时，我输入了settings.py中定义的相同密码。

Note: When I run the 'ALTER USER postgres WITH PASSWORD' I put in the same password defined in the settings.py.

答

您正在运行的SQL与您尝试使用的用户不匹配。

The SQL you are running does not match the user you are attempting to use.

您如果不存在，将需要创建用户：

You will need to create the user if it does not exist:

CREATE USER douglas WITH PASSWORD 'vamointer';

或者，如果确实存在，则更改该用户的密码。

or if it does exist, change that user's password instead.

ALTER USER douglas WITH PASSWORD 'vamointer';

完成后，您应该会获得更多的运气。您可能还需要将权限分配给该用户。

Once you have done that you should have more luck. You may need to assign permissions to that user as well.

PostgreSQL：致命：用户“ douglas”的密码验证失败。

相关推荐