Re: 8.3.5 broken after power fail - Mailing list pgsql-admin

From Michael Monnerie
Subject Re: 8.3.5 broken after power fail
Date
Msg-id 8ce5a7cbfc90bac3f52c2dda013872c4@webmail.zmi.at
Whole thread Raw
In response to 8.3.5 broken after power fail  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Responses Re: 8.3.5 broken after power fail  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
"Michael Monnerie" <michael.monnerie@is.it-management.at> schrieb:
> pg_dump: Fehlermeldung vom Server: ERROR:  missing chunk number 0 for
> toast value 1460201 in pg_toast_1281127
> pg_dump: Die Anweisung war: COPY public.dbmail_messageblks
> (messageblk_idnr, physmessage_id, messageblk, blocksize, is_header) TO
> stdout;

The file is there:
# ls -l base/16386/1281127
-rw------- 1 postgres postgres 417447936 17. Feb 12:14 base/16386/1281127

What can I do about the missing chunk? I need the data in there...

mfg zmi



pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: Re: CREATE TABLE docs question
Next
From: Achilleas Mantzios
Date:
Subject: Re: 8.3.5 broken after power fail