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 ECCF45E46E8 for ; Fri, 20 Aug 2004 10:04:25 -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 01208-08 for ; Fri, 20 Aug 2004 13:04:24 +0000 (GMT) Received: from rediffmail.com (unknown [203.199.83.32]) by svr1.postgresql.org (Postfix) with SMTP id EA7545E40BB for ; Fri, 20 Aug 2004 10:04:16 -0300 (ADT) Received: (qmail 21876 invoked by uid 510); 20 Aug 2004 13:04:19 -0000 Date: 20 Aug 2004 13:04:19 -0000 Message-ID: <20040820130419.21875.qmail@webmail32.rediffmail.com> Received: from unknown (203.126.136.220) by rediffmail.com via HTTP; 20 aug 2004 13:04:19 -0000 MIME-Version: 1.0 From: "bala srini" Reply-To: "bala srini" To: "G u i d o B a r o s i o" Cc: pgsql-admin@postgresql.org, olivier@scmbb.ulb.ac.be Subject: Re: How to disconnect client from Server forcefully Content-type: multipart/alternative; boundary="Next_1093007059---0-203.199.83.32-21868" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE, MSGID_FROM_MTA_HEADER X-Spam-Level: X-Archive-Number: 200408/195 X-Sequence-Number: 14590 This is a multipart mime message --Next_1093007059---0-203.199.83.32-21868 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

Assuming that the enviroment of establishing the connection in client may b= e anything.  I want to terminate these remote connections from server = side.

I referred killing the process in server side. this porcess is correspondin= g to the client connsction. After killing also, Client will respawn the con= nection.


On Fri, 20 Aug 2004 G u i d o B a r o s i o wrote :
>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 disconnec= t 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 <bala.srini@redi= ffmail.com>  wrote:
> > >
> > >>Hi
> > >>  =A0I want to disconnect all already established RE= MOTE 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 c= onnection) 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 connect= ion but  simply the client that make a new connection when it goes dis= connected.  Can't you use any firewall to simply block remote connecti= on on the  postmaster host (or simply on the 5432 port)?
> > >
> > >
> > >-- Downloading signature ... 99%
> > >*CRC FAILED*
> > >signature aborted
>



--Next_1093007059---0-203.199.83.32-21868 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Assuming that the enviroment of establishing the connection in client may b= e anything. =A0I want to terminate these remote connections from server sid= e. I referred killing the process in server side. this porcess is correspondin= g to the client connsction. After killing also, Client will respawn the con= nection. On Fri, 20 Aug 2004 G u i d o B a r o s i o wrote : >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 fa= lse. This will block all further remote connection to my server. But what w= ill 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 > > >> =A0I want to disconnect all already established REMOTE DB connectio= ns from the server without restarting the Postmaster daemon. Requirement i= s that diconnect should be done from the server side. Actually I tried to = kill the corresponding process(Remote Db connection) in the server. But s= erver is automatically respawning the connection. Can you please help me o= ut 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. Ca= n't you use any firewall to simply block remote connection on the postmast= er host (or simply on the 5432 port)? > > > > > > > > >-- Downloading signature ... 99% > > >*CRC FAILED* > > >signature aborted > --Next_1093007059---0-203.199.83.32-21868--