Thread

1. PostgreSQL admin or monitor program?

   Gary Huntress <ghuntress@mediaone.net> — 2001-04-08T00:06:00Z

   Is there a PostgreSQL equivalent for the MySQL program mysqladmin?   My
   system load jumped and using top I saw that it was due to postmaster.  With
   mysqladmin I can show the mysql processlist and see the list of connections
   and who is doing what.  I've looked through the indexes for all the
   documentation at http://www.postgresql.org/devel-corner/docs/ (and I've read
   most of them) but I don't see an equivalent function.
   
   What is the best way to do mundane things like list active users and their
   state, list stats about the server (mysqladmin will list uptime, number of
   queries issued, queries per second etc), kill a user, etc?   Can psql do
   this or do I need a seperate client?
   
   --
   Regards,
   Gary "SuperID" Huntress
   =======================================================
   FreeSQL.org offering free database hosting to developers
   Visit http://www.freesql.org
   
   
   
   
   

2. Re: PostgreSQL admin or monitor program?

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-04-08T21:54:53Z

   > Is there a PostgreSQL equivalent for the MySQL program mysqladmin?   My
   > system load jumped and using top I saw that it was due to postmaster.  With
   > mysqladmin I can show the mysql processlist and see the list of connections
   > and who is doing what.  I've looked through the indexes for all the
   > documentation at http://www.postgresql.org/devel-corner/docs/ (and I've read
   > most of them) but I don't see an equivalent function.
   > 
   > What is the best way to do mundane things like list active users and their
   > state, list stats about the server (mysqladmin will list uptime, number of
   > queries issued, queries per second etc), kill a user, etc?   Can psql do
   > this or do I need a seperate client?
   
   Sure, try my new pgmonitor tool:
   
   	http://greatbridge.org/project/pgmonitor/projdisplay.php
   
   
   -- 
     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
   
   

3. Re: PostgreSQL admin or monitor program?

   Alvaro Herrera <alvherre@atentus.com> — 2001-04-09T21:47:25Z

   On Sun, 8 Apr 2001, Bruce Momjian wrote:
   
   > > What is the best way to do mundane things like list active users and their
   > > state, list stats about the server (mysqladmin will list uptime, number of
   > > queries issued, queries per second etc), kill a user, etc?   Can psql do
   > > this or do I need a seperate client?
   >
   > Sure, try my new pgmonitor tool:
   >
   > 	http://greatbridge.org/project/pgmonitor/projdisplay.php
   
   It says "invalid project specified", but you can reach it through
   http://greatbridge.com/browse.php?85
   
   -- 
   Alvaro Herrera (<alvherre[@]atentus.com>)
   
   
   

4. Re: PostgreSQL admin or monitor program?

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-04-09T21:49:06Z

   Just worked for me:
   
   	http://greatbridge.org/project/pgmonitor/projdisplay.php
   
   Strange.
   
   > On Sun, 8 Apr 2001, Bruce Momjian wrote:
   > 
   > > > What is the best way to do mundane things like list active users and their
   > > > state, list stats about the server (mysqladmin will list uptime, number of
   > > > queries issued, queries per second etc), kill a user, etc?   Can psql do
   > > > this or do I need a seperate client?
   > >
   > > Sure, try my new pgmonitor tool:
   > >
   > > 	http://greatbridge.org/project/pgmonitor/projdisplay.php
   > 
   > It says "invalid project specified", but you can reach it through
   > http://greatbridge.com/browse.php?85
   > 
   > -- 
   > Alvaro Herrera (<alvherre[@]atentus.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
   
   

5. Re: PostgreSQL admin or monitor program?

   Mitch Vincent <mitch@venux.net> — 2001-04-09T21:55:28Z

   Sort of funny but the one Bruce gave works fine, the one you give throws a
   404 error :-)
   
   -Mitch
   Software development :
   You can have it cheap, fast or working. Choose two.
   
   ----- Original Message -----
   From: "Alvaro Herrera" <alvherre@atentus.com>
   To: "Bruce Momjian" <pgman@candle.pha.pa.us>
   Cc: "Gary Huntress" <ghuntress@mediaone.net>; <pgsql-general@postgresql.org>
   Sent: Monday, April 09, 2001 5:47 PM
   Subject: Re: PostgreSQL admin or monitor program?
   
   
   > On Sun, 8 Apr 2001, Bruce Momjian wrote:
   >
   > > > What is the best way to do mundane things like list active users and
   their
   > > > state, list stats about the server (mysqladmin will list uptime,
   number of
   > > > queries issued, queries per second etc), kill a user, etc?   Can psql
   do
   > > > this or do I need a seperate client?
   > >
   > > Sure, try my new pgmonitor tool:
   > >
   > > http://greatbridge.org/project/pgmonitor/projdisplay.php
   >
   > It says "invalid project specified", but you can reach it through
   > http://greatbridge.com/browse.php?85
   >
   > --
   > Alvaro Herrera (<alvherre[@]atentus.com>)
   >
   >
   > ---------------------------(end of broadcast)---------------------------
   > TIP 2: you can get off all lists at once with the unregister command
   >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
   >