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