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 2A2645E46C8 for ; Fri, 20 Aug 2004 09:39:54 -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 92314-02 for ; Fri, 20 Aug 2004 12:39:52 +0000 (GMT) Received: from rediffmail.com (unknown [203.199.83.27]) by svr1.postgresql.org (Postfix) with SMTP id BC8005E46E2 for ; Fri, 20 Aug 2004 09:39:49 -0300 (ADT) Received: (qmail 11896 invoked by uid 510); 20 Aug 2004 12:39:53 -0000 Date: 20 Aug 2004 12:39:53 -0000 Message-ID: <20040820123953.11895.qmail@webmail17.rediffmail.com> Received: from unknown (203.126.136.220) by rediffmail.com via HTTP; 20 aug 2004 12:39:53 -0000 MIME-Version: 1.0 From: "bala srini" Reply-To: "bala srini" To: pgsql-admin@postgresql.org Cc: "Olivier Hubaut" Subject: Re: How to disconnect client from Server forcefully Content-type: multipart/alternative; boundary="Next_1093005593---0-203.199.83.27-11892" 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/192 X-Sequence-Number: 14587 This is a multipart mime message --Next_1093005593---0-203.199.83.27-11892 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

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 als= o .. 

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 established REMOTE DB co= nnections  from the server without restarting the Postmaster daemon. R= equirement is  that diconnect should be done from the server side. Act= ually 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&nb= sp; 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&= nbsp; postmaster host (or simply on the 5432 port)?
>
>
>-- Downloading signature ... 99%
>*CRC FAILED*
>signature aborted



--Next_1093005593---0-203.199.83.27-11892 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 als= o .. =A0 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 wro= te: > >>Hi >> =A0I want to disconnect all already established REMOTE DB connections = from the server without restarting the Postmaster daemon. Requirement is t= hat diconnect should be done from the server side. Actually I tried to kil= l the corresponding process(Remote Db connection) in the server. But serve= r is automatically respawning the connection. Can you please help me out i= n this? >> >>Regards >>Srini. >> >In fact, I think it's not the server that respawn the connection but simp= ly 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 h= ost (or simply on the 5432 port)? > > >-- Downloading signature ... 99% >*CRC FAILED* >signature aborted --Next_1093005593---0-203.199.83.27-11892--