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

On Mon, 2007-07-09 at 12:36 -0400, Tom Lane wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> > [2007-07-07 18:24:27.692 CDT] 5962 LOG:  restored log file "000000010000000=
> > C000000DA" from archive
> > [2007-07-07 18:24:28.051 CDT] 5962 LOG:  restored log file "000000010000000=
> > C000000DB" from archive
> > [2007-07-09 08:21:50.200 CDT] 5904 LOG:  received fast shutdown request
> > [2007-07-09 08:21:50.201 CDT] 5962 FATAL:  could not restore file "00000001=
> > 0000000C000000DC" from archive: return code 15
> 
> Evidently it was waiting for the restore_command script to give it back
> a file.  So the problem is within your restore script.

Agreed.

Kevin, Can you try pg_standby please? It would help me to diagnose
problems faster if that doesn't work. TIA.

--  Simon Riggs EnterpriseDB  http://www.enterprisedb.com