idle processes in v7.1 ... not killable?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: idle processes in v7.1 ... not killable?
Date: 2001-04-19 12:57:30
Message-ID: Pine.BSF.4.33.0104190956020.400-100000@mobile.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2001-04-19 13:42:22 Re: Re: [BUG?] tgconstrrelid doesn't survive a dump/restore
Previous Message Vince Vielhaber 2001-04-19 09:49:45 Re: Re: No printable 7.1 docs?