Overview:
For PostgreSQL password issues, see below:
Solution: ("postgrespass" or "dbpass" are the common Passwords people forget)
Note: If migrating to Holdem Manager from a Poker Tracker product, the postgres password is more than likely "dbpass." If running the Holdem Manager installation, re-run the installation and use "dbpass" without quotes for the postgres password.
Note: If there are problems inside of Holdem Manager, please see the solution below.
Use any user/pass for PostgreSQL
If unable to retrieve the username and password. edit the pg_hba.conf file. Then any username and password will work.
To edit the pg_hba.conf file, do the following:
- Go to C:\Program Files\PostgreSQL\8.4.7-1\data, move the pg_hba file to the Desktop.
- Open it with notepad.
- Scroll to the bottom and change all md5 references to trust.
- Save and close the file.
- Move the file back to the data folder.
- Restart the PostgreSQL service: Control Panel → Administrative Tools → Services
Holdem Manger and PostgreSQL will accept any password now.
You can change the password in the Command Prompt
Open the Command Prompt as Administrator.
- Go to the Start Menu.
- Open Accessories.
- Right-Click the Command Prompt, choose "Run As Administrator"
This will change the password to our standard postgrespass. You can replace it with anything you desire.
Change the Password in Services
Open Services
- Open Control Panel
- Open Administrative Tools (with default view, this is in Security and System)
- Open Services. They are listed alphabetically.
Right-click postgres and choose Properties
- Open the Logon Section
- Choose Logon As This User (or Account)
- Make sure .\postgresql is showing
- Type in and verify the password entered in the Command Prompt above.
- Click Apply and OK
- Restart Postgres service
The Postgresql installer will create the user "Network Service" rather than Postgres. If you run into trouble with logging in, make sure to follow the steps above to change md5 to trust, and then try re-installing.
Can not Connect to PostgreSQL?
See the general PostgreSQL Connection FAQ