On 10/17/07, Moiz Kothari <moizpostgres(at)gmail(dot)com> wrote:
> Please do not use kill
More like, please do not take advice from people who don't know what
they're talking about.
> it sometimes resets all the connection on your db,
> you might want to use
Honestly, was this supposed to be a joke? Have you RTFM? Have you
looked at the code to pkill? pkill calls kill and frankly, pkill is
more dangerous if you only want to kill a single session.
Grr, I'm surprised to see such an uninformed statement on this list.
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/
In response to
pgsql-admin by date
|Next:||From: Darren Reed||Date: 2007-10-17 12:12:37|
|Subject: Re: Is my database now too big?|
|Previous:||From: Moiz Kothari||Date: 2007-10-17 11:16:05|
|Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list?|