PDA

View Full Version : Can't backup my database


hochiminh
08-20-2010, 03:19 PM
Hello,

I'm trying to backup my db and settings via your new backup tool and it returns this error:

[20.08.2010 23:17] MYDB: error: pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 351 of relation base/16700/16766
pg_dump: The command was: COPY public.handhistories (pokerhand_id, handhistory, standardizedhandhistory, filename) TO stdout;

[20.08.2010 23:17] error: error backup up MYDB
hochiminh
08-21-2010, 12:45 AM
anyone? please?
tried to do it via pgadmin III, here's what I got:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 351 of relation base/16700/16766
pg_dump: The command was: COPY public.handhistories (pokerhand_id, handhistory, standardizedhandhistory, filename) TO stdout;
pg_dump: *** aborted because of error
The Minder
08-21-2010, 01:59 AM
Sounds like postgres and/or your db is not on C drive?
hochiminh
08-21-2010, 03:36 AM
no it's on C drive
netsrak
08-21-2010, 05:13 AM
Sorry but it seems to be to late for a backup. Your database is already corrupt.

You can try a reindex via pgadminIII-> maintenance but if that doesn't fix it you need to create a new database and reimport all your hands.
hochiminh
08-22-2010, 10:18 AM
How can it be corrupt, I've been playing for months without a problem?
netsrak
08-23-2010, 04:24 AM
Its probably a part of the database which is not used during normal play so you didn't notice it during normal use.