
I tried to do a 'kill <pid>' like I would have in v7.0.3, doesn't affect
it ... so, how to get rid of idle process that have been sitting around
for a long time, without having to shutdown the database itself?

pgsql   64484  0.0  1.0 15352 10172  p4- I    Sat08PM   0:00.15 postmaster: hordemgr horde 216.126.85.170 idle (postgres)
pgsql   64760  0.0  1.0 15352 10420  p4- I    Sat08PM   0:00.21 postmaster: hordemgr horde 216.126.85.170 idle (postgres)
pgsql   94615  0.0  0.8 15336 8488  p4- I    Sun12AM   0:00.09 postmaster: hordemgr horde 216.126.85.86 idle (postgres)
pgsql   99711  0.0  0.9 15336 9688  p4- I    Sun01AM   0:00.14 postmaster: hordemgr horde 216.126.85.188 idle (postgres)
pgsql   99810  0.0  0.9 15352 9124  p4- I    Sun01AM   0:00.12 postmaster: hordemgr horde 216.126.85.188 idle (postgres)
pgsql    1768  0.0  0.8 15336 8112  p4- I    Sun01AM   0:00.09 postmaster: hordemgr horde 216.126.85.86 idle (postgres)
pgsql    8781  0.0  1.1 15368 11016  p4- I    Sun09AM   0:00.23 postmaster: hordemgr horde 216.126.85.30 idle (postgres)
pgsql   29503  0.0  1.1 15352 11052  p4- I    Sun10AM   0:00.23 postmaster: hordemgr horde 216.126.85.30 idle (postgres)
pgsql   29930  0.0  1.0 15352 10556  p4- I    Sun11PM   0:00.15 postmaster: hordemgr horde 216.126.85.100 idle (postgres)
pgsql   29985  0.0  1.0 15352 10192  p4- I    Sun11PM   0:00.14 postmaster: hordemgr horde 216.126.85.100 idle (postgres)
pgsql   57446  0.0  0.6 15336 6784  p4- I    Mon09AM   0:00.06 postmaster: hordemgr horde 216.126.85.243 idle (postgres)
pgsql   57961  0.0  0.7 15336 6884  p4- I    Mon09AM   0:00.06 postmaster: hordemgr horde 216.126.85.243 idle (postgres)
pgsql   98541  0.0  0.8 15352 8756  p4- I    Mon11AM   0:00.10 postmaster: hordemgr horde 216.126.85.13 idle (postgres)
pgsql   98601  0.0  0.7 15336 6796  p4- I    Mon11AM   0:00.06 postmaster: hordemgr horde 216.126.85.13 idle (postgres)
pgsql   16510  0.0  0.7 15352 7624  p4- I    Mon01PM   0:00.07 postmaster: hordemgr horde 216.126.85.196 idle (postgres)
pgsql   17052  0.0  0.7 15352 6936  p4- I    Mon01PM   0:00.06 postmaster: hordemgr horde 216.126.85.196 idle (postgres)
pgsql   86741  0.0  0.6 15336 6660  p4- I    Mon10PM   0:00.06 postmaster: hordemgr horde 216.126.85.119 idle (postgres)
pgsql    8388  0.0  0.6 15336 6484  p4- I    Tue12AM   0:00.05 postmaster: hordemgr horde 216.126.85.95 idle (postgres)
pgsql   27186  0.0  1.0 15368 10880  p4- I    Tue09AM   0:00.24 postmaster: hordemgr horde 216.126.85.184 idle (postgres)
pgsql   27512  0.0  0.9 15352 9616  p4- I    Tue09AM   0:00.15 postmaster: hordemgr horde 216.126.85.184 idle (postgres)
pgsql   91723  0.0  1.0 15368 10364  p4- I    Tue12PM   0:00.16 postmaster: hordemgr horde 216.126.85.194 idle (postgres)
pgsql   45351  0.0  0.6 15336 5952  p4- I    10:03AM   0:00.04 postmaster: hordemgr horde 216.126.85.186 idle (postgres)
pgsql   35967  0.0  0.5 15336 4960  ??  I     8:53AM   0:00.03 postmaster: hordemgr horde 216.126.84.1 idle (postgres)
pgsql   36678  0.0  0.0  1008  312  p4  R+    8:55AM   0:00.00 grep hordemgr
pgsql   45200  0.0  0.7 15356 6828  p4- I    10:03AM   0:00.06 postmaster: hordemgr horde 216.126.85.186 idle (postgres)


Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


Thu, 19 Apr 2001 09:57:30 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
idle processes in v7.1 ... not killable?
The Hermit Hacker <scrappy@hub.org> writes:
> I tried to do a 'kill <pid>' like I would have in v7.0.3, doesn't affect
> it ...

Huh?  Doesn't kill default to -TERM on your machine?  That works fine
for me ...

			regards, tom lane

Thu, 19 Apr 2001 14:23:56 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: idle processes in v7.1 ... not killable? 

Okay, I *swear* I tried both 'kill <pid>' and 'kill -TERM <pid>' this
morning before I sent this out .. just tried it again and it worked :(

*shrug*

On Thu, 19 Apr 2001, Tom Lane wrote:

> The Hermit Hacker <scrappy@hub.org> writes:
> > I tried to do a 'kill <pid>' like I would have in v7.0.3, doesn't affect
> > it ...
>
> Huh?  Doesn't kill default to -TERM on your machine?  That works fine
> for me ...
>
> 			regards, tom lane
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


Thu, 19 Apr 2001 15:31:46 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: idle processes in v7.1 ... not killable? 