Re: Proposed toast info extraction function for disaster recovery

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Proposed toast info extraction function for disaster recovery
Date: 2005-06-08 00:13:32
Message-ID: 20050608001332.GB7407@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 07, 2005 at 05:48:31PM -0400, Tom Lane wrote:

> Comments? Anyone else ever wished they had this?

Hmm. There's another problem which shows up when the server throws an
error about an invalid allocation request. This also happens when a
varlena field is corrupted, but you don't have the toast id because the
error message doesn't say.

I guess one way to solve it would be to add errcontext() calls within
toast realms.

Now that I think about it, maybe my problem is not related to TOAST at
all, but to a corrupted varlena field. So if the corruption does not
involve toasting, I'm in the same position as before, i.e. I haven't
found out what is the corrupted tuple.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-06-08 01:04:14 Re: Request for support for GIST enhancements
Previous Message Andrew - Supernews 2005-06-08 00:08:38 Re: Visibility issue with pg_table_is_visible