PDA

View Full Version : problem with postgreSQL 8.3



gugamaciel
02-04-2010, 11:32 PM
hello,
i use a same database for like 5-6 months, and acess it every month to maintention, now i tryied acess and my pass was saved and it "dismiss" the save password and the pass dont work anymore.
any idea for reset or look the password in any place?
my pass is same for like 2 years "postgrespass" but it dont work

fozzy71
02-05-2010, 12:28 AM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL)