回复: ident auth does not works as usual - Mailing list pgsql-general

From pan snowave
Subject 回复: ident auth does not works as usual
Date
Msg-id OS3P286MB1933E0EFD47E8EEA7D1A4A07D3E0A@OS3P286MB1933.JPNP286.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: ident auth does not works as usual  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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 <david.g.johnston@gmail.com>
发送时间: 2023年8月26日 14:43
收件人: pan snowave <windxp@live.cn>
抄送: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
主题: Re: ident auth does not works as usual
 
On Saturday, August 26, 2023, pan snowave <windxp@live.cn> wrote:
Well  , describe as follows:

pg_pba.conf
host    all             root             127.0.0.1/32           ident    map=test
host    all             all             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.

pgsql-general by date:

Previous
From: o1bigtenor
Date:
Subject: Re: pgBackRest for a 50 TB database
Next
From: "David G. Johnston"
Date:
Subject: Re: ident auth does not works as usual