Re: Error stranger - Mailing list pgsql-general

From Diego Schulz
Subject Re: Error stranger
Date
Msg-id [email protected]
Whole thread Raw
In response to Error stranger  (paulo matadr <[email protected]>)
List pgsql-general
On Mon, Apr 20, 2009 at 9:25 AM, paulo matadr <[email protected]> wrote:
> I get  this error when make a select below
>
> "SELECT * FROM batch.funcionalidade_iniciada  where proi_id = x"
>
> ERROR: missing chunk number 0 for toast value 458755
> SQL state: XX000


Looks like your database repository is corrupted and/or your disk is failing.

I'd suggest you to

1) look at the logs for error messages
2) fix hardware problems (if any)
3) if you don't have UPS, buy one
4) restore your database from last backup



regards,

diego

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: DISTINCT ON without ORDER BY
Next
From: Alvaro Herrera
Date:
Subject: Re: This is my first template