HEM wouldnt start

[Guyra]

so I updated postgre and now it created a brand new database. I can't find my old db.
I looked all thru the RVG folder and can't find it
Did I lose it somehow?

[netsrak]

Did you install the full version with postgres enabled?

Then your old database is saved in a backup copy of the data folder in the Postgresql installation path.

You need to uninstall Postgresql, delete the new data folder, rename the old one and reinstall Postgresql with the existing data folder (= cluster):
http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database

[Guyra]

I think I downloaded the full 8.3

Previously I had the 8.2 dl-ed on 01/23/10 but havent rebooted my computer til this morning. this is when HEM wouldnt load correctly so i dl-ed 8.3 this morning and got the new db.

Now I'm thinking 8.2 wasn't installed correctly but I can't seem to find other versions previous to 8.2 on my computer. Shouldn't I have other versions of postgre if i've been using HEM for a few years now?

And I still can't find my db.

[fozzy71]

I think I downloaded the full 8.3

Previously I had the 8.2 dl-ed on 01/23/10 but havent rebooted my computer til this morning. this is when HEM wouldnt load correctly so i dl-ed 8.3 this morning and got the new db.

This is not how you update postgresql. The only dependable way to upgrade from 8.2 to 8.3 or 8.4, is to uninstall the old version, install the new version, and import all your original/archived/exdported hands.


Now I'm thinking 8.2 wasn't installed correctly but I can't seem to find other versions previous to 8.2 on my computer. Shouldn't I have other versions of postgre if i've been using HEM for a few years now?

And I still can't find my db.

It was installed fine, most likely. You installed a brand new, alternate installation of PostgreSQL 8.3. This killed your connection to your PostgreSQL 8.2 server which had your old DB and created a new installation and empty DB.

To try and get your old DB connected again we will have to uninstall 8.3, find an installer for 8.2, and reinstall to the same \data directory. This will usually reconnect your old DB, but it is not 100% fail-proof. If we get it working we can export all the hands, notes, and tourney results. Then if you want to use the latest version of PostgreSQL we can uninstall 8.2, install 8.4, and import all your archived and exported hands. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.


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://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database

You can download an 8.2 version from here:

http://www.postgresql.org/ftp/binary/

Unzip that to a new folder and run the postgresql-8.2.msi file from the new folder.

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.


If you are unsure of any of my instructions or need assistance 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.