View Full Version : Backup Issue
thearthurdog
09-16-2012, 12:50 AM
Hi - my backup keeps failing with this error message:
[16/09/2012 2:47 PM] thearthurdog15: error: pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 84025 of relation base/16794/16864
pg_dump: The command was: COPY public.handhistories (pokerhand_id, handhistory, standardizedhandhistory, filename) TO stdout;
[16/09/2012 2:47 PM] error: error backup up thearthurdog15
Any ideas?
fozzy71
09-16-2012, 05:36 PM
This error usually indicates that your database is corrupt damaged. It will need to be backed up manually and re-created manually.
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).
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.