Backing up DB/ Exporting HH issues.

[cottonseed]

Hello,

I need to reinstall my OS due to some pretty severe performance issues with my CPU. I am getting the following error message when I try and back up my DB.

......snip
pg_dump: dumping contents of table compiledresults_month
pg_dump: dumping contents of table gametypes
pg_dump: dumping contents of table handhistories
pg_dump: Dumping the contents of table "handhistories" failed: PQgetCopyData() failed.
pg_dump: Error message from server: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: The command was: COPY public.handhistories (pokerhand_id, handhistory, standardizedhandhistory, filename) TO stdout;
pg_dump: *** aborted because of error

Process returned exit code 1.


I have read that a backup is not always possible, so I have tried exporting all the HH to a file. When I am trying to export the HH. I am getting the following message.

An error occurred: The given key was not present in the dictionary.

I need all my data for tax purposes, so just starting from scratch is not really an option. Any advice or help would be great.

Kyle

[netsrak]

Your database seems to be corrupt. You could try a reindex via pgadmin -> maintenance but if that doesn't help we have no more options.

Don't you have the original handhistories in the Holdemmanager archive folder (default c:\hmarchive)?