PDA

View Full Version : Backup failure



imagine7
01-27-2010, 04:12 PM
Hi ,

I usually do a backup of my HEM database everyone and and a while without any problem, but today i had this message :

pg_dump: sauvegarde du contenu de la table handhistories
pg_dump: la commande SQL a échoué
pg_dump: Message d'erreur du serveur : ERREUR: en-tête de page invalide dans le bloc 1202392 de la relation base/16395/16435
pg_dump: La commande était : COPY public.handhistories (pokerhand_id, handhistory, standardizedhandhistory, filename) TO stdout;
pg_dump: *** interrompu du fait d'erreurs

Le process a retourné le code de sortie 1.



As a result my backup fails and can't be done.
Is there something to be done?

Thanks,

Guillaume

fozzy71
01-27-2010, 07:36 PM
It appears your DB is damaged.


French to English translation
pg_dump: saving the contents of the table handhistories
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: en-tà ª te invalid page in block 1202392 relationship base/16395/16435
pg_dump: The command was: COPY public.handhistories (pokerhand_id, handhistory, standardizedhandhistory, filename) TO stdout;
pg_dump: *** discontinued due to errors

You can try to fix that particular index - http://faq.holdemmanager.com/questions/86/Fix+Indexes

You can also try to vacuum/analyze and reindex, thru pgadmin - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+


If neither option work you will have to try and restore an older backup file, and import the archived hands since that backup was made, or create a new DB and import all of your original/archived hands.