"David G. Johnston" <david.g.johns...@gmail.com> writes:
> On Tuesday, April 23, 2024, Arbol One <arbol...@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
