Re: Aborting transactions

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
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.

...
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ür Informationssysteme