DB error recovery
DB error recovery
От:
Werner Bohl <wbohl@deepdata.com>
Дата:
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 Infutor de Costa Rica