Switched from PT3, Can't install HEM (sql prob), NEED HELP NOW!!!

[zach383z]

I am really beginning to regret my decision on switching from PT3 which was a breeze to install compared to the 4 hours of my life I will not get back while messing with HEM!

I need complete help installing HEM! My main issue is PostgreSQL. I tried and tried to get HEM to work with my existing database for PostgreSQL 8.3 and had absolutely no luck. I uninstalled 8.3 and deleted all the information except chaged the data name to data_backup and kept that, hoping I could load it in later.

I am now trying to install SQL 8.4 and have ran into the following error "The password specified was incorrect. Please enter the correct password for the postgres windows user account." That is as far as I can get right now since it will not allow me past this point.

I am running windows 7, I disabled the firewall and the antivirus.

I am extremely frustrated at this point because I basically ruined my PT3 database to "upgrade" to HEM and now I am really having second thoughts!

Please help!

[zach383z]

I now just followed your instructions in the link http://forums.holdemmanager.com/showthread.php?t=20731 and it got all the way through the PostgreSQL install and at the end I get the error message "Sorry, could not install PostgreSQL"! This is so frustrating right now, I have been working on this for the past 5 hours!

[netsrak]

There was no need to touch your existing Postgresql installation for installing HM. You could just connect Holdemmanager to your running postgresql server.

If this is still running use the same database connection as for PT3 and create a new database.

If its not running i think you need to start with a fresh postgresql installation.

http://forums.holdemmanager.com/showthread.php?t=20755
For restoring your old data this might help:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

[zach383z]

That's all fine and dandy to know now, but I have already uninstalled my old SQL and tried to reinstall 8.4 with the error that I mentioned. It will not go any further with that error that comes up.

[netsrak]

Open a command box as administrator
and type
net user postgres /delete

Now you can start the installation again.

[zach383z]

Thank you. I will try this as soon as I get home. Would you happen to have instructions on how to open a command box for windows 7? I am not familiar.

My apologies for the way I came off in my initial post. I was ready to pull my hair out, but looks like I may have caused some of these issues myself by uninstalling SQL. I appreciate the support.

[netsrak]

This should explain it: http://www.howtogeek.com/howto/windows-vista/run-a-command-as-administrator-from-the-windows-vista-run-box/

[zach383z]

I now tried to do the command prompt and it gives me the following...

"The username could not be found"

[zach383z]

Instead of reinstalling 8.4 I reinstalled 8.3 and it now works! I do have a question though, do you know if i can just dump my data back into the data folder for postgres and will it then load with Hold'em Manager?

[fozzy71]

Instead of reinstalling 8.4 I reinstalled 8.3 and it now works! I do have a question though, do you know if i can just dump my data back into the data folder for postgres and will it then load with Hold'em Manager?

To use your old data folder you need to direct the installer to it when installing, and make sure you don't Initialize the DB Cluster.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

For reinstalling SQL to the same DB, follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\8.x\data directory to it's new location.
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.