PDA

View Full Version : Postgressql wants password I don't know



sriverfx21
02-10-2010, 05:38 PM
Hello,

I installed a new version of Holdem Manager on my laptop. I couldn't connect because of a timeout problem with PostgresSQL. So I uninstalled the database and reinstalled it. Now everytime I try to reinstall the HoldemManager or PostgressSQL it tells me my database password is invalid.

I have the password from my old database but that doesn't work. Is there a default Postgress password I should be trying?

fozzy71
02-10-2010, 06:03 PM
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.

FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL) (http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL))


To reinstall postgresql for a new, empty DB:

*Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe