[ BCC to admin]

I have completed my PostgreSQL session monitor utility, pgmonitor.  I
have recently added the ability to start/stop the postmaster.

I considered adding the ability to set postmaster/postgres command
flags, but decided they are not changed frequently enough.

It still does not work on Solaris under 7.1RC because no Solaris users
have gotten ps_status working on that platform.

I plan to write PostgreSQL articles for the next few weeks.

-- 
  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

                              P G   M O N I T O R

pgmonitor, version 0.42

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.

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.

Bruce Momjian <pgman@candle.pha.pa.us>
Sat, 7 Apr 2001 00:00:16 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
pgmonitor completed

I tried to intall pltcl, but failed when I tried to build a
pltcl.so 
it seems hangging on there forever, what's wrong??
 
su-2.04# cd /work/src/pgsql702/src/pl/tcl/
su-2.04# ls
CVS                             mkMakefile.tcldefs.sh.in
INSTALL                         modules
Makefile                        pltcl.c
license.terms                   pltcl_guide.nr
mkMakefile.tcldefs.sh           test
su-2.04# gmake
Makefile:22: Makefile.tcldefs: No such file or directory
/bin/sh ./mkMakefile.tcldefs.sh
^Cgmake: *** Deleting file `Makefile.tcldefs'
gmake: *** [Makefile.tcldefs] Interrupt


Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com



Sat, 7 Apr 2001 17:55:25 -0700 (PDT)
Jie Liang <jliang@ipinc.com>
Re: [ADMIN] pgmonitor completed
You don't need pltcl, just libtcl.

> 
> I tried to intall pltcl, but failed when I tried to build a
> pltcl.so 
> it seems hangging on there forever, what's wrong??
>  
> su-2.04# cd /work/src/pgsql702/src/pl/tcl/
> su-2.04# ls
> CVS                             mkMakefile.tcldefs.sh.in
> INSTALL                         modules
> Makefile                        pltcl.c
> license.terms                   pltcl_guide.nr
> mkMakefile.tcldefs.sh           test
> su-2.04# gmake
> Makefile:22: Makefile.tcldefs: No such file or directory
> /bin/sh ./mkMakefile.tcldefs.sh
> ^Cgmake: *** Deleting file `Makefile.tcldefs'
> gmake: *** [Makefile.tcldefs] Interrupt
> 
> 
> Jie LIANG
> 
> St. Bernard Software
> 
> 10350 Science Center Drive
> Suite 100, San Diego, CA 92121
> Office:(858)320-4873
> 
> jliang@ipinc.com
> www.stbernard.com
> www.ipinc.com
> 
> 
> 


-- 
  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

Sat, 7 Apr 2001 21:32:22 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [ADMIN] pgmonitor completed
No, I was wrong in even mentioning libpgtcl.  You don't even need that. 
pgmonitor does not connect to the database at any time.  I should run as
a shell script if you have tcl/tk >= 8.0 installed.

