>>> 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 "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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to