postgresql - psql : FATAL: Ident authentication failed for user "xxx" with method trust

Question

我通过以下方式(使用 postgres 用户)创建了一个新角色和数据库:

CREATE ROLE xxx LOGIN
  PASSWORD 'CHOOSEAPASSWORD'
  NOSUPERUSER INHERIT NOCREATEDB CREATEROLE REPLICATION;

CREATE DATABASE xxx
  WITH OWNER = xxx
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;

\connect xxx
GRANT ALL ON DATABASE xxx TO xxx;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO xxx;

在 pg_hba.conf 中，我有以下条目:

local   all             postgres                                trust
local   all             all                                     peer
# IPv4 local connections:
host    all             xxx             127.0.0.1/32            trust
host    all             all             127.0.0.1/32            ident

但是我无法连接

psql -U xxx -h localhost -W

得到错误

psql: FATAL:  Ident authentication failed for user "xxx"

我有什么可能出错的想法吗？ (我使用的是 PostgreSQL 9.4 和 CentOS 6.7)

Answer 1

尝试使用 127.0.0.1 而不是 localhost