Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 8B32BB5DBDB for ; Tue, 9 Aug 2011 12:45:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 18165-07 for ; Tue, 9 Aug 2011 15:45:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 5411FB5DBD6 for ; Tue, 9 Aug 2011 12:45:12 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p79FjB4G019115; Tue, 9 Aug 2011 11:45:11 -0400 (EDT) To: Raghavendra cc: Kevin Grittner , iliya g , "pgsql-admin@postgresql.org" Subject: Re: Postgres process In-reply-to: References: <1312899853.23309.androidMobile@web120528.mail.ne1.yahoo.com> <4E410271020000250003FCBD@gw.wicourts.gov> Comments: In-reply-to Raghavendra message dated "Tue, 09 Aug 2011 20:32:56 +0530" Date: Tue, 09 Aug 2011 11:45:11 -0400 Message-ID: <19114.1312904711@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.712 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.812 X-Spam-Level: X-Archive-Number: 201108/57 X-Sequence-Number: 38044 Raghavendra writes: > Still, my guess we cannot get the process description on SunOS. I surely hope you're not still running SunOS. If you mean Solaris, note what the manual says at http://www.postgresql.org/docs/9.0/static/monitoring-ps.html Tip: Solaris requires special handling. You must use /usr/ucb/ps, rather than /bin/ps. You also must use two w flags, not just one. In addition, your original invocation of the postgres command must have a shorter ps status display than that provided by each server process. If you fail to do all three things, the ps output for each server process will be the original postgres command line. This advice is close to ten years old, but might well still apply to recent Solaris releases. regards, tom lane