> On Wed, Oct 29, 2008 at 7:24 PM, Scott Marlowe <[EMAIL PROTECTED]>
> wrote:
>
> Oh, and to reply to myself and the original poster, you need to figure
> out what's causing the pages to get damaged. IT's usually bad
> hardware, then a buggy driver, then a buggy kernel / OS that can cause
> it. R
> On Wed, Oct 29, 2008 at 6:36 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>>> On Wed, Oct 29, 2008 at 4:23 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
If you can tolerate losing the data on that page, just zero out the
entire 8K page. dd from /dev/
On Wed, Oct 29, 2008 at 7:24 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Oh, and to reply to myself and the original poster, you need to figure
out what's causing the pages to get damaged. IT's usually bad
hardware, then a buggy driver, then a buggy kernel / OS that can cause
it. Run lots of te
On Wed, Oct 29, 2008 at 6:36 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>> On Wed, Oct 29, 2008 at 4:23 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> If you can tolerate losing the data on that page, just zero out the
>>> entire 8K page. dd from /dev/zero i
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Wed, Oct 29, 2008 at 4:23 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> If you can tolerate losing the data on that page, just zero out the
>> entire 8K page. dd from /dev/zero is the usual tool.
> Would zero_damaged_pages work here? I know it's a sh
On Wed, Oct 29, 2008 at 4:23 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] writes:
>> There is a way to 'correct' or blank the values somehow? I guess im going
>> to lose some data, iisnt...
>
> If you can tolerate losing the data on that page, just zero out the
> entire 8K page. dd
[EMAIL PROTECTED] writes:
> There is a way to 'correct' or blank the values somehow? I guess im going
> to lose some data, iisnt...
If you can tolerate losing the data on that page, just zero out the
entire 8K page. dd from /dev/zero is the usual tool.
regards, tom lane
Hi all. I've seen this searching in google. After a select on a table, i
got this:
ERROR: invalid page header in block 399 of relation "xxx"
I read about a tool called pg_filedump, and after some searchs about its
usage, i execute
pg_filedump $PG_DATA/base/xx/1234 (1234 is the oid of table xxx)
A
