Re: Problem on PG7.2.2

Roberto Fichera <kernel@tekno-soft.it> writes:
> database=# select count(*) from detail;
>   count
> --------
>   181661
> (1 row)

> database=# select count(*) from detail;
>   count
> --------
>   181660
> (1 row)

> database=# select count(*) from detail;
> FATAL 2:  open of /var/lib/pgsql/data/pg_clog/0303 failed: No such file or 
> directory

[ blinks... ]  That's with no one else modifying the table meanwhile?

I think you've got *serious* hardware problems.  Hard to tell if it's
disk or memory, but get out those diagnostic programs now ...
        regards, tom lane