回复: ident auth does not works as usual

Hi

"Show your psql command that is failing."

[root(at)~ 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 <david(dot)g(dot)johnston(at)gmail(dot)com>
发送时间: 2023年8月26日 14:43
收件人: pan snowave <windxp(at)live(dot)cn>
抄送: pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
主题: Re: ident auth does not works as usual

On Saturday, August 26, 2023, pan snowave <windxp(at)live(dot)cn<mailto:windxp(at)live(dot)cn>> 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.