Re: Error stranger - Mailing list pgsql-general

From Diego Schulz
Subject Re: Error stranger
Date
Msg-id 47dcfe400904210626m34d4a040xa5bca7d56c47e911@mail.gmail.com
Whole thread Raw
In response to Error stranger  (paulo matadr <saddoness@yahoo.com.br>)
List pgsql-general
On Mon, Apr 20, 2009 at 9:25 AM, paulo matadr <saddoness@yahoo.com.br> 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