From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Jeff Eckermann <jeckermann@verio.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Roberto João Lopes Garcia <roberto@mha.com.br>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: pgmonitor on solaris
Date: Mon, 26 Mar 2001 12:09:23 -0500 (EST)
Message-ID: <200103261709.MAA17936@candle.pha.pa.us> (raw)
In-Reply-To: <08CD1781F85AD4118E0800A0C9B8580B0949D6@NEZU>
[ Charset ISO-8859-1 unsupported, converting... ]
> The problem is that Solaris uses the "original" version of Awk by default
> (apparently nobody knows why).
> This version lacks many features which have been available in later versions
> for approximately forever (in computing chronology :-)).
> Two other versions exist on Solaris:
> * "nawk" ("new awk", i.e. the updated "old awk")
> * /usr/xpg4/bin/awk (another, posix-compliant awk).
> Solaris seems to be weird this way. Other platforms don't seem to have this
> problem. Linux and FreeBSD, for example, use GNU awk, which would have all
> of the required functionality and more.
OK, I have confirmed you are correct. I find at:
http://www.oase-shareware.org/shell/articles/awkcompat.html
a chart comparing awk versions on different OS's and it shows gsub() not
supported on Solaris, Solaris 2.5,2.6,5.7,5.8 (sparc), /usr/5bin/awk.
nawk does have it.
I have put a 0.28 version of pgmonitor on my web site that tests for
awk/nawk/gawk and gsub(), and uses the one that works. Can someone test
this on Solaris and let me know if it is OK?
pgmonitor README attached:
---------------------------------------------------------------------------
P G M O N I T O R
pgmonitor, version 0.28
The main web site for pgmonitor is:
http://greatbridge.org/project/pgmonitor/projdisplay.php
You can download the most recent version from
ftp://ftp.greatbridge.org/pub/pgmonitor
This tool allows monitoring of PostgreSQL activity. It requires Tcl/Tk
8.0 or later. It may require modification of the 'ps' flags for certain
platforms. It is known to run on *BSD, Linux, and HPUX.
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.
Bruce Momjian <pgman@candle.pha.pa.us>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pgman@candle.pha.pa.us, jeckermann@verio.net, tgl@sss.pgh.pa.us, roberto@mha.com.br
Subject: Re: pgmonitor on solaris
In-Reply-To: <200103261709.MAA17936@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox