IDropDeuces
05-25-2010, 04:20 PM
Hi folks, I'm sure you've heard this 1000 times before, but i'm having a lot of problems trying to get this postgreSQL working. I am not a computer noob but can not find a way round this problem. Please see below for the steps I took.
Install Holdem Manager + postgreSQL. HEM installs, I get a fail for postgreSQL.
http://i48.tinypic.com/24m6qle.jpg
I read the FAQ and see that:
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: If you're having problems inside of Holdem Manager, please see the solution below.
So, I try password as "dbpass" instead of "postgrespass". Re-run the installation and get the same error message.
OK, so I also see in the FAQ:
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 Manager and PostgreSQL will accept any password now.
So, off I go to this folder, find the file and edit it.
http://i47.tinypic.com/2cih0y1.jpg
Where it says "trust" it used to say "md5". I changed it as per instructions above.
So I re-try the installation but DOH! It still gives the same error. In fact, it asks for a password, contradicting the claim that "Holdem Manager and PostgreSQL will accept any password now."
I also notice now that when I boot up my PC, instead of one user account (myself), there is now two. One of them is named "PostgreSQL" :S Anyone any idea how that happened?
If anyone can help me with this i'd be really grateful.
Thanks
PS. I'm running Win7 64bit on a good spec machine.
Install Holdem Manager + postgreSQL. HEM installs, I get a fail for postgreSQL.
http://i48.tinypic.com/24m6qle.jpg
I read the FAQ and see that:
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: If you're having problems inside of Holdem Manager, please see the solution below.
So, I try password as "dbpass" instead of "postgrespass". Re-run the installation and get the same error message.
OK, so I also see in the FAQ:
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 Manager and PostgreSQL will accept any password now.
So, off I go to this folder, find the file and edit it.
http://i47.tinypic.com/2cih0y1.jpg
Where it says "trust" it used to say "md5". I changed it as per instructions above.
So I re-try the installation but DOH! It still gives the same error. In fact, it asks for a password, contradicting the claim that "Holdem Manager and PostgreSQL will accept any password now."
I also notice now that when I boot up my PC, instead of one user account (myself), there is now two. One of them is named "PostgreSQL" :S Anyone any idea how that happened?
If anyone can help me with this i'd be really grateful.
Thanks
PS. I'm running Win7 64bit on a good spec machine.