Re: Proposed toast info extraction function for disaster - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Proposed toast info extraction function for disaster
Date
Msg-id 42AADD63.80708@samurai.com
Whole thread Raw
In response to Re: Proposed toast info extraction function for disaster recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Request for Comments: ALTER [OBJECT] SET SCHEMA
Next
From: Jan Wieck
Date:
Subject: Re: The Contrib Roundup (long)