On Tuesday, April 23, 2024, Arbol One <arbol...@hotmail.ca> wrote: > Hello. > In my Debian box, after entering this command to psql-16, *psql -h > localhost -U postgres* > > psql-16 asks for the password, which I have forgotten. > So I get this message: > > > > *psql: error: connection to server at "localhost" (::1), port 5432 failed: > FATAL: password authentication failed for user "postgres" connection to > server at "localhost" (::1), port 5432 failed: FATAL: password > authentication failed for user "postgres" * > > 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. David J.
