Postgres DB password
Posted:
Sun May 18, 2008 8:49 pm
by Tripeiro
Ok.. im too stupid and I forgot the password (to put at spadeye) but worst.. I tried to create new password and erased the previous and now I cant go to my DB lol.
Anyone helps me?
Re: Postgres DB password
Posted:
Sun May 18, 2008 10:22 pm
by ptrack pat
From the Start menu select Programs > PostgreSQL 8.2 > Configuration Files > Edit pg_hba.conf
At the bottom of the file, change both places where it says "MD5" to say "trust" and save the file.
Now it shouldn't matter what password you use, it should be able to connect to the database anyway.