Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id EE7D5B5DBDA for ; Tue, 9 Aug 2011 13:58:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 95431-04 for ; Tue, 9 Aug 2011 16:58:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm7-vm5.bullet.mail.ne1.yahoo.com (nm7-vm5.bullet.mail.ne1.yahoo.com [98.138.91.229]) by mail.postgresql.org (Postfix) with SMTP id 3BABCB5D80A for ; Tue, 9 Aug 2011 13:58:06 -0300 (ADT) Received: from [98.138.90.57] by nm7.bullet.mail.ne1.yahoo.com with NNFMP; 09 Aug 2011 16:58:05 -0000 Received: from [98.138.89.163] by tm10.bullet.mail.ne1.yahoo.com with NNFMP; 09 Aug 2011 16:58:05 -0000 Received: from [127.0.0.1] by omp1019.mail.ne1.yahoo.com with NNFMP; 09 Aug 2011 16:58:05 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 208631.55352.bm@omp1019.mail.ne1.yahoo.com Received: (qmail 87717 invoked by uid 60001); 9 Aug 2011 16:58:05 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1312909085; bh=l3BsqUdXmAk7Hukrzqsd/hdHKCwG4tVqZUl+HTt432A=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=UiF1j3K8E+ca6BE/v5s08VGehjfnpe7d2Mhnm8zDnrDKkVp5nw38MjCSn+AcBzomCA/6qBnCuh70jdthR+h+luUP5nP/Yp7SU7AsuAgnpOahpHqhEoxWs1fgMO5F4SDFp9kQUyhmdopOfN7X+JmDbhujTfismmX+znSGYcu0kTg= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=FGbIiKU+shf3Wrbsl2twcqN6YAfMZKWT76bbf7KZYWT1uzgNgcWKzuBmcA1LhbMP2F2PCPdUmI/hnHEvolW33OAhv1LYdYUlBbHI/JRqplLT4wAM30gk7M6xitRVfl4oBLvyM5tSNsUaTt7IX9CwF7ogqhrywp1quUPSmJNjWrY=; X-YMail-OSG: 4RjKY6sVM1k6bc5bqPOd.VbARl_TZYOE9cZuJ4LaP2WMIc1 nubplhmJuqqJXtzlERyaHxqlrbqIBzrfUAf_h0qlEDXhJbfWt99lAtINmWKm wwcKC0edwo_Pxf5bygJTX7PAheERWBT0rtKOySYrxyLnDp8yVcjB6obSSClW V7bUNw4HwK5Ir.b67DTIR9Xq.Zk4olbO_rfdh6atzEIaXVqdOYOwIGmx2uqs GVekt9HepYlb3BU.R1NmKY8H10w.efZ_389XWXGoFzIbS5jZJYBNKEv5iDgg lLTs..SXnJcxMLOzBkRenK53XZCWwXAdw_BvG3B3WO_z8yGGHO5kpeeXVkTR hMsn1LV.MDBnRdlcSiV18pM.YEk3PqXEtIvlOuFDyZdk1uww9YbBuZFCEkRH kjuGJgffNyzu5gVFcMoLJmXnG9crAV2Qn_mvL5HYlNx6a Received: from [32.138.66.70] by web120528.mail.ne1.yahoo.com via HTTP; Tue, 09 Aug 2011 09:58:04 PDT X-Mailer: YahooMailWebService/0.8.112.307740 Message-ID: <1312909084.86812.androidMobile@web120528.mail.ne1.yahoo.com> Date: Tue, 9 Aug 2011 09:58:04 -0700 (PDT) From: iliya g Subject: Re: Postgres process To: "raghavendra.rao@enterprisedb.com" , "tgl@sss.pgh.pa.us" Cc: "Kevin.Grittner@wicourts.gov" , "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-428857371-1942103543-1312909084=:86812" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.61 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.812 X-Spam-Level: X-Archive-Number: 201108/62 X-Sequence-Number: 38049 ---428857371-1942103543-1312909084=:86812 Content-Type: text/plain; charset=us-ascii Thanks, Tom. Let me look into this. Sent from Yahoo! Mail on Android ---428857371-1942103543-1312909084=:86812 Content-Type: text/html; charset=us-ascii

Thanks, Tom. Let me look into this.


Sent from Yahoo! Mail on Android



From: Tom Lane <tgl@sss.pgh.pa.us>;
To: Raghavendra <raghavendra.rao@enterprisedb.com>;
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; iliya g <gyozov2004@yahoo.com>; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>;
Subject: Re: [ADMIN] Postgres process
Sent: Tue, Aug 9, 2011 3:45:11 PM

Raghavendra <raghavendra.rao@enterprisedb.com> 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
---428857371-1942103543-1312909084=:86812--