PDA

View Full Version : Best way to update Postgresql?



Kennell9
10-25-2009, 04:57 PM
I'm running and an older version and want to update, but updating it doesn't seem to be very straight forward. I want to make sure i do it right and keep all of my old setting the same. Is there a best way to do this?

Thanks,
Mike

fozzy71
10-25-2009, 08:50 PM
I recommend you export your db to text files, uninstall sql, reinstall 8.4, create a new db, and import the exported hands and any archived hands to be sure you get everything. You can try a backup/restore, but those are not anywhere near fail-proof.


You want to make sure you backup your Processed/Archived hand histories.

export your tournament summaries: Tourney > Results > Dataview > All Hands > Right-Click > Export Tourney Results and Summaries.

manually export the database to hand history text files:

HM > Options > Database Management > Connect > Export Hands

How do I export or import hands into and from Holdem Manager? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

Make sure you copy that folder as well as the other stuff I mentioned.


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

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/pgdownload.do#windows


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