Re: Aborting transactions - Mailing list pgsql-admin

From Tom Lane
Subject Re: Aborting transactions
Date
Msg-id 29951.1151338243@sss.pgh.pa.us
Whole thread Raw
In response to Aborting transactions  (Thomas Mack <mack@ifis.cs.tu-bs.de>)
Responses Re: Aborting transactions  (mack@ifis.cs.tu-bs.de)
List pgsql-admin
Thomas Mack <mack@ifis.cs.tu-bs.de> writes:
> Is there any chance to monitor the current transactions and abort them,
> in case of need?

Sure, just SIGINT whichever backend you want to cancel its query.
Use "ps" or pg_stat_activity to figure out the right PID to kill.

            regards, tom lane

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Problem Setting DateStyle
Next
From: Scott Marlowe
Date:
Subject: Re: Problem Setting DateStyle