| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | noloader(at)gmail(dot)com |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Changing the admin/postgres user password |
| Date: | 2022-09-06 03:04:29 |
| Message-ID: | CAKFQuwaTMiVG2fqbNM66p4qTsvU_wBarF3-XoNeaDU1Hj8Rdsg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 5, 2022 at 7:40 PM Jeffrey Walton <noloader(at)gmail(dot)com> wrote:
>
> Or maybe better, what part of the manual discusses auth failures so I
> can read about them?
>
The chapter named "Client Authentication ".
https://www.postgresql.org/docs/current/client-authentication.html
It even has a subchapter named "Authentication Problems" though it seems
like discussion of (typical) default peer dynamics is missing.
In particular, if you connect via local socket (also a default) the order
of entries in (typical default) pg_hba.conf says you must login using peer,
not password.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karthik K L V | 2022-09-06 06:10:39 | Postgres SQL unable to handle Null values for Text datatype |
| Previous Message | Christophe Pettus | 2022-09-06 02:46:49 | Re: Changing the admin/postgres user password |