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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Atul(dot)Goel(at)globaldatapoint(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Kill -9 for a session process caused all the sessions to be killed
Date: 2010-09-22 16:43:09
Message-ID: 27310.1285173789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Whit Armstrong 2010-09-22 17:35:28 file output via trigger/queue
Previous Message Johannes Öberg 2010-09-22 16:42:45 Re: Force ARE in regexp string