On 10/16/07, Jessica Richard <[EMAIL PROTECTED]> wrote: > If the connection is from the local machine, I can find it with "ps -ef | > grep procpid", then kill it with Unix command "kill" outside Postgres... > > But I have many remote connections coming from different machines...it is > hard to kill on the OS level outside Postgres on the postgres host... > > I am looking for something to kill a Postgres user connection within > Postgres... > Some thing like, you find the user connection with select * from > pg_stat_activity...then you pick a procpid and kill right there...
Write a C stored procedure that takes a pid and calls kill(2), install it on the server, and call it from SQL. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | [EMAIL PROTECTED] Edison, NJ 08837 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
