Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 30 Jul 2009 17:59:08 -0400
- Message-id: <4593.1248991148@sss.pgh.pa.us> <text/plain>
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
- References:
- Fix corrupt pg_toast table?
- From: Michael Clark
- Fix corrupt pg_toast table?
- Prev by Date: Fix corrupt pg_toast table?
- Next by Date: Point in Time Recovery (WAL) archive_command
- Previous by thread: Fix corrupt pg_toast table?
- Next by thread: Re: Fix corrupt pg_toast table?
- Indexes: