Re: Forgot Password

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Laura Briones <laura.aylin.13@gmail.com>, pgsql-novice@lists.postgresql.org
Date: 2025-09-11T14:57:32Z
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