Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Kill -9 for a session process caused all the sessions to be killed
Date
Msg-id 27310.1285173789@sss.pgh.pa.us
Whole thread Raw
In response to Kill -9 for a session process caused all the sessions to be killed  (<Atul.Goel@globaldatapoint.com>)
Responses Re: Kill -9 for a session process caused all the sessions to be killed  (<Atul.Goel@globaldatapoint.com>)
List pgsql-general
Tree view 
<Atul.Goel@globaldatapoint.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

pgsql-general by date:

Previous
From:
Date:
Subject: Kill -9 for a session process caused all the sessions to be killed
Next
From: Johannes Öberg
Date:
Subject: Re: Force ARE in regexp string