idle processes in v7.1 ... not killable?
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
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
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