ctrl-c - is it safe to kill a query?

From: "Mark Steben" <msteben(at)autorevenue(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: ctrl-c - is it safe to kill a query?
Date: 2010-02-08 15:40:59
Message-ID: 20100208154107.B5764632416@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi folks,

We are running psql 8.3.7 and linux 2.6.9-78.0.17.ELsmp

We had a situation this weekend where someone was running an update

On the psql command line and had to kill it.

It is considered 'best practice' to use cntrl-c to do so?

Or is there a better way? The transaction did roll back.

Good to know for future reference. Thank you.

Mark Steben | Database Administrator
<http://www.autorevenue.com> @utoRevenueR - "Keeping Customers Close"
95D Ashley Ave, West Springfield, MA 01089
413.243.4800 x1512 (Phone) |413.732-1824 (Fax)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rosser Schwarz 2010-02-08 22:38:54 Re: Best Replication Tool
Previous Message Scott Marlowe 2010-02-08 03:32:46 Re: Best Replication Tool