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

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres process got stuck in "notify interrupt waiting" status
Date: 2012-09-05 09:27:39
Message-ID: 50471B0B.8030401@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2012-09-05 09:40:17 Re: "Too far out of the mainstream"
Previous Message Ivan Sergio Borgonovo 2012-09-05 08:51:49 Re: "Too far out of the mainstream"