PDA

View Full Version : PostgreSQL Nightmare



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.

Gacil
05-25-2010, 04:29 PM
I've only quickly scanned your problem so apologies if I missed something.
First thought is, did you type a random password in or leave it blank? Just guessing that some input is required?

IDropDeuces
05-25-2010, 04:55 PM
I've only quickly scanned your problem so apologies if I missed something.
First thought is, did you type a random password in or leave it blank? Just guessing that some input is required?

Hi,

I have tried using this password

http://i49.tinypic.com/2i3y15.jpg

And this password

http://i50.tinypic.com/hts1ma.jpg

And I've also tried leaving the password field blank, leaving both username & password fields blank, and entering a random password.

All give the same error message. :(

Gacil
05-25-2010, 05:00 PM
Ok, I'll take a closer look, and thanks for taking the time to lay out your problem so clearly - sure makes life easier :)

IDropDeuces
05-25-2010, 05:01 PM
No, thank you for your help! :)

Gacil
05-25-2010, 05:23 PM
Haven't done anything useful yet!

Ok here's a sticky that Fozzy refers to a lot.
http://forums.holdemmanager.com/manager-general/22409-failed-establish-unable-read-data-database-service-started-stopped.html


I must admit I'm no expert with Postgres as it's always worked ok for me in the past and I haven't had to resort to these fixes, so you probably already know more than i do.

fozzy71
05-25-2010, 08:06 PM
No, thank you for your help! :)

Please email me at fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.net/teamviewer. Please let me know what time zone you are in and what time/days are convenient for you. I schedule support from 12:00 - 22:00 EDT, 7 days a week.

IDropDeuces
05-28-2010, 12:33 PM
Please email me at fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.net/teamviewer. Please let me know what time zone you are in and what time/days are convenient for you. I schedule support from 12:00 - 22:00 EDT, 7 days a week.

Hi fozzy. Sorry I been away for a few days. I will try everything in the sticky Gacil posted tonight, then if it still doesn't work I will schedule a teamviewer session. Thanks.

IDropDeuces
05-28-2010, 01:58 PM
Got it working :D

This bit worked:


*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/Hol...ager_Setup.exe

Thanks!

Gacil
05-28-2010, 02:38 PM
Excellent, thanks for advising.