Re: Password forgotten - Mailing list pgsql-general

From Hans Schou
Subject Re: Password forgotten
Date
Msg-id CAApBw36c+uKOcSeqz4wLYDU7d+VKv0DcXwMO+VQ3KTWLA79PFw@mail.gmail.com
Whole thread Raw
In response to Password forgotten  (Arbol One <ArbolOne@hotmail.ca>)
List pgsql-general

Have you tried

   sudo -u postgres psql


On Tue, Apr 23, 2024 at 2:14 PM Arbol One <ArbolOne@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?

Thanks in advance.


--
ArbolOne.ca Using Fire Fox and Thunderbird. ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations. ArbolOne on Java Development is in progress [ í ]


--
𝕳𝖆𝖓𝖘 𝕾𝖈𝖍𝖔𝖚
☏ ➁➁ ➅➃ ➇⓪ ➁⓪

pgsql-general by date:

Previous
From: Arbol One
Date:
Subject: Password forgotten
Next
From: Marcos Pegoraro
Date:
Subject: Re: query multiple schemas