Re: Aborting transactions

Am Dienstag, 27. Juni 2006 15:47 schrieb Tom Lane:
> Thomas Mack <mack(at)ifis(dot)cs(dot)tu-bs(dot)de> writes:
> > Am Montag, 26. Juni 2006 22:15 schrieb Tom Lane:
> >> 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.
>
> Oh, sorry, I assumed it was in the Solaris FAQ, but actually the info
> is at the bottom of this page:
>
Ok, it might be reasonable to duplicate it in the Solaris FAQ though...

> http://www.postgresql.org/docs/8.1/static/monitoring.html
>
> There are several different conditions that can render "ps" useless on
> Solaris :-(, and one of them is sprinkling the postmaster start command
> with a lot of switches. Put that stuff in postgresql.conf, instead,
> so you can invoke the postmaster as just "postmaster".
>
Oh yes. This explains, why I was missing quite some connections even
with /usr/ucb/ps. Might be good to tell in the documentation to move
the switches to postgresql.conf . Might otherwise produce additional
questions...

Oh, well, the 7.4 documentation states these things already as it
does in 8.1. Sorry, don't know why I missed it. Maybe I had some
other ideas in mind. Not monitoring, but administering or something
like this.

Thanks for your help,
Thomas Mack
TU Braunschweig, Institut für Informationssysteme