Re: monitoring database activity on solaris

Tom Lane wrote:
> "David Parker" <dparker@tazznetworks.com> writes:
> >> The best bet is to make sure that your postmaster start script
> >> invokes the postmaster as
> >>     postmaster
> >> no more.  No path (set PATH beforehand instead).  No
> >> command-line switches (whatever you might want there can be
> >> put into postgresql.conf instead).
>
> > OK, thanks. We're using pg_ctl to start it at the moment, but we can
> > obviously change that.
>
> Hmm.  Seems like it might be worthwhile to modify pg_ctl to use PATH
> and PGDATA instead of making the command line longer.  AFAIR it doesn't
> insist on putting in any command-line switches except -D, and that's
> easily replaced ...

People like the long postmaster line because it allows them to see the
data path for multiple postmasters.  I think we just have to access
Solaris as partially broken, unless we want to do this only on Solaris.

--
  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, Pennsylvania 19073