cottonseed
12-02-2009, 03:56 PM
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
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