1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
P G M O N I T O R
pgmonitor, version 0.55
The main web site for pgmonitor is:
http://gborg.postgresql.org/project/pgmonitor
This tool allows monitoring of PostgreSQL activity. It requires Tcl/Tk
8.0 or later. The postmaster startup/shutdown button only appears for
the PostgreSQL superuser and root.
Pgmonitor only works when run on the database server machine. To use it
remotely, log into the remote machine, set the DISPLAY variable to point
to your local X server, and start pgmonitor. Pgmonitor will then run on
the remote machine, but will display on your local machine.
Pgmonitor uses 'ps' to display backend process activity. It uses 'gdb'
to display running queries, and 'kill' to cancel queries and terminate
database connections.
Pgmonitor stores your most recent refresh and sort settings in the file
~/.pgmonitor. This file is used to reload your defaults every time
pgmonitor is started.
If you are running PostgreSQL 7.1.0 or earlier, the 'query' button will
not work unless you compile PostgreSQL with debug symbols (-g), or apply
the supplied patch 'query_display.diff' and recompile PostgreSQL. The
later method is recommended. 7.1.1 and later needs no modifications.
It will not work on a 'postgres' binary that is stripped of all symbols.
It is known to run on *BSD, Linux, and HPUX. It works on Solaris if the
postmaster arguments used are shorter than the ps status display used by
PostgreSQL. It may require modification of the 'ps' flags for other
platforms.
For porting assistance, there are 'set debug' and 'set show_all' options
in the script. 'debug' outputs status information while pgmonitor
running, and 'show_all' shows all PostgreSQL user processes, such as the
postmaster.
The copyright for pgmonitor is the same as the BSD copyright of
PostgreSQL.
Bruce Momjian <pgman@candle.pha.pa.us>
|
