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

On 09/05/2012 12:21 PM, John R Pierce wrote:
> was this a client process or a postgres process?   kill -9 on postgres
> processes can easily trigger data corruption.

It certainly shouldn't.

kill -9 of the postmaster, deletion of postmaster.pid, and re-starting
postgresql *might* but AFAIK even then you'll have to bypass the shared
memory lockout (unless you're on Windows).

--
Craig Ringer