PDA

View Full Version : PostGres Problem



Galoper
03-12-2009, 03:49 PM
I´m havin problems with PostGres

I have 8.3 version

I have no problems for a long time, my database have about 79 Gb. Lot of hands.

Today i cant import hands, all hands i try to import give me like errors.

When i open Holdem Manager i get the follow message:

An error ocurred while retrieving the imported file list: ERROR: XX001: invalid page header in block 5602 of relation "importedfiles_idx1"

I can close de the message and continue using program, but, if i want import, All hands appear like Import Error

This happend for xml ipoker network and for some txt Pokerstars , but not for all files.

One more thing...I try to make a vacuum, using pgAdmin, but i cant, an header error appear, some if i try to reindex.

What can i do?

morny
03-12-2009, 08:56 PM
Can you try fixing the index http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Galoper
03-13-2009, 06:22 AM
Can you try fixing the index http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Thanks morny, but.....don´t work

I try to reindex and get this error message:



Index rebuilding has failed ERROR: XX001: invalid page header in block 3781 of relation "importedfiles".


More ideas?

morny
03-13-2009, 11:55 AM
Ok youll need to export the hands from the old database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database