Re: set_ps_display on solaris x86

Tom Lane wrote:
> Sailesh Krishnamurthy <sailesh(at)cs(dot)berkeley(dot)edu> writes:
> > Sadly, set_ps_display does not seem to have any effect in solaris
> > x86. At least ps only reports multiple postmaster processes and
> > arguments.
>
> IIRC, you have to use the "other" version of ps to see the process
> status on Solaris. I forget where it lives exactly, /usr/ucb maybe?

Yep, monitoring chapter mentions it:

<productname>Solaris</productname> requires special handling. You must
use <command>/usr/ucb/ps</command>, rather than
<command>/bin/ps</command>. You also must use two <command>w</command>
flags, not just one. In addition, your original invocation of the
<application>postmaster</application> must have a shorter
<command>ps</command> status display than that provided by each
backend. If you fail to do all three things, the <command>ps</>
output for each backend will be the original
<application>postmaster</>
command line.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073