Can anyone link me to info on how to do this?
Currently using Windows Vista + HEM 1.11.03 + Postgres 8.2, will be moving db to a new pc with Windows 7. Hopefully there is a "how to" guide somewhere here already.
Moving DB to new pc
Can anyone link me to info on how to do this?
Currently using Windows Vista + HEM 1.11.03 + Postgres 8.2, will be moving db to a new pc with Windows 7. Hopefully there is a "how to" guide somewhere here already.
Just found this
FAQ - Hold'em Manager Poker Tracking Software :: Backup & Restore Database
Should moving the db be as easy as backup on old pc and restore on new pc?
Also, regarding the info in my original post, are there any tweaks I need to be aware of? Should I upgrade postgres on my old pc, for example, so that I can have a newer version of postgres on my new one? Or just use an old postgres version to the backup/restore, and then upgrade postgres on the new pc?
SQL 8.2 is not compatible with 8.3/and 8.4
So if you have a large SQL 8.2 database with a proper backup you wish to restore--> just stick to SQL 8.2
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
Ok, so I need to install 8.2 on W7 pc to restore.
Before backing up my old pc, is doing a dump/restore a good idea?
More questions. How do I check the which is the exact postgres version I have?
If I backup in HEM, and restore in HEM, does the postgres version still need to be the same on both pc's?
You may find the exact postgresql version in the log files in the postgresql subfolders. The major version should be in the service name or if you connect to your database server via pgadmin and look at the properties.
You should do a backup of your 8.2 database and please try to restore this with 8.3. This should work. And if you make a backup with 8.3 you may be able to restore it with 8.4.
You don't have to do the dump/restore
If you open pgadminIII--> you can see which SQL version is running on which port.
The SQL version the back was created in must be the same you're restoring to. You can restore a 8.2.1 back---> to a 8.2.16 installation.
Any 8.2.x <---> 8.2.x.
You can't restore a 8.2.x<---> to 8.3.x
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
Thanks for the replies so far.
Is exporting the hands from my db, then importing them to a new db on the new pc, a better option than backup/restoring? That way would I be able to upgrade to 8.4 on the new pc, right? I'm guessing the export/import would take a lot longer than backup/restore?
yes..... better.. allows you to upgrade SQL...
but importing takes more time.. than restoring a .backup
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
Posting Permissions
Reply With Quote