Upgrading PostgreSQL 8.3 to 8.4

[idareyou]

I just found out that PostgreSQL has been updated from 8.3 to 8.4. I downloaded and installed the newest 8.4 version from here, link. What do I do now to get my Holdem Manager (1.09 beta 34) to start using it with my old database? Do I need to convert my old database? Do I need to create a new 8.4 database and if so how do I transfer over the hands from my old database?

Thanks

[netsrak]

Leave your system as it is, there is no need to update.

If you really want to do it:
* create a backup of your database: http://www.holdemmanager.net/faq/afm....aspx?faqid=12
* export all hands in your database as a 2nd level backup: http://www.holdemmanager.net/faq/afm...aspx?faqid=173
* uninstall Postgresql 8.3
* install Postgresql 8.4
* restore the database

You find a lot of problems and tips in this thread: http://holdemmanager.net/forum/showthread.php?t=12925

[idareyou]

Okay, I will follow those steps to get 8.4 up and running on my computer. HOWEVER, before I posted I installed 8.4 and did nothing else. Now when I try to start up my holdem manager I get "The following error occurred when trying to open the database: Failed to establish connection to '127.0.0.1'."

Damn, I really don't want to lose my database.

[fozzy71]

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afm....aspx?faqid=73 and/or holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the holdemmanager.exe and the hmhud.exe executable and select "Run as admin" from the popup menu.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afm...aspx?faqid=171

Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afm....aspx?faqid=34
2) http://www.holdemmanager.net/forum/s...ead.php?t=8261

If that doesn't help at all we may want to schedule a remote support session to assist you.

[idareyou]

Thanks so much for the help.

This FAQ was what I used to fix it:

http://www.holdemmanager.net/faq/afm...aspx?faqid=171

I guess I won't update to 8.4 until you guys say we should.

[fozzy71]

I have no problems with 8.4, when installing it clean and importing my archives. I have seen multiple customers with DB problems when they try a backup of 8.3 and a restore to 8.4. Sometimes it works, but their DB suddenly performs at 10% of it's former speed or doesnt work at all

If you install sql 8.4 clean, you will want to make sure you immediately add exceptions to your firewall for the 8.4 files like you did for the files in the 8.3 installation. This is probably why you got the connection error when you installed 8.4 before.