Porwal, Utkarsh wrote: >>> At a customer environment we found an issue where insertion to a >>> particular table fails with errors like >>> >>> ERROR: invalid page header in block 9757828 of relation >>> base/2403282/2403731 >> On further investigation, it is found that the issue with inserts is with table A. However the error >> of blocks point to a pg_toast table associated with Table A (this has been confirmed). >> >> Also, from the errors I see that a total of 70 blocks are complaining about errors and block size is >> 8KB. >> >> Any advise to take it further? I was thinking of reindexing the toast table but it doesn't have a >> index . Also I fail to understand why inserts will have a problem since it will write to a new >> location. > Anyone?? An INSERT in a database table is not an append to a file. If your toast table is corrupted and you don't have a backup, your best bet is to salvage all the data you can by selectively dumping as much of the table as possible. Expect data loss. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
