From: | Jos van Roosmalen <josr(at)josr(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Help: my table is corrupt! |
Date: | 2005-03-27 15:19:33 |
Message-ID: | 67AC5485-F0F9-4118-A053-A1E5D7807D9D@josr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
Can someone explain me how to repair a table?
If I execute a 'select * from <brokentable>' in PSQL I get the next
error. A pg_dump export only partially export the broken table and
ends with the same error:
"Invalid memory alloc request size: 4294967290"
Note that this number is really close to 2^32.
I am running x86 Linux (Gentoo), with Postgresql 7.4.
This is what I tried to repair the table and all didn't work:
- Turning ZERO_DAMAGED_PAGES to true in postgresql.conf;
- Running REINDEX TABLE <brokentable>, and REINDEX DATABASE <thedb>
- Running VACUUM <brokentable>
This table contains arround 6 million records, and every record only
contains a few text, number and date attributes.
Queries/Exports on other tables works fine.
Is there a Postgresql Repair application which delete or repair
corrupt records?
Thanks in advance!
Jos
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2005-03-27 15:47:56 | Re: grant problem |
Previous Message | Michael Fuhr | 2005-03-27 06:52:43 | Re: Question about trace session |