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

>>> On Mon, Jul 9, 2007 at 11:36 AM, in message <23173.1183999016@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> 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.  Eyeing the
> script, the only obvious thing that could block it is existence of
> /var/pgsql/data/county/$countyName/wal-files/rsync-in-progress
Sorry for the noise.  It wasn't the rsync file but something even more
obvious that I managed misread.  The rsync was failing to copy the files
from the counties to the directory where recovery reads them.  I could have
sworn I checked that, but I clearly messed up.
-Kevin