Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Aborting transactions
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Thomas Mack <mack(at)ifis(dot)cs(dot)tu-bs(dot)de>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: Aborting transactions
- Date: Mon, 26 Jun 2006 12:10:43 -0400
Thomas Mack <mack(at)ifis(dot)cs(dot)tu-bs(dot)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
- Follow-Ups:
- Re: Aborting transactions
- From: mack
- Re: Aborting transactions
- References:
- Aborting transactions
- From: Thomas Mack
- Aborting transactions
- Prev by Date: Re: Problem Setting DateStyle
- Next by Date: Re: Problem Setting DateStyle
- Previous by thread: Aborting transactions
- Next by thread: Re: Aborting transactions
- Indexes: