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