Re: postgres crash SOS

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: postgres crash SOS
Дата
Msg-id AANLkTikYigoJppgFncDo74pEmVFxeYmPtq94n1if8_Cz@mail.gmail.com
обсуждение исходный текст
Ответ на postgres crash SOS  (Felde Norbert <fenor77@gmail.com>)
Список pgsql-general
On Wed, Jun 16, 2010 at 7:55 PM, Felde Norbert <fenor77@gmail.com> wrote:
> Hi all,
>
> I use 8.2 on a windows server 2008.
> Suddenly postgres crashed and I can not do anything. The message is
> Could not access status of transaction 3982736.
> DATAIL: Could not read from file "pg_clog/0003" at offset 204800: No error.
>
> The only one thing I found to correct this is to create a file filled
> with binary 0 and replace clog/0003. Both files size are the same. I

that was probably not the right thing to do -- did you save off the
orgiinal file?

merlin

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

Предыдущее
От: Bryan Montgomery
Дата:
Сообщение: Question about indexes on tables with inherited children
Следующее
От: Dennis Gearon
Дата:
Сообщение: world meaningful date time input