Error using Backup/Restore Util

[megamulk]

Hi,

I got a new pc today so decided to use the backup restore utility to get my HEM setup across.

However everytime i attempt to backup my current database i get the following error....any ideas? I am using v1.11.02

Thx


[20/06/2010 02:35] holdemmanager: error: pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: timestamp out of range
pg_dump: The command was: COPY public.playerhandstourneykeycolumns (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, tourneynumber, icmsklanskybucks, holecard3int, holecard4int) TO stdout;

[20/06/2010 02:35] error: error backup up holdemmanager

[netsrak]

Please try a backup via pgadminIII. Does this work?

[megamulk]

Please try a backup via pgadminIII. Does this work?

Hi and thx for your response, just tried the backup via pgadmin and get the same (or very similar) error. See below.

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: timestamp out of range
pg_dump: The command was: COPY public.playerhandstourneykeycolumns (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, tourneynumber, icmsklanskybucks, holecard3int, holecard4int) TO stdout;
pg_dump: *** aborted because of error

Process returned exit code 1.

[netsrak]

OK, this means your database is damaged.

Please try a reindex via pgadminIII->maintenance

If that doesn't help the only way to save your data is a export of hands, notes and summaries.

[megamulk]

Thx, gave that a go but no joy. Guess i'll be doing it the long way. Thanks for your help anyway