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
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.