#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2001
    Location
    Chicago, IL
    Posts
    85
    Rep Power
    13

    monitor database activity


    Are there any (gui) programs out there that I can use on my remote machine to monitor db activity?

    Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13
    This is the only one I know of so far. I haven't tried this one yet. "This is a Tcl/Tk script that displays current database connections, and allows you to view the currently executing query, cancel the query, or terminate the session. You can also start/stop the postmaster. "

    http://gborg.postgresql.org/project/...rojdisplay.php

    Also I stold this one from rycamor's thread, but here's some docs on monitoring connections from command line:


    http://www.postgresql.org/idocs/inde...onitoring.html

    For alot of administration and development tasks, pg admin, is a nice tool also:

    http://pgadmin.postgresql.org/pgadmin2.php?ContentID=1
    Last edited by Ted Striker; October 15th, 2002 at 07:01 PM.

IMN logo majestic logo threadwatch logo seochat tools logo