Re: Fix corrupt pg_toast table?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Clark <codingninja(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Fix corrupt pg_toast table?
Date: 2009-07-30 21:59:08
Message-ID: 4593.1248991148@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Michael Clark <codingninja(at)gmail(dot)com> writes:
> I have a database which appears to have some corruption in a toast value.

> When I select a certain table, I get the following error:
> ERROR: invalid page header in block 984 of relation "pg_toast_17341_index"

If it's only that index that has gotten damaged, REINDEX will fix it, eg
reindex index pg_toast.pg_toast_17341_index;

The bigger concern is whether there is other damage. Have you had any
system crashes, indications of flaky hardware, etc on that machine?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ml ml 2009-07-31 06:34:56 Point in Time Recovery (WAL) archive_command
Previous Message Michael Clark 2009-07-30 21:48:08 Fix corrupt pg_toast table?