View Full Version : backup error

08-08-2011, 10:06 PM
Im getting this error when trying to backup my HEM. Not sure if it's backed up correctly, or stop in the middle?HEM file is saved.

[8/8/2011 7:03 PM] HOLDEMMANAGER: error: pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 15040 of relation "playerhandscashkeycolumns"
pg_dump: The command was: COPY public.playerhandscashkeycolumns (pokerhand_id, playerhand_id, handtimestamp, gametype_id, player_id, numberofplayers, positiontype_id, holecard1int, holecard2int, holecardvalue_id, rakeamount, netamountwon, streetwentallin, didvpip, didpfr, preflopaction_id, firstpreflopactiontype_id, maxstreetseen, totalflopbets, totalflopcalls, totalturnbets, totalturncalls, totalriverbets, totalrivercalls, preflopplayeractiontype_id, flopcbetpossible, flopcbetmade, flopfacingcbet, flopfoldedtocbet, flopplayeractiontype_id, turncbetpossible, turncbetmade, turnfacingcbet, turnfoldedtocbet, turnplayeractiontype_id, rivercbetpossible, rivercbetmade, riverfacingcbet, riverfoldedtocbet, riverplayeractiontype_id, holecard3int, holecard4int) TO stdout;

[8/8/2011 7:03 PM] error: error backup up HOLDEMMANAGER

08-09-2011, 04:17 AM
Your database is damaged.
Please try a reindex of your database via pgadminIII->maintenance.
If that doesn't help you should create a new database and reimport all your hands (+notes +summaries).

10-10-2011, 03:07 PM
Hi, I have a problem with backup my database. I tryed to reindex my DB, I tryed to make a backup in pgadmin by I always get the same error, which is: ERROR: could not read block 2929 of relation base/17116/17139: Invalid argument. Can you give some advise please? Thanks a lot.

10-10-2011, 06:07 PM
That's a sign of a corrupt database.

Create a new database: Options--> Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager
Reimport your archive folder
Then create the backup: http://faq.holdemmanager.com/questions/72/Backup%26RestoreDatabase

10-29-2011, 12:27 PM
Reimport your archive folder

Hi, thanks for your advice. Can you explain to me what does "Reimport your archive folder" means exactly, please? I am not sure how to do this step. Thanks a lot.

10-29-2011, 11:40 PM
Run a import from folder, on the archive folder, default location is: C:/HMArchive