Tom Lane wrote:
> Sailesh Krishnamurthy <sailesh@cs.berkeley.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
invocationof the <application>postmaster</application> must have a shorter <command>ps</command> status display than
thatprovided by each backend. If you fail to do all three things, the <command>ps</> output for each backend will be
theoriginal <application>postmaster</> command line.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073