On Sunday, August 27, 2023, pan snowave <
windxp@live.cn> wrote:
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.
What about your psql command is supposed to inform the system that you want to login at the db role cce? The ident file doesn’t magically alias one name to another, it’s purpose is to allow some OS user to specify some other name to use to authenticate instead of the OS user they are executing the command with.