[GENERAL] missing chunk number 497 for toast value 504723663

2010-09-16 Thread Utsav Turray
these records. Is there any other way to resolve this issue as deleting the records will lead to loss of information and the backup I am having also consists of corrupted records. Secondly what are probable reasons behind corruption and what can we do to prevent this error. Thanks An

[GENERAL] Cannot read block 348938 of pdbsynchtable

2010-04-08 Thread Utsav Turray
Dear All , I am using postgres 7.3. on RHEL 4.0 If I do any operation(select , delete , count , update , vacuum,reindex) on a table ; the error comes "Cannot read block 348938 of pdbsynchtable" Given below is the o/p of the files corresponding to the table -rw--- 1 postgres postgres 107