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 A3AD75E46EA for ; Mon, 23 Aug 2004 01:48:00 -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 27831-04 for ; Mon, 23 Aug 2004 04:48:03 +0000 (GMT) Received: from rediffmail.com (unknown [203.199.83.28]) by svr1.postgresql.org (Postfix) with SMTP id 2BE2C5E470E for ; Mon, 23 Aug 2004 01:47:52 -0300 (ADT) Received: (qmail 21822 invoked by uid 510); 23 Aug 2004 04:47:58 -0000 Date: 23 Aug 2004 04:47:58 -0000 Message-ID: <20040823044758.21817.qmail@webmail18.rediffmail.com> Received: from unknown (203.126.136.220) by rediffmail.com via HTTP; 23 aug 2004 04:47:58 -0000 MIME-Version: 1.0 From: "bala srini" Reply-To: "bala srini" To: pgsql-admin@postgresql.org Cc: olivier@scmbb.ulb.ac.be, "G u i d o B a r o s i o" Subject: Re: How to disconnect client from Server forcefully Content-type: multipart/alternative; boundary="Next_1093236478---0-203.199.83.28-21801" 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/209 X-Sequence-Number: 14604 This is a multipart mime message --Next_1093236478---0-203.199.83.28-21801 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

Hi All
  Can anyone help me reg the below mail?
 
  Assuming the environment is thru the terminal i.e by setting the PGH= OST varaible to server machine and then invoking the command "psql&quo= t; from client machine.

Thanks & Regards
Bala.


On Fri, 20 Aug 2004 bala srini wrote :
>Assuming that the enviroment of establishing the connection in client m= ay be anything.  I want to terminate these remote connections from ser= ver side.
>
>I referred killing the process in server side. this porcess is correspo= nding to the client connsction. After killing also, Client will respawn the= connection.
>
>
>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 disc= onnect 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= @rediffmail.com>  wrote:
> > > >
> > > >>Hi
> > > >>  =A0I want to disconnect all already establish= ed REMOTE DB connections  from the server without restarting the Postm= aster daemon. Requirement is  that diconnect should be done from the s= erver 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 co= nnection but  simply the client that make a new connection when it goe= s disconnected.  Can't you use any firewall to simply block remote con= nection on the  postmaster host (or simply on the 5432 port)?
> > > >
> > > >
> > > >-- Downloading signature ... 99%
> > > >*CRC FAILED*
> > > >signature aborted
> >



--Next_1093236478---0-203.199.83.28-21801 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi All =A0Can anyone help me reg the below mail? =20=20 Assuming the environment is thru the terminal i.e by setting the PGHOST v= araible to server machine and then invoking the command "psql" from client = machine. Thanks & Regards Bala. On Fri, 20 Aug 2004 bala srini wrote : >Assuming that the enviroment of establishing the connection in client may = be anything. =A0I want to terminate these remote connections from server si= de. > >I referred killing the process in server side. this porcess is correspondi= ng to the client connsction. After killing also, Client will respawn the co= nnection. > > >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 disconnect th= is 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 connect= ions from the server without restarting the Postmaster daemon. Requirement= is that diconnect should be done from the server side. Actually I tried t= o 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 postma= ster host (or simply on the 5432 port)? > > > > > > > > > > > >-- Downloading signature ... 99% > > > >*CRC FAILED* > > > >signature aborted > > --Next_1093236478---0-203.199.83.28-21801--