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 <[email protected]> 发送时间: 2023年8月28日 14:44 收件人: pan snowave <[email protected]> 抄送: Alban Hertroys <[email protected]>; [email protected] <[email protected]> 主题: Re: ident auth does not works as usual On Mon, Aug 28, 2023 at 7:34 AM pan snowave <[email protected]<mailto:[email protected]>> wrote: But when i connect to psserver by using os user root /usr/local/pgsql/bin/psql -p5432 -d db1 -h127.0.0.1 If you want to login as the cce role add " -U cce " to your command line (or one of the various other ways you can specify a db role name via the cli or libpq) psql -U cce -h 127.0.0.1 -d db1 Keep in mind you could very well have two lines in your pg_ident.conf file: test root cce test root ddf David J.
