Remote monitoring

From: "Marc Mitchell" <marcm(at)eisolution(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Remote monitoring
Date: 2002-09-05 23:30:45
Message-ID: 016801c25534$423316e0$7501050a@eisolution.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)eisolution(dot)com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-09-06 04:25:17 Re: Remote monitoring
Previous Message Chris Johnson 2002-09-05 22:24:42 question about WAL.