PDA

View Full Version : Postsql resetting the password- Anyone know



sick cards
08-13-2009, 11:37 AM
Im trying to reset pw for postsql

I followed the instructions in the sql, but when I open the PG_hba.com it ask me what program created it. I dont really know. I tried word then tried saving the the changes to trust, but would not allow me to save in that specific folder.

Any help with this be awesome. I already have postsql downloaded using for my tracker, but holdem manager's pw for post were incorrect I really need help pls?

Thanks,


THis is the FAQ:

You can't retrieve your username and password.

However, in PostgreSQL, you can edit the pg_hba.conf file.

To edit the pg_hba.conf file, do the following:

1. Navigate to C:\Program Files\PostgreSQL\8.x\data.

2. Open the pg_hba.conf file using Notepad.

3. Change all instances of md5 to trust and then resave it.

PostgreSQL should now be okay with any username or password.

fozzy71
08-13-2009, 01:01 PM
... when I open the PG_hba.com it ask me what program created it.

i believe it is asking you what program to use to open the file:



2. Open the pg_hba.conf file using Notepad.



PT3's default name/password is - postgres/dbpass

If that password isn't right, you can try using svcpass, or postgrespass.


If neither of those work, you can remove the need for a password by editing the pg_hba.conf file.

Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

The file should open with Notepad

Scroll to the bottom where you will see this code




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5


You need to change the first 'md5' to 'trust', like this




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5



Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration



If none of that works, or you need help or don't understand something, please let me know and I can help you get it connecting properly.

sick cards
08-18-2009, 07:50 PM
Hi there,

AFTER TRYING TO CHANGE THE CODE LIKE YOU SAID UNDER PG_HBA WHEN i CHANGE TO TRUST A MESSAGE COMES UP WHEN i TRY TO SAVE IT SAYING:

Cannot the c:\ program files (x86)postgresql\8.3\data\pg_hba.conf file.
make sure the path and file name are correct

fozzy71
08-19-2009, 05:54 AM
If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

Try manually browsing to the path mentioned in the error, and see if the file does exist there. If not, try a windows search for pg_hba.conf


Let me know the results of those steps, and if necessary I can try to take a quick look at it for you.