Corrupt table, is zero_damaged_pages available in v7.2? - Mailing list pgsql-admin

From Eric Comeau
Subject Corrupt table, is zero_damaged_pages available in v7.2?
Date
Msg-id dbqt18$2n4o$1@news.hub.org
Whole thread Raw
List 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



pgsql-admin by date:

Previous
From: Jiang Ma
Date:
Subject: help! I can not start postgreSQL service!
Next
From: Tsirkin Evgeny
Date:
Subject: postgresql array with perl