Videos / Other Resources

No attachments were found.

Password Issues (PostgreSQL)

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:

  1. Go to C:\Program Files\PostgreSQL\8.4.7-1\data, move the pg_hba file to the Desktop.
  2. Open it with notepad.
  3. Scroll to the bottom and change all md5 references to trust. 
  4. Save and close the file.
  5. Move the file back to the data folder.
  6. 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.
  1. Go to the Start Menu.
  2. Open Accessories.
  3. Right-Click the Command Prompt, choose "Run As Administrator"
In Windows 8 or 10, right-click your Start button and Command Prompt (Admin) is just above the horizontal line in the middle of the menu)
If you have the Creator Update + for 10, this is called Windows POWERSHELL
Change the Password by typing "net user postgres postgrespass" without quotation marks. Hit Enter.

This will change the password to our standard postgrespass. You can replace it with anything you desire.


Change the Password in Services


Open Services
  1. Open Control Panel
  2. Open Administrative Tools (with default view, this is in Security and System)
  3. Open Services. They are listed alphabetically.

Right-click postgres and choose Properties
  1. Open the Logon Section
  2. Choose Logon As This User (or Account)
  3. Make sure .\postgresql is showing
  4. Type in and verify the password entered in the Command Prompt above.
  5. Click Apply and OK
  6. Restart Postgres service
For newer versions of Postgres (9.1+)

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

 

 

| More

Related Articles


User Opinions (31 votes)

90% thumbs up 9% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Continue