Re: walreceiver termination

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: walreceiver termination
Дата
Msg-id 18350.1587664068@sss.pgh.pa.us
обсуждение исходный текст
Ответ на walreceiver termination  (Justin King <kingpin867@gmail.com>)
Ответы Re: walreceiver termination
Список pgsql-general
Justin King <kingpin867@gmail.com> writes:
> We've seen unexpected termination of the WAL receiver process.  This
> stops streaming replication, but the replica stays available --
> restarting the server resumes streaming replication where it left off.
> We've seen this across nearly every recent version of PG, (9.4, 9.5,
> 11.x, 12.x) -- anything omitted is one we haven't used.

> I don't have an explanation for the cause, but I was able to set
> logging to "debug5" and run an strace of the walrecevier PID when it
> eventually happened.  It appears as if the SIGTERM is coming from the
> "postgres: startup" process.

The startup process intentionally SIGTERMs the walreceiver under
various circumstances, so I'm not sure that there's any surprise
here.  Have you checked the postmaster log?

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: Paul Jungwirth
Дата:
Сообщение: Re: Reg: Help to understand the source code
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Could Not Connect To Server