>>> 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. -Kevin
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster