Skip site navigation (1) Skip section navigation (2)

Help: my table is corrupt!

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 (view raw or flat)
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





Responses

pgsql-admin by date

Next:From: Bruno Wolff IIIDate: 2005-03-27 15:47:56
Subject: Re: grant problem
Previous:From: Michael FuhrDate: 2005-03-27 06:52:43
Subject: Re: Question about trace session

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group