Postgres Pro
Downloads
Home   >   mailing lists

FATAL 2: (pg_clog ... no such file or directory) - Mailing list pgsql-admin

From kaolin fire
Subject FATAL 2: (pg_clog ... no such file or directory)
Date
Msg-id 4536F22E-58CB-11D8-ABC6-000A957FF036@tentacle.net
Whole thread Raw
In response to Advice on multi-machine high-reliability setup?  (postgresql@phreaker.net)
Responses Re: FATAL 2: (pg_clog ... no such file or directory)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Shane Wright
Date:
Subject: Re: hanging for 30sec when checkpointing
Next
From: Tom Lane
Date:
Subject: Re: hanging for 30sec when checkpointing