Re: walreceiver termination - Mailing list pgsql-general

From Tom Lane
Subject Re: walreceiver termination
Date
Msg-id 18350.1587664068@sss.pgh.pa.us
Whole thread Raw
In response to walreceiver termination  (Justin King <kingpin867@gmail.com>)
Responses Re: walreceiver termination
List 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 by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: Reg: Help to understand the source code
Next
From: "David G. Johnston"
Date:
Subject: Re: Could Not Connect To Server