Corrupt table, is zero_damaged_pages available in v7.2?

From: "Eric Comeau" <ecomeau_AT_NO_SPAM_(at)signiant(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Corrupt table, is zero_damaged_pages available in v7.2?
Date: 2005-07-22 13:41:00
Message-ID: dbqt18$2n4o$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have "one" corrupted table in a v7.2.4 database. The others are good.

We have identified the table should have 25 rows in it, and using pg_dump we
can get the first 10.

I was wondering if we could use the zero_damaged_pages under v7.2 to
hopefully skip over the corrupted data and read the remaining records. Is
this parameter only available in v7.3+?

I am in the process of getting a source build tree together to build
pg_filedump hopefully.

Thanks - Eric

Browse pgsql-admin by date

  From Date Subject
Next Message 梁炳場 2005-07-24 13:58:45 su: /bin/bsh Permission denied
Previous Message Fabio C. Bon 2005-07-22 12:45:18 RE: [ADMIN] Re: [ADMIN] Error: No se pudo localizar un registro de checkpoint valido ¿ Como soluciono ?