pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
To: bala.srini@rediffmail.com
To: pgsql-admin@postgresql.org
To: olivier@scmbb.ulb.ac.be
Subject: Re: How to disconnect client from Server forcefully
Date: Fri, 20 Aug 2004 09:55:54 -0300 (GMT+3)
Message-ID: <20040820125554.7E5486C5A2@honorio.sinectis.com.ar> (raw)

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 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.srini@rediffmail.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




view thread (8+ messages)  latest in thread

Message-ID: <20040820125554.7E5486C5A2@honorio.sinectis.com.ar>
Permalink:  ../20040820125554.7E5486C5A2@honorio.sinectis.com.ar/
Also on:    postgresql.org/message-id/20040820125554.7E5486C5A2@honorio.sinectis.com.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gbarosio@uolsinectis.com.ar, bala.srini@rediffmail.com, olivier@scmbb.ulb.ac.be
  Subject: Re: How to disconnect client from Server forcefully
  In-Reply-To: <20040820125554.7E5486C5A2@honorio.sinectis.com.ar>
  References: <20040820125554.7E5486C5A2@honorio.sinectis.com.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox