Thread: DB error recovery

DB error recovery

From
Werner Bohl
Date:
Hi,

We have a big postgresql 7.4.2 db on RedHat 8.0. Data resides in a SCSI
RAID partition.

Problem: SCSI RAID card (LSI 160 Express) was substituted with a LSI
1600 Enterprise. Same make, using same low-level drivers. After the card
switch a query to one of our tables returns:

ERROR:  could not access status of transaction 542458188
DETAIL:  could not open file "/db/pgdata/pg_clog/0205": No such file or
directory

Is there any work-around, or fast fix for this error as restoring data
takes more than 2 days.


TIA,
--
Werner Bohl <wbohl@deepdata.com>
Infutor de Costa Rica