X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C693E329E7B for ; Tue, 28 Sep 2004 00:36:05 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85731-08 for ; Mon, 27 Sep 2004 23:36:01 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.198]) by svr1.postgresql.org (Postfix) with ESMTP id 2EB7032A040 for ; Tue, 28 Sep 2004 00:36:03 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so2694632rnk for ; Mon, 27 Sep 2004 16:36:03 -0700 (PDT) Received: by 10.38.88.53 with SMTP id l53mr233989rnb; Mon, 27 Sep 2004 16:36:02 -0700 (PDT) Received: by 10.38.76.43 with HTTP; Mon, 27 Sep 2004 16:36:02 -0700 (PDT) Message-ID: <37d451f7040927163636c9f64c@mail.gmail.com> Date: Mon, 27 Sep 2004 18:36:02 -0500 From: Rosser Schwarz Reply-To: Rosser Schwarz To: Qing Zhao Subject: Re: killing a hung postgres process brings down the Postgres database server on MAC OS X! Cc: pgsql-admin@postgresql.org, Kai Mildenberger In-Reply-To: <6D0568B0-10D9-11D9-8F83-000A95AB8896@supplyfx.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <6D0568B0-10D9-11D9-8F83-000A95AB8896@supplyfx.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/261 X-Sequence-Number: 14964 while you weren't looking, Qing Zhao wrote: [...] > Is there a way to kill the dead processes/thread without really affect > the PG server? See: http://www.postgresql.org/docs/7.3/static/postmaster-shutdown.html I have occasionally had to kill -9 a backend, but it's never been pleasant. Avoid if at all possible. /rls -- :wq