Re: lost master password

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(dot)jam(at)gmail(dot)com> wrote:

>
>
> Sent from Gmail Mobile
>
>
> ---------- Forwarded message ---------
> From: Afa Jamal <afa(dot)jam(at)gmail(dot)com>
> Date: Fri, Jun 7, 2024 at 8:13 PM
> Subject: lost master password
> To: <security(at)postgresql(dot)org>
>
>
> Hello
> how you can help me with lost super password?
>
> thank you
>
>
> --
> *Afa J Zada*
>