From: bala srini <bala.srini@rediffmail.com>
To: pgsql-admin@postgresql.org
Cc: Olivier Hubaut <olivier@scmbb.ulb.ac.be>
Subject: Re: How to disconnect client from Server forcefully
Date: 20 Aug 2004 12:39:53 -0000
Message-ID: <20040820123953.11895.qmail@webmail17.rediffmail.com> (raw)
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
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: bala.srini@rediffmail.com, olivier@scmbb.ulb.ac.be
Subject: Re: How to disconnect client from Server forcefully
In-Reply-To: <20040820123953.11895.qmail@webmail17.rediffmail.com>
References: <20040820123953.11895.qmail@webmail17.rediffmail.com>
* 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