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

"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.  Eyeing the
script, the only obvious thing that could block it is existence of
/var/pgsql/data/county/$countyName/wal-files/rsync-in-progress 
        regards, tom lane