From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Arbol One <ArbolOne@hotmail.ca>,
        "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Password forgotten
In-reply-to: <CAKFQuwa1n3qAsZOZ6bq+3gKYC=C_BEaiV9+E4_RE=swROV147Q@mail.gmail.com>
References: <DM8PR02MB79426EC52D426F6E42B33757BA112@DM8PR02MB7942.namprd02.prod.outlook.com> <CAKFQuwa1n3qAsZOZ6bq+3gKYC=C_BEaiV9+E4_RE=swROV147Q@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 23 Apr 2024 06:27:00 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3330171.1713881957.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Tue, 23 Apr 2024 10:19:17 -0400
Message-ID: <3330172.1713881957@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3330172.1713881957%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, April 23, 2024, Arbol One <ArbolOne@hotmail.ca> wrote:
>> psql-16 asks for the password, which I have forgotten.
>> Is there a way I can retrieve this master password?

> Nope.  You need to login using a method that doesn’t require a password
> then change the password.  See pg_hba.conf for authentication options.
> Usually connecting via local and peer authentication is the default option.

If all else fails, shut the server down and start it in single-user
mode.  That will let you in as a superuser and you can use ALTER USER
to reset the role's password.

			regards, tom lane