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

On 09/04/12 7:09 PM, Aleksey Tsalolikhin wrote:
> BTW, after I signalled TERM, the process status changed from
>
> notify interrupt waiting
>
> to
>
> notify interrupt waiting waiting
>
> which I thought looked kind of odd.
>
> Then I signalled KILL.

was this a client process or a postgres process?   kill -9 on postgres
processes can easily trigger data corruption.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast