Try dumping the database, you might have a damaged table as in this case: http://www.postgresql.org/message-id/cagwygjwpiffet_k6qvxjjqo_jrqiueu+bszr1hurrh1obv8...@mail.gmail.com
good luck. 2014-05-03 18:59 GMT-05:00 David G Johnston <david.g.johns...@gmail.com>: > DrakoRod wrote > > 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. > > Good Luck! > > David J. > > > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Server-continuously-enters-to-recovery-mode-tp5802321p5802322.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- El genio es 1% inspiración y 99% transpiración. Thomas Alva Edison http://pglearn.blogspot.mx/
