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 DE4A39FA50D for ; Tue, 27 Jun 2006 11:17:14 -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 64646-05 for ; Tue, 27 Jun 2006 11:17:04 -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 A2F4A9FA10A for ; Tue, 27 Jun 2006 11:17:03 -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 k5REH1NA018762 for ; Tue, 27 Jun 2006 16:17:01 +0200 (CEST) From: Thomas Mack To: pgsql-admin@postgresql.org Subject: Re: Aborting transactions Date: Tue, 27 Jun 2006 16:17:01 +0200 User-Agent: KMail/1.5.4 References: <200606261709.11750.mack@ifis.cs.tu-bs.de> <200606271018.34493.mack@ifis.cs.tu-bs.de> <12718.1151416069@sss.pgh.pa.us> In-Reply-To: <12718.1151416069@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200606271617.01300.mack@ifis.cs.tu-bs.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/258 X-Sequence-Number: 22220 Am Dienstag, 27. Juni 2006 15:47 schrieb Tom Lane: > Thomas Mack 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=FCr Informationssysteme