Re: Remote monitoring

Marc Mitchell wrote:
> 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"?

Well, if you enable stats_command_string in postgresql.conf you will
see the queries being run in pg_stat_activity.

Another option is to ssh into the machine, set your $DISPLAY back to
your local machine, and then run pgmonitor. ssh does secure remote X
display.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073