我有以下 pg_hba.conf:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# 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
有了上面我假设host all all 127.0.0.1/32 trust
将允许来自本地主机的 TCP 连接。然而,情况似乎并非如此
[root@XenonKiloCranberry:~]# psql -U postgres
psql (11.7)
Type "help" for help.
postgres=# \q
[root@XenonKiloCranberry:~]# psql -U postgres -h 127.0.0.1
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "postgres", SSL off
我哪里错了?
输出select * from pg_hba_file_rules
:
line_number | type | database | user_name | address | netmask | auth_method | options | error
-------------+-------+----------+-----------+---------+-----------------------------------------+-------------+---------+-------
1 | local | {all} | {all} | | | trust | |
2 | host | {all} | {all} | ::1 | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | trust | |
(2 rows)