我用这里的命令安装并设置了postgresql-12[https://www.postgresql.org/download/linux/redhat/]
yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install postgresql12
yum install postgresql12-server
/usr/pgsql-12/bin/postgresql-12-setup initdb
systemctl enable postgresql-12
systemctl start postgresql-12
然后我尝试登录数据库
psql postgres postgres
我收到错误
psql: error: could not connect to server: FATAL: Peer authentication failed for user "postgres"
我的系统上有两个pghba.conf文件。我检查了如下所示的身份验证设置,如这里所建议的那样[psql:FATAL:Ident身份验证对用户"postgres"失败
/data/pg_data_dir/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
host all all 0.0.0.0/0 md5
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all trust
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust
/var/lib/pgsql/12/data/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all trust
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust
身份验证设置看起来还可以,所以我不知道该怎么办。
EDIT-使其更加结构化和可用。
首先,你需要了解每一种身份验证方法的含义,这里有很多关于这方面的信息。长话短说,在这个阶段,你可能感兴趣的是md5
,它是一个散列密码,或者trust
,它不是密码。
在您的机器上安装postgres后,您需要成为postgres
用户,然后尝试psql
~# su -l postgres --assume you're postgres
~$ psql --connect
psql (xx.x ))
Type "help" for help.
postgres=#
一旦你进入,你可以为该用户设置一个新密码:
postgres=# password postgres
为了防止这种情况发生,您需要询问postgres hba文件在哪里:
postgres=# SHOW hba_file;
使用您喜爱的文本编辑器并对其进行修改以满足您的需求。
此外,您还需要确保重新加载postgresql服务,命令是:
sudo systemctl reload postgresql-12.service