DB error recovery

Поиск
Список
Период
Сортировка
От Werner Bohl
Тема DB error recovery
Дата
Msg-id 1089236631.3467.4.camel@sirio
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Rosser Schwarz
Дата:
Сообщение: Re: [PERFORM] finding a max value
Следующее
От: Daniel Rubio
Дата:
Сообщение: Re: Upgrade problems with OID type ...