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 0FC0132A041 for ; Tue, 28 Sep 2004 00:40:20 +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 86608-09 for ; Mon, 27 Sep 2004 23:40:15 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6636832A040 for ; Tue, 28 Sep 2004 00:40:18 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i8RNeIvw008161; Mon, 27 Sep 2004 19:40:18 -0400 (EDT) To: Qing Zhao Cc: pgsql-admin@postgresql.org, Kai Mildenberger Subject: Re: killing a hung postgres process brings down the Postgres database server on MAC OS X! In-reply-to: <6D0568B0-10D9-11D9-8F83-000A95AB8896@supplyfx.com> References: <6D0568B0-10D9-11D9-8F83-000A95AB8896@supplyfx.com> Comments: In-reply-to Qing Zhao message dated "Mon, 27 Sep 2004 16:03:20 -0700" Date: Mon, 27 Sep 2004 19:40:18 -0400 Message-ID: <8160.1096328418@sss.pgh.pa.us> From: Tom Lane 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/262 X-Sequence-Number: 14965 Qing Zhao writes: > If we do "kill -9 pid" to get rid of the deserted process, it bring > down the PG database server entirely. It's supposed to. > Is there a way to kill the dead processes/thread without really affect > the PG server? It will time out by itself eventually (order of a couple hours probably --- it depends on your TCP stack). You can try a SIGINT or SIGTERM. SIGINT is safe but may or may not cause the backend to quit. SIGTERM will make it quit, but I'm not prepared to guarantee that SIGTERM won't have bad side effects. I'd suggest waiting... regards, tom lane