DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.

Поиск
Список
Период
Сортировка
От Olga Vingurt
Тема DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.
Дата
Msg-id A305A29309C1274FAA7A0FED4F1F75666EBFF0B313@il-ex01.ad.checkpoint.com
обсуждение исходный текст
Ответы Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error.  (raghu ram <raghuchennuru@gmail.com>)
Список pgsql-general
Дерево обсуждения

Hi,

 

We are using PostgreSQL 8.3 on Windows Server.

The db crashed and now it fails to start up.

 

The error is:

FATAL:  could not access status of transaction 4020264

DETAIL:  Could not read from file "pg_clog/0003" at offset 212992: No error.

 

Additional log from event viewer:

LOG:  database system was interrupted; last known up at 2012-07-12 11:35:00 CEST

 

 

How can we recover from the current state?

 

Thanks,

Olga

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)
Следующее
От: Nicolau Roca
Дата:
Сообщение: Replication terminated by primary server