Tim Ellis wrote:
> If pgmonitor can take a machine/port argument, then you should be able to
> run pgmonitor on your homeworkstation connecting to remotedb on
> pgsqlmachine (thus avoiding the overhead of X traffic over a slow pipe). I
> have done such a thing with other RDBMSs (specifically, I connected to a
> Sybase 'instance' on a remote machine to do CPU and disk monitoring using
> a GUI tool running on my home workstation).
Actually, pgmonitor never connects to the database but rather runs 'ps'
on the local machine, so you do need to run ssh. It never connects to
the PostgreSQL server port.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073