> Hi everybody! > > I have a problem (really huge problem), I have one server of production, > but yesterday in the night I saw this error: > > * > ERROR: could not access status of transaction 2410303155 > DETAIL: Could not open file "pg_clog/08FA": No such file or directory * > > Solution: > * > dd if=/dev/zero/ of=data/pg_clog/08FA bs=256K count=1 * > > > So I ran this solutions, no problem so far, but then (after 1 or 2 hours > approximately), the server crash, I think somebody did something but did > not tell me, no one did nothing! cool!! ¬¬. I started the server and this > began in recovery mode, he started. But after some time (without apparent > pattern), the server came into the recovery mode again. > > After that, the server continuously entering recovery mode, like I said > without apparent pattern, between 3, 5 or 10 minutes run normally but then > enter in the recovery mode again. I restart the server (began in recovery > mode again), started, but after sometime he enter in recovery mode again. > > Try to recover the server with the PITR and nothing. The server version is > 9.0.x in a Linux SUSE. The database size is the 336 GB. > > Please give me any help to recover the server!
> > Thanks!
The only help I'm good for on this topic is to tell you to supply log file data; especially those entries at and just before the server enters recovery mode.