FATAL 2: (pg_clog ... no such file or directory)

From: kaolin fire <cognosco(at)tentacle(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: FATAL 2: (pg_clog ... no such file or directory)
Date: 2004-02-06 17:38:27
Message-ID: 4536F22E-58CB-11D8-ABC6-000A957FF036@tentacle.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Where would I go to start tracking down recurring error messages of the
sort:

FATAL 2: open of /usr/local/pgsql/data/pg_clog/06F7 failed: No such
file or directory
FATAL 2: open of /usr/local/pgsql/data/pg_clog/0707 failed: No such
file or directory

06F7 and 0707 do not exist. Currently just looks like it goes from
0000 (May 14 2002) to 004F (Feb 6 2004, and counting).

I'm running 7.2.4

-kaolin fire

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Naomi Walker 2004-02-06 18:34:18 Recycled Log Files
Previous Message Tom Lane 2004-02-06 17:34:47 Re: hanging for 30sec when checkpointing