Re: can you have any idea about toast missing chunk issu resolution

On 01/15/2015 04:30 AM, M Tarkeshwar Rao wrote:
> Hi all,
>
> We are getting following error message on doing any action on the table
> like(Select or open from pgadmin).
>
> Please suggest.
>
> ERROR:  missing chunk number 0 for toast value 54787 in pg_toast_2619
>
> ********** Error **********
>
> ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
>
> SQL state: XX000
>


We've been down this path before:

http://www.postgresql.org/message-id/1C16813DAFF3E44B939586605D40E9F011737C1B@ESESSMB107.ericsson.se

and it was never resolved for lack of information. So:

1) Per Tom, what version of Postgres?

2) What OS and version?

3) General hardware specifications.

>
> Regards
>
> Tarkeshwar
>


--
Adrian Klaver
adrian.klaver@aklaver.com