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 3BAA75E46D8 for ; Fri, 20 Aug 2004 09:58:53 -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 01040-01 for ; Fri, 20 Aug 2004 12:58:51 +0000 (GMT) Received: from honorio.sinectis.com.ar (honorio.sinectis.com.ar [216.244.192.201]) by svr1.postgresql.org (Postfix) with ESMTP id 3223A5E46C8 for ; Fri, 20 Aug 2004 09:58:50 -0300 (ADT) Received: by honorio.sinectis.com.ar (Postfix, from userid 99) id CEE466C595; Fri, 20 Aug 2004 09:58:54 -0300 (GMT+3) Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-Mailer: Sinectis Webmail 5.6.16-1.5.1 From: G u i d o B a r o s i o To: bala.srini@rediffmail.com, pgsql-admin@postgresql.org, olivier@scmbb.ulb.ac.be Subject: Re: How to disconnect client from Server forcefully Reply-To: gbarosio@uolsinectis.com.ar Message-Id: <20040820125854.CEE466C595@honorio.sinectis.com.ar> Date: Fri, 20 Aug 2004 09:58:54 -0300 (GMT+3) 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/194 X-Sequence-Number: 14589 Also,... how does the aplication performs the connection? Describe the enviroment please. (web, perl (Pg) -> db ie) guido > > Thanks for ur reply... > Actually I can set the tcpipsocket option in postgresql.conf file to false. This will block all further remote connection to my server. But what will happen to already existing remote connection? I want to disconnect this also ..   > > Sorry I can't change the firewall settings... > > Regards > Srini > > On Fri, 20 Aug 2004 Olivier Hubaut wrote : > >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