Re: How to disconnect client from Server forcefully - Mailing list pgsql-admin

From G u i d o B a r o s i o
Subject Re: How to disconnect client from Server forcefully
Date
Msg-id 20040820125554.7E5486C5A2@honorio.sinectis.com.ar
Whole thread Raw
In response to How to disconnect client from Server forcefully  ("bala srini" <bala.srini@rediffmail.com>)
List pgsql-admin
how do you kill the process?

Regards,
Guido

> > Thanks for ur reply...
> Actually I can set the tcpipsocket option in postgresql.conf file to false. This will block all further remote
connectionto 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.srini@rediffmail.com>  wrote:
> >
> >>Hi
> >>  �I want to disconnect all already established REMOTE DB connections  from the server without restarting the
Postmasterdaemon. Requirement is  that diconnect should be done from the server side. Actually I tried to  kill the
correspondingprocess(Remote Db connection) in the server. But  server is automatically respawning the connection. Can
youplease 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
whenit goes disconnected.  Can't you use any firewall to simply block remote connection on the  postmaster host (or
simplyon the 5432 port)? 
> >
> >
> >-- Downloading signature ... 99%
> >*CRC FAILED*
> >signature aborted


pgsql-admin by date:

Previous
From: "bala srini"
Date:
Subject: Re: How to disconnect client from Server forcefully
Next
From: G u i d o B a r o s i o
Date:
Subject: Re: How to disconnect client from Server forcefully