| From: | pan snowave <windxp(at)LIVE(dot)CN> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | ident auth does not works as usual |
| Date: | 2023-08-26 09:31:42 |
| Message-ID: | OS3P286MB1933B415C59DC5C600DC0983D3E2A@OS3P286MB1933.JPNP286.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
error info is
2023-08-26 16:56:29.484 CST [18349] LOG: no match in usermap "test" for user "root" authenticated as "root"
2023-08-26 16:56:29.484 CST [18349] FATAL: Ident authentication failed for user "root"
2023-08-26 16:56:29.484 CST [18349] DETAIL: Connection matched pg_hba.conf line 91: "host all root 127.0.0.1/32 ident map=test"
i checked config file many times, and could not find any reason of this error.
pls help me.
thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2023-08-26 10:38:30 | Re: ident auth does not works as usual |
| Previous Message | Ron | 2023-08-25 19:30:35 | Re: Will PostgreSQL 16 supports native transparent data encryption ? |