Re: Forgot Password

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Laura Briones <laura(dot)aylin(dot)13(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Forgot Password
Date: 2025-09-11 14:57:32
Message-ID: d3d6b987ff67f44a2c3659a2da3783e10065e51f.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, 2025-09-11 at 11:49 +0400, Laura Briones wrote:
> [image of pgAdmin 4 asking for the password of "postgres"]
> Hi, How do I reset this password? The data file is not on my computer
> so I can't go into  pg_hba.conf to reset.

Then you cannot reset the password.

You have to ask the database administrator (the person who has access to
the database server machine and can modify the configuration files)
to help you.

- a superuser can reset your password (if necessary, by starting the
server in single-user mode)

- anybody who can modify "pg_hba.conf" can allow you to login
without a password

Yours,
Laurenz Albe

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Álvaro Herrera 2025-09-11 16:54:53 Re: Forgot Password
Previous Message Laura Briones 2025-09-11 07:49:49 Forgot Password