From: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: ctrl-c - is it safe to kill a query?
Date: Mon, 8 Feb 2010 10:40:59 -0500
Message-ID: <20100208154107.B5764632416@mail.postgresql.org> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: msteben@autorevenue.com
Subject: Re: ctrl-c - is it safe to kill a query?
In-Reply-To: <20100208154107.B5764632416@mail.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox