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 9D8F55E46DE for ; Fri, 20 Aug 2004 09:33:01 -0300 (ADT) 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 85868-07 for ; Fri, 20 Aug 2004 12:32:59 +0000 (GMT) Received: from guppy.vub.ac.be (sss.vub.ac.be [134.184.129.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6E70E5E46CA for ; Fri, 20 Aug 2004 09:32:56 -0300 (ADT) Received: from mach.vub.ac.be (mach.vub.ac.be [134.184.129.8]) by guppy.vub.ac.be (8.9.1b+Sun/3.17.1.ap (guppy)) id OAA21609; Fri, 20 Aug 2004 14:32:59 +0200 (MET DST) for Received: from olivier.amaze.ulb.ac.be (ucmbsgi10.ulb.ac.be [164.15.109.34]) by mach.vub.ac.be (Postfix) with ESMTP id 2BD3D22F8; Fri, 20 Aug 2004 14:32:59 +0200 (CEST) To: "bala srini" , pgsql-admin@postgresql.org Subject: Re: How to disconnect client from Server forcefully References: <20040820120547.25180.qmail@webmail28.rediffmail.com> Message-ID: Date: Fri, 20 Aug 2004 14:32:58 +0300 From: "Olivier Hubaut" Organization: aMAZE Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <20040820120547.25180.qmail@webmail28.rediffmail.com> User-Agent: Opera M2/7.52 (MacPPC, build 1822) 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: 200408/191 X-Sequence-Number: 14586 On 20 Aug 2004 12:05:47 -0000, bala srini wrote: > Hi >  I want to disconnect all already established REMOTE DB connections > from the server without restarting the Postmaster daemon. Requirement is > that diconnect should be done from the server side. Actually I tried to > kill the corresponding process(Remote Db connection) in the server. But > server is automatically respawning the connection. Can you please help > me out in this? > > Regards > Srini. > In fact, I think it's not the server that respawn the connection but simply the client that make a new connection when it goes disconnected. Can't you use any firewall to simply block remote connection on the postmaster host (or simply on the 5432 port)? -- Downloading signature ... 99% *CRC FAILED* signature aborted