Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing the admin/postgres user password - Mailing list pgsql-general

From David G. Johnston
Subject Re: Changing the admin/postgres user password
Date
Msg-id CAKFQuwaTMiVG2fqbNM66p4qTsvU_wBarF3-XoNeaDU1Hj8Rdsg@mail.gmail.com
Whole thread Raw
In response to Changing the admin/postgres user password  (Jeffrey Walton <noloader@gmail.com>)
List pgsql-general
Tree view
On Mon, Sep 5, 2022 at 7:40 PM Jeffrey Walton <noloader@gmail.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.

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Changing the admin/postgres user password
Next
From: Karthik K L V
Date:
Subject: Postgres SQL unable to handle Null values for Text datatype