At 10.40 23/09/02 -0400, Tom Lane wrote:
>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?
This table is used to hold all the logs from our Radius servers,
so we have only INSERT from the radiusd server.
>I think you've got *serious* hardware problems. Hard to tell if it's
>disk or memory, but get out those diagnostic programs now ...
What diagnostic programs do you suggest ?
Roberto Fichera.