Re: Server continuously enters to recovery mode.

Try dumping the database, you might have a damaged table as in this case:

http://www.postgresql.org/message-id/CAGWYGjWPiffET_K6QVXjjQO_jRQiUEU+BSZr1hurrh1Obv8wyQ@mail.gmail.com

good luck.

2014-05-03 18:59 GMT-05:00 David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)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(at)postgresql(dot)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/