PDA

View Full Version : Cant perform database maintenance



karolis666
10-05-2011, 11:35 PM
Hello.

I've tried to Vacuum Analyze Database manually through post gress and through HEM. When I try manually I have to press OK every time when some error comes and because it stops then couldnt do it b/c takes forever. When I try through HEM in few mins receive and error and it stops permanently.

thanks

Sarek
10-06-2011, 04:56 AM
Via HM it works only with Postgres 8.4 AND when Postgres is installed in default paths.

karolis666
10-06-2011, 10:29 AM
So what should I do? I had postgress 8.4 installed.

fozzy71
10-06-2011, 02:39 PM
So what should I do? I had postgress 8.4 installed.

If you get errors when using the pgadmin method of vacuum/reindex, your database is probably damaged.

Sarek
10-06-2011, 02:39 PM
Use PGadmin
http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+
Vacuum and reindex via this tool

karolis666
10-06-2011, 07:29 PM
Use PGadmin
http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+
Vacuum and reindex via this tool
I've tried it many times. Every like 1-3 minutes analyzing stops, it shows that there is error in some part of database. I have to click OK it to be proceeded. Once I done it 3 days and everytime I am by PC I cklick it. Still didnt finish.
I get that database is damaged but what could be possible solutions?
Thanks

fozzy71
10-06-2011, 09:07 PM
Export your Hand Histories
http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands

Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback – Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

Then can you create a new database http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

Finally reimport all your hands/notes/summaries into the new database


All original hands that are auto-imported get moved to an archive for performance reasons. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).


This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created).


We have a backup and restore feature within Holdem Manager that makes it easy for you to backup all your settings, hand histories and files.
http://faq.holdemmanager.com/questions/418/Backup+%26+Restore

This is a new feature and there are some compatibility issues with it so if you have any problems you can do this manually by following the instructions below:

Manual database backup/restore via pgadmin - http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database