Re: postgres crash SOS - Mailing list pgsql-general

From Merlin Moncure
Subject Re: postgres crash SOS
Date
Msg-id AANLkTikYigoJppgFncDo74pEmVFxeYmPtq94n1if8_Cz@mail.gmail.com
Whole thread Raw
In response to postgres crash SOS  (Felde Norbert <fenor77@gmail.com>)
List 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 by date:

Previous
From: Bryan Montgomery
Date:
Subject: Question about indexes on tables with inherited children
Next
From: Dennis Gearon
Date:
Subject: world meaningful date time input