Re: Proposed toast info extraction function for disaster

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)surnet(dot)cl>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposed toast info extraction function for disaster
Date: 2005-06-11 12:47:31
Message-ID: 42AADD63.80708@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Hmm. Maybe we need something more like a "lint check" for tables, ie
> run through and look for visibly corrupt data, such as obviously
> impossible lengths for varlena fields.

> Come to think of it, didn't someone already write something close to
> this a few years ago?

Sounds like pgfsck:

http://svana.org/kleptog/pgsql/pgfsck.html

Unfortunately it doesn't seem to have been updated to work with recent
versions of PG (> 7.3)

-Neil

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2005-06-11 13:27:41 Re: The Contrib Roundup (long)
Previous Message Hugo 2005-06-11 12:44:32 how to return a result set from a stored procedure