Re: HELP: pg_clog file not found error - Mailing list pgsql-general

From Tom Lane
Subject Re: HELP: pg_clog file not found error
Date
Msg-id 19976.1048132835@sss.pgh.pa.us
Whole thread Raw
In response to HELP: pg_clog file not found error  (<terry@ashtonwoodshomes.com>)
List pgsql-general
<terry@ashtonwoodshomes.com> writes:
> When my server is under heavy load I sometimes get this error (see below),
> and the backend restarts.

> FATAL 2:  open of /usr/local/pgsql/data/pg_clog/0522 failed: No such file or
> directory

Is it repeatable --- that is, do you see it again if you run a VACUUM
afterwards?

If not, I'd have to speculate that you have bad RAM (or less likely, a
bad disk controller).  Get out those hardware diagnostics ...

            regards, tom lane

pgsql-general by date:

Previous
From: James Gregory
Date:
Subject: trigger troubles
Next
From: Stephan Szabo
Date:
Subject: Re: trigger troubles