Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Marc Schablewski <ms@xxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux