>>> On Mon, Jul 9, 2007 at 11:36 AM, in message <23173(dot)1183999016(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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