PDA

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).