From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: killing process question |
Date: | 2002-09-19 15:19:03 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB04C73F79@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
--howdy:
--not that the process is doing a lot or taking up
--a lot of resources, it's just something
--that i allow the users to kill and then
--it get's passed to me for correction if the
--simple 'kill <pid>' thing doesn't work.
--what i'm trying to understand is if there
--is a way to do this without having to restart
--the database (remember, it's still production)
--everytime there is a runaway process AND not
--kill -9 <pid>.
--how can i do this?
-X
-----Original Message-----
From: Shridhar Daithankar [mailto:shridhar_daithankar(at)persistent(dot)co(dot)in]
Sent: Thursday, September 19, 2002 10:45 AM
To: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] killing process question
On 19 Sep 2002 at 10:39, Johnson, Shaunn wrote:
>
> --thanks for the reply:
>
> --no, I don't see anything like that. this is what I have:
>
> [snip]
>
> postgres 3488 5.6 0.0 11412 4 pts/4 T Sep18 88:53 postgres:
> joetestdb 16.xx.xx.xx SELECT
> [/snip]
>
> --this tells me that this proc had been running once upon a time (since
the
> 18th) and
> --has stopped (the 'T'). the user has said that he had since killed the
tool
> --that connected to the database and booted his machine.
>
> --so ... when I do a 'kill pid' or 'kill -TERM pid' ... *poof* ... nothing
> happens ...
Does restarting database helps? It may just make the thing go away..
Or stop the database, kill the pid with -9 and start it again.. Nothing
lost..
Bye
Shridhar
--
Shedenhelm's Law: All trails have more uphill sections than they have
downhill
sections.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2002-09-19 15:28:29 | Re: killing process question |
Previous Message | Stephan Szabo | 2002-09-19 15:18:09 | Re: Deadlock error!? |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2002-09-19 15:28:29 | Re: killing process question |
Previous Message | Zeugswetter Andreas SB SD | 2002-09-19 14:57:30 | Re: Proposal for resolving casting issues |