Re: Kill -9 for a session process caused all the sessions to be killed

Thanks Tom,

I found the right way to kill the process.

Regards,
Atul Goel

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 22 September 2010 17:43
To: Atul Goel
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Kill -9 for a session process caused all the sessions to be killed

<Atul(dot)Goel(at)globaldatapoint(dot)com> writes:
> I by mistake ran a query to update a huge table with around 500000 rows and has to kill the session.

> I found the process-id from the query select * from pg_stat_activity. I killed the process using Kill -9 process_id.

> This caused all other sessions in the system to be killed and database was unreachable for a minute or so.

> MY QUESTION: Is this normal?

Yes. That is not the recommended way to cancel a query.

regards, tom lane
This e-mail is confidential and should not be used by anyone who is not the original intended recipient. Global DataPoint Limited does not accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of Global DataPoint Limited. No contracts may be concluded on behalf of Global DataPoint Limited by means of e-mail communication. Global DataPoint Limited Registered in England and Wales with registered number 3739752 Registered Office Middlesex House, 34-42 Cleveland Street, London W1T 4LB