From: Thomas Mack <mack@ifis.cs.tu-bs.de>
To: pgsql-admin@postgresql.org
Subject: Re: Aborting transactions
Date: Tue, 27 Jun 2006 16:17:01 +0200
Message-ID: <200606271617.01300.mack@ifis.cs.tu-bs.de> (raw)
In-Reply-To: <12718.1151416069@sss.pgh.pa.us>
References: <200606261709.11750.mack@ifis.cs.tu-bs.de>
<200606271018.34493.mack@ifis.cs.tu-bs.de>
<12718.1151416069@sss.pgh.pa.us>
Am Dienstag, 27. Juni 2006 15:47 schrieb Tom Lane:
> Thomas Mack <mack@ifis.cs.tu-bs.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mack@ifis.cs.tu-bs.de
Subject: Re: Aborting transactions
In-Reply-To: <200606271617.01300.mack@ifis.cs.tu-bs.de>
References: <200606261709.11750.mack@ifis.cs.tu-bs.de> <200606271018.34493.mack@ifis.cs.tu-bs.de> <12718.1151416069@sss.pgh.pa.us> <200606271617.01300.mack@ifis.cs.tu-bs.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox