连接数据库报错
FATAL:Ident authentication failed for user ‘root’
用户名验证不通过
could not connect to server:Connection refused(0x0000274D/10061)
主机地址不对
以上的报错都要先纠正一个文件pg_hba.conf,这是一个权限配置文件,找不到可以用grep查找以下我的安装路径是/var/opt/rh/rh-postgresql10/lib/pgsql/data/pg_hba.conf
host all all ::1/128 Ident
host all all 127.0.0.1/32 Ident
host replication all 127.0.0.1/32 Ident
host replication all ::1/128 Ident
找到以下几行将Ident改为trust
host all all ::1/128 trust
host all all 127.0.0.1/32 trust
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust
再次连接就会成功了