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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
