回复: ident auth does not works as usual

8月28日 14:44 收件人: pan snowave 抄送: Alban Hertroys ; pgsql-general@lists.postgresql.org 主题: Re: ident auth does not works as usual On Mon, Aug 28, 2023 at 7:34 AM pan snowave mailto:win...@live.cn>> wrote: But when i connect to psserver by using os user root /usr/local/pgsql/bin/psql -p

Re: ident auth does not works as usual

On Mon, Aug 28, 2023 at 7:34 AM pan snowave 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

回复: ident auth does not works as usual

38 收件人: pan snowave 抄送: pgsql-general@lists.postgresql.org 主题: Re: ident auth does not works as usual > On 26 Aug 2023, at 11:31, pan snowave wrote: (…) > pg_indent.conf > > test rootcce If that is indeed the name of the file, that would explain your problem. No doubt tha

回复: ident auth does not works as usual

ntication failed for user "cce", i think the ident config file taked effect. Reference information: PG version 15.3 Thanks. 发件人: David G. Johnston 发送时间: 2023年8月26日 14:43 收件人: pan snowave 抄送: pgsql-general@lists.postgresql.org 主题: Re: ident auth does

Re: ident auth does not works as usual

On Sunday, August 27, 2023, pan snowave wrote: > 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"

Re: ident auth does not works as usual

On Saturday, August 26, 2023, pan snowave wrote: > Well , describe as follows: > > pg_pba.conf > hostall root 127.0.0.1/32 ident > map=test > hostall all 127.0.0.1/32trust > > > pg_indent.conf > > test rootcce >

Re: ident auth does not works as usual

> On 26 Aug 2023, at 11:31, pan snowave wrote: (…) > pg_indent.conf > > test rootcce If that is indeed the name of the file, that would explain your problem. No doubt that it should be named pg_ident.conf instead, without the ’n'. Alban Hertroys -- If you can't see the forest for the

ident auth does not works as usual

Well , describe as follows: pg_pba.conf hostall root 127.0.0.1/32 ident map=test hostall all 127.0.0.1/32trust pg_indent.conf test rootcce and login pg via root user , it doesnt work error info is 2