Horton
Menu

Re: ident auth does not works as usual

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: pan snowave <windxp@live.cn>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2023-08-26T14:43:39Z
Lists: pgsql-general 
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.