Home / server / Questions / 210821
Accepted
Jonas
Asked: 2010-12-10 04:36:05 +0800 CST

How can I reset the password on a PostgreSQL database on my machine?

  • 772

I installed PostgreSQL on my Windows 7 machine a few weeks ago. Now I would like to create a database with createdb mydb but I don't remember the password.

Is there anyway to reset the password? I have access to the Administrator account on my machine. Or do I have to uninstall PostgreSQL and then reinstall it again?

How can I reset the password on a PostgreSQL database on my machine?

password postgresql

1 Answers

  1. Best Answer

    Edit pg_hba.conf to allow access without a password, use "trust". Restart postgresql and you can access PostgreSQL without the usage of a password. Alter your password to something you can remember :) , edit pg_hba.conf again and reload pg_hba.conf.

    The Ubuntu-manual has a description about this issue as well.

    • 2