Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Kevin Grittner
>>> On Mon, Jul 9, 2007 at 11:36 AM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: >> [2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file "0001000= >> C00DA" from archive >> [2007-07-07 18:24:28.051 CDT] 5962 L

Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Simon Riggs
On Mon, 2007-07-09 at 12:36 -0400, Tom Lane wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: > > [2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file "0001000= > > C00DA" from archive > > [2007-07-07 18:24:28.051 CDT] 5962 LOG: restored log file "0001000= > > C00

Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Kevin Grittner
>>> On Mon, Jul 9, 2007 at 10:54 AM, in message <[EMAIL PROTECTED]>, "Kevin Grittner" <[EMAIL PROTECTED]> wrote: > We're running a number of warm standby instances on one server. One of them > stalled on Saturday. When I found that this morning, I confirmed that the > files were in the directo

Re: [HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > [2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file "0001000= > C00DA" from archive > [2007-07-07 18:24:28.051 CDT] 5962 LOG: restored log file "0001000= > C00DB" from archive > [2007-07-09 08:21:50.200 CDT] 5904 LOG: r

[HACKERS] Warm standby stall -- what debug info would help?

2007-07-09 Thread Kevin Grittner
We're running a number of warm standby instances on one server. One of them stalled on Saturday. When I found that this morning, I confirmed that the files were in the directory from which it should be pulling the WAL files. The logs showed normal processing up to the stall, with no messages