Thread: solaris and ps
I read "Chapter 23. Monitoring Database Activity" to monitor postgresql, but on Solaris it doesn't work. I tried "/usr/ucb/ps", but it doesn't work either (I only see the postmaster startup parameters). Isn't there any other solution to see what postgresql instances are doing?
Leonardo Francalanci wrote: > I read "Chapter 23. Monitoring Database Activity" to monitor postgresql, > but on Solaris it doesn't work. I tried "/usr/ucb/ps", but it doesn't > work either (I only see the postmaster startup parameters). Isn't there > any other solution to see what postgresql instances are doing? If the tips on solaris ps haven't helped, you can turn on statistics gathering and check pg_stat_activity. -- Richard Huxton Archonet Ltd
On Thu, Oct 14, 2004 at 11:14:10AM +0100, Richard Huxton wrote: > Leonardo Francalanci wrote: > >I read "Chapter 23. Monitoring Database Activity" to monitor postgresql, > >but on Solaris it doesn't work. I tried "/usr/ucb/ps", but it doesn't > >work either (I only see the postmaster startup parameters). Isn't there > >any other solution to see what postgresql instances are doing? > > If the tips on solaris ps haven't helped, you can turn on statistics > gathering and check pg_stat_activity. pargs should work, but you'll probably have to run it as the postgres user or as root or you'll get "cannot examine <pid>: permission denied". pargs `/usr/bin/ps -opid -Upostgres | tail +2` I just did some tests on Solaris 9 and, curiously, whether /usr/ucb/ps shows the altered argument list or not appears to depend on the lengths of the original and replacement arguments: % ./foo x PID TT S TIME COMMAND 28106 pts/2 S 0:00 baz qux % ./foo xy PID TT S TIME COMMAND 28109 pts/2 S 0:00 ./foo xy As far as I can tell, for /usr/ucb/ps the show the replacement arguments, the sum of the lengths of the replacement arguments must be 2 or more greater than the sum of the lengths of the original arguments. I'm guessing that if the postmaster used a longer status message, then /usr/ucb/ps would show it. I'll test that the next time I rebuild PostgreSQL. -- Michael Fuhr http://www.fuhr.org/~mfuhr/
On Thu, Oct 14, 2004 at 08:24:19AM -0600, Michael Fuhr wrote: > > As far as I can tell, for /usr/ucb/ps the show the replacement > arguments, the sum of the lengths of the replacement arguments > must be 2 or more greater than the sum of the lengths of the > original arguments. I'm guessing that if the postmaster used > a longer status message, then /usr/ucb/ps would show it. I just noticed that this is already mentioned in the PostgreSQL documentation: "In addition, your original invocation of the postmaster command must have a shorter ps status display than that provided by each server process." -- Michael Fuhr http://www.fuhr.org/~mfuhr/
> "In addition, your original invocation of the postmaster command > must have a shorter ps status display than that provided by each > server process." Yes, using PGDATA instead of the whole path eith the -D option worked: now I can see the different status displays.
On Thu, Oct 14, 2004 at 11:16:48AM +0200, Leonardo Francalanci wrote:
> I read "Chapter 23. Monitoring Database Activity" to monitor postgresql,
> but on Solaris it doesn't work. I tried "/usr/ucb/ps", but it doesn't
> work either (I only see the postmaster startup parameters). Isn't there
> any other solution to see what postgresql instances are doing?
/usr/ucb/ps -auxww will work. I've used it thousands of times.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspun