Re: postgres process got stuck in "notify interrupt waiting" status

Aleksey Tsalolikhin <atsaloli.tech@gmail.com> writes:
> So how about that this process that was in "notify interrupt waiting
> waiting" status after I SIGTERM'ed it.  Is the double "waiting"
> expected?

That sounded a bit fishy to me too.  But unless you can reproduce it in
something newer than 8.4.x, nobody's likely to take much of an interest.
The LISTEN/NOTIFY infrastructure got completely rewritten in 9.0, so
any bugs in the legacy version are probably just going to get benign
neglect at this point ... especially if we don't know how to reproduce
them.

            regards, tom lane