回复: ident auth does not works as usual

HI I've got the right meanng of pg_hba.conf and pg_ident.conf. My previous understanding was incorrect. I thought pgserver would automatically handle the conversion between OS users and PostgreSQL roles. Thanks all. 发件人: David G. Johnston 发送时间: 2023年8月28日 14

回复: ident auth does not works as usual

Hi, Sorry, the name of ident file that i used is wrong, it is pg_ident.conf (the same as you says） And, I found pg_ident.conf works, because i can found ident entry in pg views , line_number | map_name | sys_name | pg_username | error -+--+--+-+-

回复: ident auth does not works as usual

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"