Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BF1A22E0031 for ; Thu, 27 Mar 2008 18:59:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53742-04 for ; Thu, 27 Mar 2008 18:59:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id 534622E0039 for ; Thu, 27 Mar 2008 18:59:07 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so5029136waf.5 for ; Thu, 27 Mar 2008 14:59:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=QLzh3JeWwEvEeAaDIMVpV9LxfH0/YmtBg2TlqKLts2E=; b=tWSlyzvccGWRKLahNQZuNK8csp9DuVktWa220JvJSpkyD/VA9TrolumABfnOf9p0n2VeP+Xnl9Ly3iQPibWGO4kBFuAW2GG7PdT9GLC5zoVX9TzK6MyRXj8jFeqG9qUNPsc1DMqRXUdGpqzMxuDzkRzpng3m435vJ62MqD3rKGs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Kh59xcWX3ZQPEa0JfB8fmDRXoz1J2ZUAATo2n96+nOiW2gfkoszOIdklt1/LAp5BnEzcjgbDT9vXMWMWF8d84ON46+gRuTGhxAcUEPZV4EkNHXr0AWD8CzV4XahvKI4KGCeJGw7ft9jmm0YNB8HV8g/Je/kS8IF/MxTH2z54brw= Received: by 10.114.146.1 with SMTP id t1mr2579096wad.20.1206655145780; Thu, 27 Mar 2008 14:59:05 -0700 (PDT) Received: by 10.114.199.20 with HTTP; Thu, 27 Mar 2008 14:59:05 -0700 (PDT) Message-ID: <4544e0330803271459j5f59e453lc5081bbe43689729@mail.gmail.com> Date: Thu, 27 Mar 2008 16:59:05 -0500 From: "Peter Koczan" To: "Tena Sakai" Subject: Re: it refuses to go down... Cc: "Scott Marlowe" , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4544e0330803251059v57938d71q68e41cacda057160@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/230 X-Sequence-Number: 28713 > > I had to deal with this recently where the > > status was "notify interrupt" > > Is this a response from "pg_ctl status" command? I'm referring to the last field of "ps ax". For instance, this line... > 13841 ? Rs 234:32 postgres: gadb canon 127.0.0.1(44837) SELECT would have "notify interrupt" instead of "SELECT". That's the status I'm referring to. Peter