Originally Posted by
Bennobal
I just did a brand new install of win 7. I have the OS on SSD and data will be on 2nd (regular) HDD. I now want to install HM and postgres on the SSD. Afterwards I want to import (backup/restore) my DB in the PGadmin. I backed it up from my last system which was running postgres 8.2. I guess HMcomboinstaller will install postgres 8.4.x. Will my plan work?
Nope.
You will need to install the same version. Hopefully your DB was made with 8.2.15 or .16
If you already installed postgresql 8.4 with the combo installer:
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
PHP Code:
net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your backup file - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database
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.
* Download and UnZip this file to a new folder. http://www.holdemmanager.com/downloa...l-8.2.15-1.zip
6) Then run the postgresql-8.2.msi file and follow the instructions above.
Can I still use my existing password etc from postgres.? Or will everything be new and do I have to re import all hands since like 2008? (I have those in archive on ext HD).
If you are reinstalling your old \data folder from 8.2 you can and should/need to use the old password.
I would personally suggest you dont use your old DB. Use our combo installer and rebuild by importing your original/archived hands and results/summaries. Your old 8.2 database is likely large, and larger than it needs to be because the logging was enabled. It is also quite a few years old and there have been many improvements through 8.3 and 8.4.
Is there a guide or step by step thing for my situation? I dont want to run into issues from postgres and the 8.4 coding/passwords problems etc.
The steps above should you guide you well if you choose to reinstall the old database. I think a new database is the much better option, for many reasons.