I have a requirement to be able to remotely monitor and diagnose a
production Postgres installation running on a machine with limited firewall
access. When local to the box, I use pgmonitor and find it completely
indispensable. But, from my remote location, I can only slogin to the box
and get terminal access and thus have a problem with the Xwindows display.
Admittedly, I'm not very well versed in Xwindows. Is there any way to
achieve similar functionality but in a completely server based way? I know
pgmonitor is basically based on a series of ps and awk commands. Is there
a way this could be wrapped in a script to provide straight text based
information along the same lines as "top" or "sar"?
Thank you for any insight you can provide.
Marc Mitchell - Senior Application Architect
Enterprise Information Solutions, Inc.
4910 Main Street
Downers Grove, IL 60515
marcm@eisolution.com