X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DC9249FA7B6 for ; Mon, 26 Jun 2006 17:10:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 97050-02 for ; Mon, 26 Jun 2006 17:10:18 -0300 (ADT) X-Greylist: delayed 05:00:59.594036 by SQLgrey- Received: from infbssys.ips.cs.tu-bs.de (infbssys.ips.cs.tu-bs.de [134.169.32.1]) by postgresql.org (Postfix) with ESMTP id D0C799FA6B3 for ; Mon, 26 Jun 2006 17:10:14 -0300 (ADT) Received: from is38.idb.cs.tu-bs.de (is38 [134.169.32.148]) by infbssys.ips.cs.tu-bs.de (8.13.6+Sun/8.13.6) with ESMTP id k5QKA7XU014846; Mon, 26 Jun 2006 22:10:07 +0200 (CEST) Received: by is38.idb.cs.tu-bs.de (Postfix, from userid 425) id CC4B025064; Mon, 26 Jun 2006 22:10:07 +0200 (CEST) Date: Mon, 26 Jun 2006 22:10:07 +0200 From: mack@ifis.cs.tu-bs.de To: tgl@sss.pgh.pa.us Cc: pgsql-admin@postgresql.org Subject: Re: Aborting transactions Message-ID: <44A03F1F.mailJHY11PP6J@ifis.cs.tu-bs.de> References: <200606261709.11750.mack@ifis.cs.tu-bs.de> <29951.1151338243@sss.pgh.pa.us> In-Reply-To: <29951.1151338243@sss.pgh.pa.us> User-Agent: nail 10.5 4/27/03 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/235 X-Sequence-Number: 22197 >Thomas Mack writes: >> Is there any chance to monitor the current transactions and abort th= em, >> 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. > I don't have a pg_stat_activity on this 7.4.6, so using ps gives me: postgres@is20 ~ 4 > ps -ef | grep postmaster postgres 4499 4498 0 08:59:18 ? 0:04 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 23268 4498 0 12:50:39 ? 0:03 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 4713 4498 0 09:25:05 ? 0:05 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 20836 4498 0 15:22:51 ? 0:02 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 20859 4498 0 18:51:48 ? 0:01 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 25116 4498 0 13:40:26 ? 0:04 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 12050 4498 0 21:57:30 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 4498 4489 0 08:59:18 ? 0:47 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 18589 4498 0 21:09:09 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 11104 4498 0 21:34:24 ? 0:03 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 4500 4499 0 08:59:18 ? 0:48 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 14684 4498 0 19:46:16 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 25527 4498 0 13:47:25 ? 0:03 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 13863 4498 0 19:20:56 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 11910 4498 0 21:54:18 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 23450 4498 0 12:53:48 ? 0:05 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 24216 4498 0 13:16:27 ? 0:04 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 21584 4498 0 19:08:55 ? 0:01 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 25904 4498 0 13:54:19 ? 0:04 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 17848 4498 0 17:35:52 ? 0:01 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 10893 4498 0 21:28:04 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 12210 12147 0 22:02:27 pts/22 0:00 grep postmaster postgres 18650 4498 0 21:10:34 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 1563 4498 0 19:15:38 ? 0:01 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 16993 4498 0 20:26:05 ? 0:08 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 14210 4498 0 19:30:01 ? 0:10 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 14457 4498 0 19:38:37 ? 0:01 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 14030 4498 0 19:23:51 ? 0:01 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 16675 4498 0 20:18:21 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 14914 4498 0 19:49:00 ? 0:01 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres 17576 4498 0 20:41:26 ? 0:00 /usr/local/pgsql/bin= /postmaster -i -p 5356 -o -e postgres@is20 ~ 5 >=20 So, what is what? I will switch to 8.1 later this year, is it better with that version? Best regards, Thomas Mack TU Braunschweig, Institut f=FCr Informationssysteme