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: Alban Hertroys <haramrae@gmail.com>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2023-08-28T14:44:09Z
Lists: pgsql-general 
On Mon, Aug 28, 2023 at 7:34 AM pan snowave <windxp@live.cn> 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.