Windows reinstall

[Raisolution]

I'll have to reinstall my Windows today. I've registered HEM and associated the serial key with it. What should I do now? Reset the key or reinstall and then reset it?
P.S. Should I do something else except exporting the databases? :o

[netsrak]

You need to reset your license for the new installation:
http://www.holdemmanager.net/Registration

For the new installation we have some FAQs you should follow:
Backup your database: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12
Export all your hands (2nd level backup): http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
Notes: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
Settings: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98

[Raisolution]

I've backuped my database and settings and after the reinstall I've restored them, but when I start HEM everything is empty. I can see my database in the database management, but it's empty in HEM. How to restore it now?

[netsrak]

Did the restore work without problems?
Can you connect to the database via pgadmin?

Check this: http://www.holdemmanager.net/faq/afmviewfaq.aspx?topicid=20&faqid=19

[Krzysiek]

I've backuped my database and settings and after the reinstall I've restored them, but when I start HEM everything is empty. I can see my database in the database management, but it's empty in HEM. How to restore it now?

i have the same problem, and yes i Can connect to the database via pgadmin and i Check: http://www.holdemmanager.net/faq/afm...id=20&faqid=19 and there is 1032000 in box "count bigint", but holdem doesnt see any hands

[Krzysiek]

and one more question hpw long should rebuilt index go? Becouse my has gone all night and hasnt stopped yet? Index -compiled playerresult_month idx1

[netsrak]

Depends on the size of your database, usually i would say some hours.

If it doesn't come to an end your database is possibly corrupt and you need to start with a new one: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146

[Krzysiek]

what about my first question? What is a purpose of doing backup when you cant restore it later. my comp hang up and i had to turn it of. but i had done backup ealier and now i restore database as it says in FAQ. but after i open HM there is no history, no players no hands. What is wrong?

below screenshot after restoring
2273

[fozzy71]

Backup/restore is not 100% fail proof, but it is faster than importing the old hands. You must use the same postgresql version to restore the DB, that it was created in. I keep copies of my original hands, exported hands, the DB .backup files, and the actual \data folder.

[Krzysiek]

i know its faster, thats why i want to restore database not importing all hands again which in my case go 2days. I used the same postgresql version to restore DB, that it was created. my backup file was created 2 weaks ago. I still want to know how to restore my DB

[Veteran68]

The pgAdmin backup/restore/maintenance tools are not very user-friendly in terms of reporting progress. They appear to be just wrappers around command-line programs, and apparently they don't/can't capture the command-line output (even when the "verbose messages" option is enabled) to give you any idea that they're working until the process is complete, at which time they dump everything to the Messages tab all at once. The reindex operation works a little better, displaying messages as it moves to the next index, but I've never seen the Restore operation report ANYTHING until restore is complete, which can take several hours. In the meantime pgAdmin appears to hang and Windows reports it as "non-responsive" if you attempt to interact with it. That's some shoddy UI event handling, but given this is PostreSQL, Windows support is probably an afterthought so I'm not surprised.

I suspect that perhaps you rebooted before the restore finished, thinking it was hung, resulting in a corrupted DB. My DB backups are 4-5GB last I checked, and it usually takes several hours to restore. I will usually start a restore before going to bed and just let it run all night. As far as how long a reindex takes, I ran one from pgAdmin last night, and it took about 10 minutes to complete. Mind you these numbers are on a pretty hefty desktop -- an Intel i7 860 Quad-core with 8GB RAM running 64-bit Windows 7. If you're running a PC of much lower specs, expect things to take longer, although this DB stuff is primarily I/O bound and not processor/RAM bound so it won't be proportionally slower. A faster hard disk would speed things up. I have a 10,000rpm Raptor boot drive, but unfortunately my database (and everything but the OS) are on a regular 7200rpm drive.

[Krzysiek]

i waited 16 hours before i press cancel button after restoring and i have the same problem- 0 hands history. What now?

[fozzy71]

I would suggest importing your archived hand files to a new DB.

[Krzysiek]

i know i can do this, but it lasts long time, and this is a purpose of doing backup - quick recovering hand history.

[netsrak]

Which coding was your original database (SQL_ASCII or UTF)?

You need to create the new database with the same coding.

[fozzy71]

Which coding was your original database (SQL_ASCII or UTF)?

You need to create the new database with the same coding.

ASCII I would assume. The majority of 8.3 databases were created using the default win1252/sqlascii encoding.