Error when doing backup of database and when I try to fix the index on HM

[ModdoX]

obs: My english is so poor

Hello, when I try do the backup of postgress DB happens this error:


pg_dump: dumping contents of table handhistories
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 466287 of relation "handhistories"
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.


And when I try fix the Index happens this:


Index rebuild has failed: ERROR:XX001: invalid page header in block 466287 of relation "handhistories"

How I can fix it?

[morny]

Looks like the database is corrupt, the easiest thing to do is export the hands from the database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 and then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and import the hands into this new database

[ModdoX]

hmm, but now I have another problem to export the hands, the HD partition where HM is installed is full and I am can't delete anything.
As I can alter the folder where the hands they will be exported of place, to another partition?

[ModdoX]

why the topic is on HUD session? I had posted it on another session.

[morny]

The only way to do this is to uninstall HM and reinstall it on a different partition

[ModdoX]

lol
I had not really thought about that, thanks guy, Iam doing that.

[ModdoX]

Man, I did it, but when Iam extracting the hands appear the same error


ERROR:XX001: invalid page header in block 466287 of relation "handhistories"

It is impossible to fix? Ow shit, another database lost.

[morny]

Trying doing a vacum but it looks like something serious is wrong with the database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163

Did you keep your archived hands? You could just reimport them

[ModdoX]

Same error doing a vacuum


INFO: analyzing "public.pokersites"
INFO: "pokersites": scanned 1 of 1 pages, containing 16 live rows and 0 dead rows; 16 rows in sample, 16 estimated total rows
INFO: vacuuming "public.handhistories"

ERROR: invalid page header in block 466287 of relation "handhistories"

I have no hands archived =/

Sick, GG Database?

[morny]

Last option would be to see if this fixes it http://www.holdemmanager.net/faq/?f=168 and use the handhistory_pkey index

[ModdoX]

I had already made that and had appear the same error.

Meh, GG, I will delete this DB and create another.

Thanks for the help man.