Hi "Show your psql command that is failing."
[root@~ pg]# /usr/local/pgsql/bin/psql -p5432 -d db1 -h127.0.0.1 psql: error: connection to server at "127.0.0.1", port 5432 failed: FATAL: Ident authentication failed for user "root" If the error is Ident authentication failed for user "cce", i think the ident config file taked effect. Reference information: PG version 15.3 Thanks. ________________________________ 发件人: David G. Johnston <[email protected]> 发送时间: 2023年8月26日 14:43 收件人: pan snowave <[email protected]> 抄送: [email protected] <[email protected]> 主题: Re: ident auth does not works as usual On Saturday, August 26, 2023, pan snowave <[email protected]<mailto:[email protected]>> wrote: Well , describe as follows: pg_pba.conf host all root 127.0.0.1/32<http://127.0.0.1/32> ident map=test host all all 127.0.0.1/32<http://127.0.0.1/32> trust pg_indent.conf test root cce and login pg via root user , it doesnt work You are saying root os user can login as pg role cce but that line of the pg_hba.conf doesn’t permit cce to login. In short, the mapping is useless. David J.
