On Mon, Sep 5, 2022 at 7:40 PM Jeffrey Walton <noloader@xxxxxxxxx> wrote:
Or maybe better, what part of the manual discusses auth failures so I
can read about them?
The chapter named "Client Authentication ".
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.