Re: unable to dump database, toast errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lonni J Friedman <lfriedman(at)vasoftware(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unable to dump database, toast errors
Date: 2003-04-03 20:24:42
Message-ID: 12865.1049401482@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lonni J Friedman <lfriedman(at)vasoftware(dot)com> writes:
> Do you mean the fields/rows in pg_toast_302323 or artifact_file ?

The ones in artifact_file.

> How
> would i determine which ones reference broken toast entries?

If you get the toast error when you try to read the field's value, then
it's broken ...

You may find yourself doing things like "select * from artifact_file
limit N" to try to narrow down which rows contain broken values. If so,
keep in mind that (in 7.2) LIMIT will read one more row than it returns;
so if you can select N rows but not N+1 rows, the problem is actually in
row N+2.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-03 20:26:57 Re: pgsql password when FreeBSD boots -- what's usual?
Previous Message Marc Drouin 2003-04-03 20:20:03 Re: Newbie: problem Connecting to Server