How to disconnect client from Server forcefully

Discussion:

(too old to reply)

bala srini

2004-08-20 12:05:47 UTC

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.

Olivier Hubaut

2004-08-20 11:32:58 UTC

Permalink

Post by bala srini
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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

bala srini

2004-08-20 12:39:53 UTC

Permalink

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

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

G u i d o B a r o s i o

2004-08-20 12:55:54 UTC

Permalink

how do you kill the process?

Regards,
Guido

Post by bala srini

Post by bala srini
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

Post by bala 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

G u i d o B a r o s i o

2004-08-20 12:58:54 UTC

Permalink

Also,...

how does the aplication performs the connection?
Describe the enviroment please. (web, perl (Pg) -> db ie)

guido

Post by bala srini

Post by bala srini
Thanks for ur reply...

Post by bala 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

bala srini

2004-08-20 13:04:19 UTC

Permalink

Assuming that the enviroment of establishing the connection in client may be anything. I want to terminate these remote connections from server side.

I referred killing the process in server side. this porcess is corresponding to the client connsction. After killing also, Client will respawn the connection.

Post by G u i d o B a r o s i o
Also,...
how does the aplication performs the connection?
Describe the enviroment please. (web, perl (Pg) -> db ie)
guido

Post by bala srini

Post by bala srini
Thanks for ur reply...

Post by bala 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

bala srini

2004-08-23 04:47:58 UTC

Permalink

Hi All
Can anyone help me reg the below mail?

Assuming the environment is thru the terminal i.e by setting the PGHOST varaible to server machine and then invoking the command "psql" from client machine.

Thanks & Regards
Bala.

Post by bala srini
Assuming that the enviroment of establishing the connection in client may be anything. I want to terminate these remote connections from server side.
I referred killing the process in server side. this porcess is corresponding to the client connsction. After killing also, Client will respawn the connection.

Post by G u i d o B a r o s i o
Also,...
how does the aplication performs the connection?
Describe the enviroment please. (web, perl (Pg) -> db ie)
guido

Post by bala srini

Post by bala srini
Thanks for ur reply...

Post by bala 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

Andrew Hammond

2004-08-23 15:14:09 UTC

Permalink

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

bala srini wrote:
| Hi All
| Can anyone help me reg the below mail?
|
| Assuming the environment is thru the terminal i.e by setting the
PGHOST varaible to server machine and then invoking the command "psql"
from client machine.
|
| Thanks & Regards
| Bala.
|
|
| On Fri, 20 Aug 2004 bala srini wrote :
|
|>Assuming that the enviroment of establishing the connection in client
may be anything. I want to terminate these remote connections from
server side.
|>
|>I referred killing the process in server side. this porcess is
corresponding to the client connsction. After killing also, Client will
respawn the connection.
|>
|>

0) Use pg_who to identify the offending connection and it's source.
Assume it's connecting from host 192.168.0.23 as user "naughty" to
database "widgets".

1) Add a rule blocking access to your pg_hba ruleset:

host widgets naughty 192.168.0.23 255.255.255.255 reject

2) Tell the postmaster to re-read config files. This adds your new
pg_hba rule.

pgctl reload

3) Use pg_who (not part of default distro, but available on gborg IIRC)
and kill the offending process.

The offending process will now fill your log files with failed
re-connect notices.

- --
Andrew Hammond 416-673-4138 ***@ca.afilias.info
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBKgm/gfzn5SevSpoRAolgAKCwoWttsPTs709yEJ+i1Kk18Rqi9ACfeDXI
9Gl2XAxpL+X/nUFgumwCNQk=
=v1Gq
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend