PostgreSQL 8.4 FINAL is released after 3 months of the first 8.4 beta. 8.4 is supposed to be faster and has a HUGE list of updates.
If you are running HEM with PostgreSQL 8.3 and there are no problems stick to 8.3!
Only on special dual server XEON computers (with 32 cores), were they able to see a big improvement with 8.4. Having said that, HEM will change some of their program code in the future to be able to use some of the improvements of 8.4.
First always, please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe
Vista/7: Turn off UAC - http://www.holdemmanager.net/faq/afm....aspx?faqid=73
Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afm...aspx?faqid=171 or manually set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the popup menu.
If you want to install/upgrade to 8.4, it seems 8.4 has several installation problems.
-Some users can't get past the "insert password" since it sometimes doesn't accept your normal (postgrespass) password. To RESET your password for reinstalling SQL to a new/empty DB, please follow these steps:
1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator
PHP Code:
net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products...oad.do#windows
----
Also be carefull with the Tuning Wizard. On some systems it will make changes to the postgresql.conf it shouldn't, resulting in being unable to connect to the database.
If you experience this problem--> go to the 8.4/data folder, and delete postgresql.conf, and rename the backup postgresql.conf.2009(data xxxxxxxx) to "postgresql.conf" and reboot.
Windows VISTA/7 users: Sometimes you can get a "secondary logon" not found error during the installation. To fix this, rightclick my computer---> Manage--->Services and Applications---> Services---> find Secondary Logon (and start service)
--
Thanks to squalzen & luckylucky for a step by step backup & upgrade guide:
- Do a backup of your HM databases
- Postgres
Open PGAdminIII – Found in Start ->Programs->PostgreSQL8.3.
Right click on PostgreSQL Database Server 8.3(localhost:5432) and click Connect. Enter your password.
Select your database(s), right click and backup each one you want to keep. - HoldemManager
Export all your hands from HM, as they could be needed as you will see in step 5 later. You can do this by either running DBControlPanel.exe located in your holdemmanager folder or via holdemmanager itself under Options ->Database Management.
Click connect to your old database.
Once in the Database Control Panel – Click Export Hands for each database that you want.
- Stop the PostgreSQL services (8.3)
Found in Start ->Programs->PostgreSQL8.3. -> stop service - Download and run the latest 8.4 installer
Latest installer found at http://www.postgresql.org/download/windows
Install the exe (for Vista users might be best to right click on the exe and run as administrator)
Enter your postgres password for both Password and Retype Password textboxes. Click Next.
Enter 5432 for Port. Click Next.
Leave Locale as (Default locale)
Leave Install pl/pgsql in template1 database checked.
Click next. Wait a few minutes.
Uncheck Launch Stack builder at exit. Click Finish. - Open Database Management from HoldEmManager or run DBControlPanel.exe from your HoldemManager directory.
Don’t worry if you receive “The following error occurred when trying to open the database Fatal……………..”. just click OK and connect to Database Control Panel. Create a new database (name does not have to be same as the back up databases) and set as default. Click "Start HoldemManager". Close HoldemManager. - Open PGAdminIII (make sure you do this via Start ->Programs->PostgreSQL8.4(preferably not 8.3, not sure if it makes any real difference though) and connect to the 8.4 server.
Select the database you just created. - Restore the database(s) that you backed up earlier into their new counterparts.
Click on the database, Right click and Click Restore and browse to the file where you backed up your database. On restore Database window, keep the defaults as they are and simply select OK. Wait for restore to complete (can take quite a long while) If window has (Not responding on it) you can ignore this, it’s just an intensive task that takes a long time. - Test
Open HoldemManager when the restore is finished and check if all the players, hands, reports, etc. are restored. - Uninstall old version
If all is Ok uninstall postgreSQL 8.3 (in Vista from Control Panel -> Programs and Features.) - Reboot
----
Still Can't Connect to PosgreSQL? Try This!
Tips and tricks to solve other problems can be found in this thread.
Post in this thread if you have problems or additional questions.