At 10.40 23/09/02 -0400, Tom Lane wrote: >Roberto Fichera <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]