There is no way to reset the password without logging into the host resetting the password if there is no other superuser or other high level role to login as..
If this is a Linux box sudo as postgres then psql the default configuration is trust Unix Sockets, then can reset the password.
have to have sudo powers to become postgres... have to have sudo powers to modify the pg_hba.conf file then reload the config..
sudo -iu postgres
psql
\password <username>
Windows this is bit harder, best add localhost trust entry into the pg_hba.conf then reload the configuration
psql -h localhost -U postgres -d postgres
\password <username>
Hope this helps
Thanks
Justin
On 2025-Sep-11, Laura Briones wrote:
> [image: image.png]
> 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.
I don't know of any way to reset that password without logging in to the
computer that hosts the service.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica" (Irulan)
