Cant perform database maintenance
Results 1 to 7 of 7
  1. #1
    Junior Member
    Join Date
    Oct 2011
    Posts
    4

    Default Cant perform database maintenance

    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

  2. #2
    Holdem Manager Support Sarek's Avatar
    Join Date
    May 2010
    Location
    Eridani 40
    Posts
    22,114

    Default

    Via HM it works only with Postgres 8.4 AND when Postgres is installed in default paths.

  3. #3
    Junior Member
    Join Date
    Oct 2011
    Posts
    4

    Default

    So what should I do? I had postgress 8.4 installed.

  4. #4
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    31,308

    Default

    Quote Originally Posted by karolis666 View Post
    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.

  5. #5
    Holdem Manager Support Sarek's Avatar
    Join Date
    May 2010
    Location
    Eridani 40
    Posts
    22,114

    Default

    Use PGadmin
    http://faq.holdemmanager.com/questio...lyze+Database+
    Vacuum and reindex via this tool

  6. #6
    Junior Member
    Join Date
    Oct 2011
    Posts
    4

    Default

    Quote Originally Posted by Sarek View Post
    Use PGadmin
    http://faq.holdemmanager.com/questio...lyze+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

  7. #7
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    31,308

    Default

    Export your Hand Histories
    http://faq.holdemmanager.com/questio...6+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/...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/...ta-view-01.jpg

    Then can you create a new database http://faq.holdemmanager.com/questio...elete+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/questio...up+%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/questio...store+Database

Similar Threads

  1. HEM Maintenance
    By harmonica in forum Manager General
    Replies: 1
    Last Post: 05-01-2009, 04:02 PM
  2. Maintenance nr of players in database
    By ThePower in forum Manager General
    Replies: 1
    Last Post: 03-31-2009, 08:53 AM
  3. Database Maintenance Batch files
    By Cusem in forum Manager General
    Replies: 1
    Last Post: 09-27-2008, 02:24 AM
  4. Database Maintenance (?)
    By PatInTheHat in forum Manager General
    Replies: 1
    Last Post: 08-29-2008, 01:00 PM
  5. DB Maintenance
    By High Time John in forum Manager General
    Replies: 1
    Last Post: 08-27-2008, 02:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •