-----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 [EMAIL PROTECTED] 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
