Re: vacuum error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric Cholet <cholet(at)logilune(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum error
Date: 2003-03-12 16:40:39
Message-ID: 27440.1047487239@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Eric Cholet <cholet(at)logilune(dot)com> writes:
> I get this error when vacuuming a table:
> PANIC: open of /usr/local/pgsql/data/pg_clog/0005 failed: No such file
> or directory
> using 7.3.2.
>>
>> What file names are actually present in pg_clog/ ?

> 0000 0001 0002 0003 0004

Hm, interesting. You had any crashes recently? Could you show us an
"ls -l" listing of those clog files (I want to know their sizes and
mod dates...)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gabriel Fernandez 2003-03-12 16:40:55 UNSUBSCRIBE gabi@unica.edu
Previous Message Eric Cholet 2003-03-12 16:36:21 Re: vacuum error