-----BEGIN PGP SIGNED MESSAGE-----
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
| 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
|>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
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
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
Andrew Hammond 416-673-4138 ahammond(at)ca(dot)afilias(dot)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)
-----END PGP SIGNATURE-----
In response to
pgsql-admin by date
|Next:||From: Roberto Rezende de Assis||Date: 2004-08-23 15:52:26|
|Subject: Re: Looking for tool for Graphic Database Design|
|Previous:||From: Cavit Keskin||Date: 2004-08-23 15:12:02|
|Subject: TSearch2 other languages|