Re: ERROR: could not access status of transaction 2495690984

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: ERROR: could not access status of transaction 2495690984
Дата
Msg-id b42b73150907211232h50ba4099k1c8d0d5885640952@mail.gmail.com
обсуждение исходный текст
Ответ на ERROR: could not access status of transaction 2495690984  (Bjørn T Johansen <btj@havleik.no>)
Ответы Re: ERROR: could not access status of transaction 2495690984
Re: ERROR: could not access status of transaction 2495690984
Список pgsql-general
2009/7/21 Bjørn T Johansen <btj@havleik.no>:
> I have had som problem with my filesystem and now I get these error messsages when trying to access my database..:
>
> ERROR:  could not access status of transaction 2495690984
> Could not open file "pg_clog/094C": No such file or directory.

got backups?

One way to suppress this error, but not fix the underlying corruption,
is to generate clog files that the database thinks should be there.
Make a 256k file filled with 0x55 and put it where the database is
expecting.

merlin

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: suggestion: log_statement = sample
Следующее
От: Janning Vygen
Дата:
Сообщение: Re: suggestion: log_statement = sample