Postgres Pro
Downloads
Home   >   mailing lists

Re: lost master password - Mailing list pgsql-general

From Kashif Zeeshan
Subject Re: lost master password
Date
Msg-id CAAPsdheeXsimjVCANqn7haGkRnTBN_DeX4yOGDDGTiRn1Y0y0w@mail.gmail.com
Whole thread Raw
In response to Fwd: lost master password  (Afa Jamal <afa.jam@gmail.com>)
List pgsql-general
Tree view
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>


Hello
how you can help me with lost super password?

thank you 


--
Afa J Zada

pgsql-general by date:

Previous
From: Afa Jamal
Date:
Subject: Re: Fwd: lost master password
Next
From: Laurenz Albe
Date:
Subject: Re: Fwd: lost master password