Re: More along the lines of "WEIRD CRASH?!?!"? - Mailing list pgsql-admin

From Tom Lane
Subject Re: More along the lines of "WEIRD CRASH?!?!"?
Date
Msg-id 29977.1048012991@sss.pgh.pa.us
Whole thread Raw
In response to More along the lines of "WEIRD CRASH?!?!"?  (Murthy Kambhampaty <murthy.kambhampaty@goeci.com>)
List pgsql-admin
Murthy Kambhampaty <murthy.kambhampaty@goeci.com> writes:
> Mar 18 12:33:45 c257lx postgres[25277]: [7] PANIC:  open of
> /home/db/pgsql/data/pg_clog/0406 failed: No such file o
> r directory

> This always happens several passes into a loop (second or third with default
> shared memory settings, much later with with 4096 shared buffers and 32
> checkpoint segments).

Is it always complaining of the same pg_clog file name?  Are you getting
rid of the corruption between tries (eg with initdb), or is it just that
you keep hitting the same pre-existing corrupted data?

            regards, tom lane

pgsql-admin by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: More along the lines of "WEIRD CRASH?!?!"?
Next
From: "Jason M. Kuhlman"
Date:
Subject: MS SQL 2K replication/backup