Skip site navigation (1) Skip section navigation (2)

Re: Aborting transactions

From: Thomas Mack <mack(at)ifis(dot)cs(dot)tu-bs(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Aborting transactions
Date: 2006-06-27 08:18:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Am Montag, 26. Juni 2006 22:15 schrieb Tom Lane:
> mack(at)ifis(dot)cs(dot)tu-bs(dot)de writes:
> > I don't have a pg_stat_activity on this 7.4.6, so using ps gives me:
> >
> > postgres(at)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 , I did not find
anything related. Same with the doc/FAQ_Solaris from the postgresql-8.1.4

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.

Thomas Mack
TU Braunschweig, Institut für Informationssysteme

In response to


pgsql-admin by date

Next:From: Jorge DDate: 2006-06-27 08:37:53
Subject: Jobs
Previous:From: Dennis WagnerDate: 2006-06-27 08:13:40
Subject: Re: Using GUIDs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group