Обсуждение: Fwd: lost master password
Sent from Gmail Mobile
---------- Forwarded message ---------
From: Afa Jamal <afa.jam@gmail.com>
Date: Fri, Jun 7, 2024 at 8:13 PM
Subject: lost master password
To: <security@postgresql.org>
From: Afa Jamal <afa.jam@gmail.com>
Date: Fri, Jun 7, 2024 at 8:13 PM
Subject: lost master password
To: <security@postgresql.org>
Hello
how you can help me with lost super password?
thank you
Afa J Zada
On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > how you can help me with lost super password? Are you talking about a PostgreSQL superuser password or about the "master password" that the pgAdmin client uses to encrypt connection information? Yours, Laurenz Albe
superuser
Sent from Gmail Mobile
On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote:
> how you can help me with lost super password?
Are you talking about a PostgreSQL superuser password or
about the "master password" that the pgAdmin client uses
to encrypt connection information?
Yours,
Laurenz Albe
Hi
Do following
Stop pg service
Open pg_hba.conf
Put trust for authentication e.g. "local all all trust"
Start the service
Log in using psql e.g psql -U postgres
Change the password e.g ALTER USER postgres WITH PASSWORD 'new_password';Regards
Kashif Zeeshan
Bitnine Global
On Mon, Jun 10, 2024 at 2:01 PM Afa Jamal <afa.jam@gmail.com> wrote:
Sent from Gmail Mobile---------- Forwarded message ---------
From: Afa Jamal <afa.jam@gmail.com>
Date: Fri, Jun 7, 2024 at 8:13 PM
Subject: lost master password
To: <security@postgresql.org>Hellohow you can help me with lost super password?thank you--Afa J Zada
On Mon, 2024-06-10 at 05:06 -0400, Afa Jamal wrote: > On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote: > > On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > > > how you can help me with lost super password? > > > > Are you talking about a PostgreSQL superuser password or > > about the "master password" that the pgAdmin client uses > > to encrypt connection information? > > superuser https://lmgtfy.click/?q=reset%20postgresql%20superuser%20password Yours, Laurenz Albe