Videos / Other Resources

No attachments were found.

Password Issues (PostgreSQL)

Overview:

If you are having PostgreSQL password issues, see below:

 

 


Solution:  ("postgrespass" or "dbpass" are the common Passwords people forget)
  • Note:  If you are migrating to Holdem Manager from a competitors product, your postgres password is more than likely "dbpass."  If you came here from the Holdem Manager installation, re-run the installation and use "dbpass" without quotes for the postgres password.
  • Note: For username 'postgres' the default password is typically 'postgrespass'.
  • Note:  If you're having problems inside of Holdem Manager, please see the solution below.

 


Use any user/pass for PostgreSQL

 

You can't retrieve your username and password, but you can edit the pg_hba.conf file so any username and password will work.

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

  1. Go to C:\Program Files\PostgreSQL\8.x\data, move the pg_hba file to your Desktop and open it with notepad.
  2. Scroll to the bottom and change all md5 references 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

 

Holdem Maanger and PostgreSQL will accept any password now.



Can't Connect to PostgreSQL? 

 

See the general PostgreSQL Connection FAQ

 

 

| More

Related Articles


User Opinions (323 votes)

87% thumbs up 12% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Visitor Comments

No visitor comments posted. Post a comment

Post a comment

To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Name:
   Email:
* Comment:
* Enter the code below:
 

Continue