| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pan snowave <windxp(at)live(dot)cn> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: ident auth does not works as usual |
| Date: | 2023-08-28 03:47:01 |
| Message-ID: | CAKFQuwYfrJFMO2fa_Z-kzEfrTJJk8SjxJJfbHsv3WQc0LEK+2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday, August 27, 2023, pan snowave <windxp(at)live(dot)cn> wrote:
> Hi
>
> "Show your psql command that is failing."
>
> [root(at)~ 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.
>
What about your psql command is supposed to inform the system that you want
to login at the db role cce? The ident file doesn’t magically alias one
name to another, it’s purpose is to allow some OS user to specify some
other name to use to authenticate instead of the OS user they are executing
the command with.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2023-08-28 07:42:37 | Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly |
| Previous Message | pan snowave | 2023-08-28 03:30:17 | 回复: ident auth does not works as usual |