Re: [GENERAL] Server continuously enters to recovery mode.

2014-05-05 Thread DrakoRod
Hi everybody Thank you for your help! I upgrade the version of 9.0.15 to 9.0.17. But after that constantly show this error, in all sessions: *WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll ba

Re: [GENERAL] Server continuously enters to recovery mode.

2014-05-04 Thread Adrian Klaver
On 05/03/2014 04:29 PM, 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 fil

Re: [GENERAL] Server continuously enters to recovery mode.

2014-05-03 Thread Rene Romero Benavides
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 : > DrakoRod wrote > > Hi everybody! > > > > I have a problem

[GENERAL] Server continuously enters to recovery mode.

2014-05-03 Thread DrakoRod
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=/d

Re: [GENERAL] Server continuously enters to recovery mode.

2014-05-03 Thread David G Johnston
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 di