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 0E30C9FA490 for ; Tue, 27 Jun 2006 05:18:55 -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 28407-09 for ; Tue, 27 Jun 2006 05:18:44 -0300 (ADT) X-Greylist: from auto-whitelisted 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 B28139FA395 for ; Tue, 27 Jun 2006 05:18:39 -0300 (ADT) Received: from is38 (is38 [134.169.32.148]) by infbssys.ips.cs.tu-bs.de (8.13.6+Sun/8.13.6) with ESMTP id k5R8Ib7V020641; Tue, 27 Jun 2006 10:18:37 +0200 (CEST) From: Thomas Mack To: Tom Lane Subject: Re: Aborting transactions Date: Tue, 27 Jun 2006 10:18:33 +0200 User-Agent: KMail/1.5.4 References: <200606261709.11750.mack@ifis.cs.tu-bs.de> <44A03F1F.mailJHY11PP6J@ifis.cs.tu-bs.de> <22480.1151352950@sss.pgh.pa.us> In-Reply-To: <22480.1151352950@sss.pgh.pa.us> Cc: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200606271018.34493.mack@ifis.cs.tu-bs.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/253 X-Sequence-Number: 22215 Am Montag, 26. Juni 2006 22:15 schrieb Tom Lane: > mack@ifis.cs.tu-bs.de writes: > > 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 > > What platform is that? If it's Solaris, see our doc/FAQ_Solaris about > getting more useful info from "ps". > Yes, it's Solaris 10. Looking at http://www.postgresql.org/docs/faqs.FAQ_Solaris.html , I did not find anything related. Same with the doc/FAQ_Solaris from the postgresql-8.1.4 sources. =2E.. Ok, I tried on a Linux server with 8.0.0, where I could get some useful informations out of ps. I tried /usr/ucb/ps on Solaris, which revealed more information, but I did not see a test query from a remote client for some magic reason (select * from t1, t2 with 250,000 and 512,000 rows). I think, I can live with it for now, as I will upgrade later this year. Thanks, Thomas Mack TU Braunschweig, Institut f=FCr Informationssysteme