Skip site navigation (1) Skip section navigation (2)

Re: How to disconnect client from Server forcefully

From: G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar>
To: bala(dot)srini(at)rediffmail(dot)com, pgsql-admin(at)postgresql(dot)org,olivier(at)scmbb(dot)ulb(dot)ac(dot)be
Subject: Re: How to disconnect client from Server forcefully
Date: 2004-08-20 12:58:54
Message-ID: 20040820125854.CEE466C595@honorio.sinectis.com.ar (view raw or flat)
Thread:
Lists: pgsql-admin
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 <bala(dot)srini(at)rediffmail(dot)com>  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


pgsql-admin by date

Next:From: bala sriniDate: 2004-08-20 13:04:19
Subject: Re: How to disconnect client from Server forcefully
Previous:From: G u i d o B a r o s i oDate: 2004-08-20 12:55:54
Subject: Re: How to disconnect client from Server forcefully

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group