Originally Posted by
BubbleBoy
So I have hard drive with a /postgres/data/ folder that stores my db and that I used on my old windows.
On the new PC I didn't do a good job installing HM/postgres (why is the combo installer not letting me configure anything for postgres, it just installs it on C where no one wants it)
95+% of our customers install the database to the C:\ drive (their only drive) so we simplified the installer for the majority of our customer base. If you need to install to a different partition/drive, you will need to download a standalone postgresql installer.
I did this
http://faq.holdemmanager.com/questio...e+or+Partition
(have previously done this successfully on the old PC so I don't think I made a mistake there, also tried various times) to link postgres to the right folder. But I cant start the service after setting the new /data/ directory. It times out.
This is for moving a database, that is already installed and working, to a new directory. To install an old \data folder to a new machine you need to use the same installer/version that was used to create the database and follow the steps in a different FAQ.
Please update to the latest beta - http://rvgsoftware.fileburst.com/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
PHP Code:
net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://faq.holdemmanager.com/questio...g+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.
If your old database is 8.3, and was created with our old/original postgresql.zip you will want to use this installer (8.3.7, I think) - http://www.holdemmanager.com/downloads/postgresql.zip
If your database was created with the 8.3.9 one-click installer we sometimes link to customers, you will want to use this installer - http://www.holdemmanager.com/downloa...3.9-v1.0.7.exe
The old database ran under 8.3, now I got 8.4, is that a problem? How do I get access to the my database?
It is best to use the exact same installer you used originally. If you dont have the same installer you definitely want to have the same major version number, or a slightly higher revision number. If your database was created with 8.3.9 you should definitely not use 8.2, or 8.4, and I would suggest you do not use 8.3.7 or 8.3.8 either.