On Tue, Apr 23, 2024 at 08:14:15AM -0400, Arbol One wrote:
> Hello.
> In my Debian box, after entering this command to psql-16, *psql -h localhost
> -U postgres*
You might want to read
https://www.depesz.com/2008/11/28/recovering-lost-postgresql-password/
Best regards,
depesz
"David G. Johnston" writes:
> On Tuesday, April 23, 2024, Arbol One 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
On Tuesday, April 23, 2024, Arbol One 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),
Have you tried
sudo -u postgres psql
On Tue, Apr 23, 2024 at 2:14 PM Arbol One 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:
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