> 
> What I need to do to install libtcl
> 
> Do I still need to
> createlang -d dbname pltcl??
> and when??
> 
> 
> Jie LIANG
> 
> St. Bernard Software
> 
> 10350 Science Center Drive
> Suite 100, San Diego, CA 92121
> Office:(858)320-4873
> 
> jliang@ipinc.com
> www.stbernard.com
> www.ipinc.com
> 
> On Sat, 7 Apr 2001, Bruce Momjian wrote:
> 
> > You don't need pltcl, just libtcl.
> > 
> > > 
> > > I tried to intall pltcl, but failed when I tried to build a
> > > pltcl.so 
> > > it seems hangging on there forever, what's wrong??
> > >  
> > > su-2.04# cd /work/src/pgsql702/src/pl/tcl/
> > > su-2.04# ls
> > > CVS                             mkMakefile.tcldefs.sh.in
> > > INSTALL                         modules
> > > Makefile                        pltcl.c
> > > license.terms                   pltcl_guide.nr
> > > mkMakefile.tcldefs.sh           test
> > > su-2.04# gmake
> > > Makefile:22: Makefile.tcldefs: No such file or directory
> > > /bin/sh ./mkMakefile.tcldefs.sh
> > > ^Cgmake: *** Deleting file `Makefile.tcldefs'
> > > gmake: *** [Makefile.tcldefs] Interrupt
> > > 
> > > 
> > > Jie LIANG
> > > 
> > > St. Bernard Software
> > > 
> > > 10350 Science Center Drive
> > > Suite 100, San Diego, CA 92121
> > > Office:(858)320-4873
> > > 
> > > jliang@ipinc.com
> > > www.stbernard.com
> > > www.ipinc.com
> > > 
> > > 
> > > 
> > 
> > 
> > -- 
> >   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
> > 
> 
> 


-- 
  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

Sat, 7 Apr 2001 22:33:13 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: libtcl

What I need to do to install libtcl

Do I still need to
createlang -d dbname pltcl??
and when??


Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Sat, 7 Apr 2001, Bruce Momjian wrote:

> You don't need pltcl, just libtcl.
> 
> > 
> > I tried to intall pltcl, but failed when I tried to build a
> > pltcl.so 
> > it seems hangging on there forever, what's wrong??
> >  
> > su-2.04# cd /work/src/pgsql702/src/pl/tcl/
> > su-2.04# ls
> > CVS                             mkMakefile.tcldefs.sh.in
> > INSTALL                         modules
> > Makefile                        pltcl.c
> > license.terms                   pltcl_guide.nr
> > mkMakefile.tcldefs.sh           test
> > su-2.04# gmake
> > Makefile:22: Makefile.tcldefs: No such file or directory
> > /bin/sh ./mkMakefile.tcldefs.sh
> > ^Cgmake: *** Deleting file `Makefile.tcldefs'
> > gmake: *** [Makefile.tcldefs] Interrupt
> > 
> > 
> > Jie LIANG
> > 
> > St. Bernard Software
> > 
> > 10350 Science Center Drive
> > Suite 100, San Diego, CA 92121
> > Office:(858)320-4873
> > 
> > jliang@ipinc.com
> > www.stbernard.com
> > www.ipinc.com
> > 
> > 
> > 
> 
> 
> -- 
>   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
> 


Sat, 7 Apr 2001 19:36:54 -0700 (PDT)
Jie Liang <jliang@ipinc.com>
libtcl

I believe what we are talking about is diff,
I am trying to install pltcl language on my db not pgmonitor.
When I wand to build a pltcl.so, I got following msg,
I want to know there's any wrong?

Thanks anyway.


Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Sat, 7 Apr 2001, Bruce Momjian wrote:

> No, I was wrong in even mentioning libpgtcl.  You don't even need that. 
> pgmonitor does not connect to the database at any time.  I should run as
> a shell script if you have tcl/tk >= 8.0 installed.
> 
> > 
> > What I need to do to install libtcl
> > 
> > Do I still need to
> > createlang -d dbname pltcl??
> > and when??
> > 
> > 
> > Jie LIANG
> > 
> > St. Bernard Software
> > 
> > 10350 Science Center Drive
> > Suite 100, San Diego, CA 92121
> > Office:(858)320-4873
> > 
> > jliang@ipinc.com
> > www.stbernard.com
> > www.ipinc.com
> > 
> > On Sat, 7 Apr 2001, Bruce Momjian wrote:
> > 
> > > You don't need pltcl, just libtcl.
> > > 
> > > > 
> > > > I tried to intall pltcl, but failed when I tried to build a
> > > > pltcl.so 
> > > > it seems hangging on there forever, what's wrong??
> > > >  
> > > > su-2.04# cd /work/src/pgsql702/src/pl/tcl/
> > > > su-2.04# ls
> > > > CVS                             mkMakefile.tcldefs.sh.in
> > > > INSTALL                         modules
> > > > Makefile                        pltcl.c
> > > > license.terms                   pltcl_guide.nr
> > > > mkMakefile.tcldefs.sh           test
> > > > su-2.04# gmake
> > > > Makefile:22: Makefile.tcldefs: No such file or directory
> > > > /bin/sh ./mkMakefile.tcldefs.sh
> > > > ^Cgmake: *** Deleting file `Makefile.tcldefs'
> > > > gmake: *** [Makefile.tcldefs] Interrupt
> > > > 
> > > > 
> > > > Jie LIANG
> > > > 
> > > > St. Bernard Software
> > > > 
> > > > 10350 Science Center Drive
> > > > Suite 100, San Diego, CA 92121
> > > > Office:(858)320-4873
> > > > 
> > > > jliang@ipinc.com
> > > > www.stbernard.com
> > > > www.ipinc.com
> > > > 
> > > > 
> > > > 
> > > 
> > > 
> > > -- 
> > >   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
> > > 
> > 
> > 
> 
> 
> -- 
>   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
> 


Sat, 7 Apr 2001 20:04:44 -0700 (PDT)
Jie Liang <jliang@ipinc.com>
Re: libtcl