Re: monitoring database activity on solaris

Tom Lane wrote:
> "David Parker" <dparker(at)tazznetworks(dot)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(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