Thread: PostgreSQL admin or monitor program?
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
> 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
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>)
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
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) >