Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id CEFA42E2EFE for ; Fri, 30 Nov 2007 17:17:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 91821-10 for ; Fri, 30 Nov 2007 17:17:08 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id 66A732E033A for ; Fri, 30 Nov 2007 17:17:10 -0400 (AST) Received: by py-out-1112.google.com with SMTP id u77so5246444pyb for ; Fri, 30 Nov 2007 13:17:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; 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=wGieb3N1LsPWQrmOel03yRncaC7NwpsjOa0hVYNv8qA=; b=jOmAg6KJaFuamU/qmYeHfxtFwRbBFjW6HKPUk6yb0lYmr3Dwjkag8pU4WdxbHwU53CCLwPIlgjb92zZINtAVGgzTU6aflpWtXhepaYjaBsu1mcz19f9qJgRrojGrxnR+SrUdU9LAYEZR0OSU5qqg+sbq2N7bbkP1nmUo5FeaR80= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=TIv2ofTMYL6ti77Vesj0JxrbTabaL22f5jxCTo/PzibUHwNo0FrPjIJD5e5oFKC/KK1rBedkPET6Zg/ZBmN8F07klBdGVKuglBlZcWk+5vgcHMinknFo8CeuSI9DwcOH1rVwwkIIvt5o8+UDTgR51kMsY2YpzdHiPg8TjQO1//Q= Received: by 10.142.50.15 with SMTP id x15mr506620wfx.1196457425870; Fri, 30 Nov 2007 13:17:05 -0800 (PST) Received: by 10.143.19.7 with HTTP; Fri, 30 Nov 2007 13:17:05 -0800 (PST) Message-ID: <36e682920711301317v743865f0jc87b2bd91a3228f9@mail.gmail.com> Date: Fri, 30 Nov 2007 16:17:05 -0500 From: "Jonah H. Harris" To: "Tena Sakai" Subject: Re: connection limit exceeded Cc: 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: <36e682920711301203g7fdb1b81vc7d2bbb2e4018827@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/5 X-Sequence-Number: 27522 On Nov 30, 2007 3:34 PM, Tena Sakai wrote: > This is a wonderful view! How would I properly terminate > these (of course there are 99 of them!) these query process? > Should I do this from unix or is there any postgres tool I > can use? pg_cancel_backend will cancel a query on them. As for killing the process itself, use: kill -TERM -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/