Re: postgres process got stuck in "notify interrupt waiting" status - Mailing list pgsql-general

From Kevin Grittner
Subject Re: postgres process got stuck in "notify interrupt waiting" status
Date
Msg-id 504729990200002500049EAA@gw.wicourts.gov
Whole thread Raw
In response to Re: postgres process got stuck in "notify interrupt waiting" status  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Responses Re: postgres process got stuck in "notify interrupt waiting" status
List pgsql-general
Aleksey Tsalolikhin <atsaloli.tech@gmail.com> wrote:

> Why will it kill all your other sessions too?  Isn't there a
> separate backend process for each session?

When stopped that abruptly, the process has no chance to clean up
its pending state in shared memory.  A fresh copy of shared memory
is needed, so it is necessary to effectively do an immediate restart
on the whole PostgreSQL instance.

-Kevin


pgsql-general by date:

Previous
From: Johan Nel
Date:
Subject: Re: alter view, add/drop column
Next
From: Tom Lane
Date:
Subject: Re: postgres process got stuck in "notify interrupt waiting" status