DB error recovery - Mailing list pgsql-admin

From Werner Bohl
Subject DB error recovery
Date
Msg-id 1089236631.3467.4.camel@sirio
Whole thread Raw
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Rosser Schwarz
Date:
Subject: Re: [PERFORM] finding a max value
Next
From: Daniel Rubio
Date:
Subject: Re: Upgrade problems with OID type ...