Re: Hot standby stops after a few days of inactivity (i.e. no new WAL)

Marc Schablewski <ms@clickware.de> writes:
> ... When looking for a reason why the WAL weren't shipped, we found
> the following error message:

> 2008-10-31 17:07:52 CET 9162LOG:  received smart shutdown request
> 2008-10-31 17:07:52 CET 9178FATAL:  could not restore file
> "000000010000008600000018" from archive: return code 15

Something sent SIGTERM to both your postmaster (hence the "smart
shutdown" message) and the recovery_command script (causing it to
exit with code 15, which is probably SIGTERM though you might want
to check kill -l to be sure).  You need to find out what's doing that
and make it stop.

            regards, tom lane