Thank you Tom for pointing to appropriate direction. Below command worked
/usr/ucb/ps -ww <PID>
--Raghav
On Tue, Aug 9, 2011 at 9:15 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> writes:I surely hope you're not still running SunOS. If you mean Solaris,
> Still, my guess we cannot get the process description on SunOS.
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
